Excel Programming [Archive] - Page 52

Enhancements to Sub FillColBlanks by Dave Peterson
To change Columns(4).Rows.Count
Error sending sheet in mail body
Unhide sheets
sumproduct & dates & similar data
How do I calculate at timed intervals?
need an OR in the countif statement
Excel Macro to choose a line
PRINT command button
Calling procedures of a different project
searching cells with a macro
Using Excel VBA to Make Edits to A PowerPoint Pres
How do I only recalculate 1 cell
sorting named range data
Extracting 3 Arrays from 1 Array
OR statement in a Countif
Error in Retrieving Formatted Cell Value
How to get specific cell data from one sheet!
How do I activate the next cell in a selected range?
Scan pdf417 barcode = is scanned, actually tab data to next cell.
Simple use of ActiveX Command Button -
Get last column
Why Am I Getting This Error Message Please?
Delete all objects on sheet except...
Autofill today's date Everyday
Copy from file1 sheet1/file2 sheet1 last blank row
Macro hide rows with blank data in cells
macro doesn't hide columns for an unexplicable reason
pulling data from one worksheet onto another
Functions not working in Vista... (custom defined viewable as modules with Alt-F11)
Excel calculate the z factor automatically
Bound Control On A Form Problem - Office 2003
How to seperate measurements 1.375 in (35 mm)
SQL connection string giving type mismatch
sumproduct
Range of cells seem to be initialized randomly
Can a sub be deleted via macro?
VLOOKUP
Embedded pictures
Pivot Tables using VBA
C++ DLL from VBA
Loading a Userform
User Name
get validation on a cell clicking a button
ActiveWorkbook.Sheets.Select
Tuition on 'copyorigin'
Command button on worksheet
Name of cell range not accepted in Conditional Validation
File opens second copy of itself for no apparent reason
taborder on Excel form
turn off error handling
New array with old array elements
Lookup second/third values
Down One Row
hide rows if cell in a column has no value
Excel.Application error
If X = Y then (when it doesn't have to be an exact match)
How to Loop and Read the Cell until the end of worksheet
Object: smart way to assign a value as for an array?
Arranging data from different Column
How to evaluate the size of each worksheet in a workbook?
MsgBox using cell references
measuring load time
showlevels is very slow
Copying sheet with hidden columns
Missing Library Problem
External data validation
copy certain cells
Computer "name"
subtotal question
Replace Contents of Destination Cells
Closing WINWORD.EXE from Excel VBA when my main proc ends
Looping a Macro
Search in multi dimensional array - URGENT help
Unfixing source data range for a pivot table using vba
Advanced filter criteria for <>
Adding a micron symbol to text string
I found a bug
Limitation to Collection Object
values are decimal
xy scatter chart using multiple dynamic range as source
Data Validation List - Multiple Columns
Instruction Delay
Web Query
dash ports
Calculating speed
last â€œDate Modifiedâ€ of separate modules?
Updating ExcelName Registry Key
Excel Macros Disabled
Prevent opening solution on other (older) versions (Excel 2000) et
hide column script, range address?
Excel VBA Compile Error when dimensioning jagged array
question about creating variable from 2 strings
Getting error with load/unload of UserForms??
Excel Recent Files Issue
Find-Copy and Paste
Repeating Named Range
Macros, Excel 2000
ZOrder Behavior Changed in Excel 2007?
ZOrder Behavior Changed in Excel 2007?
Worksheet_SelectionChange question
Help .. Lookup and match UDF/macro
Copying Cells on Enter
Excel 2003
Does Excel have Threshold function?
api - tracking LostFocus or Exit event of a combobox
api - tracking LostFocus or Exit event of a combobox
Catching RNG before getting changed?!
Excel 2007 Bug - "Locked" Property is Broken for Shape Objects
Excel 2007 Bug - "Locked" Property is Broken for Shape Objects
Re: Email code Question to Ron de Bruin Please
INDEX function issues
lines
Automate Access from Excel to run hidden
equipment service tracking
tabbing to textboxes in multipage tab control
Work book with working days only
External File Validation?
Calendar poping up on form when not wanted
Simple question?
Interop.Excel Split and Copy
runtime error #9 subscript out of bounds #4
hotkey for command button on Excel form
VLOOKUP and then some
Speed up code Removing duplicate rows
Can you change scanned input of an = to tab in excel?
Matching multiple userform height and widths after resizing
Calling a module only when a sheet is actually "activated"
looping through questions
E-Mail Sheets Q
Error in external named range
autosize cells
ExPaste-xl2ppt, a powerful Excel add-in
Import from Outlook/Contacts
Copy worksheet to another file
Is there a way to count how many elements there are in an array?
Macro for copying cells above empty cells
why it does not work????
macro for copying cells above empty ones
counting elements of two arrays
List Box Head-Scratcher
matching similar values
Re: Help requested for conditional formatting
Lower case "a" in "application"
Network problem
Delete Variable spaces at beginning of a range
how to pause a 'save-as' and continue after input
VBA find today's date in Column A
Fill work day
Amend Code Help Please
Import Data button
Range name Database only works on one sheet
COUNTA
Changing linked cell runs ComboBox code
Insert picture with macro
Excel slowing down....
Excel VAB+ADO connect ACCESS with SQL
Count Variable
Worksheet_change error
Unbelievable error 457
Get last column
RE: Macro for finding duplicate names(easiest way!)
XL 2007: Conditional Formatting not saved properly
Data Validation redux
Calendar control
Validation
When changing document information how do you show the date and t.
VBA Code
Unwanted Procedure & Do While
For each Workbook limit?
How do I place a chart on an Excel VBA Userform & drive w/spinners
Email Ron or Dave Please.
Where to declare module-level variables?
Formula returns "#VALUE"
find the sheet of an active chart (VBA)
Conflict in assigning values to a cell from another cell
Dynamic scroll bar max limit
Using a variable to determine row selection
PivotTable: Excel cannot complete this task with available resourc
runtime error 9 subscript out of range #3
Need help with rounding in VBA code
Using the data in the last cell
Speech Activation for Messages
Speech Activation for Messages
2 auick questions please
Stubborn date format and range copy
Macro to LookUp Data and Copy/Insert only Non-Duplicated Rows
Re: Line under first menu item
Copy a R1C1 formula to a user defined range results #NAME? error
Using Certain Forms From The Pivottable Wizard in Excel VBA
Automate Tab Color
Sheets("Sheet9") Error
Break on Calendar Year
Execute a macro in another file with an argument
Get data from database via web
How do I calculate the z factor automatically
Where are my custom toolbars in 2007?
runtime error 9 out of range subscript #2
how to assign contents of a cell to a macro variable
RE: Offset(0, 1) and then Offset(1, 0)?
How do I calculate the z factor automatically
If sheet exists, delete
Slow code
runtime error 9 out of range subscript
Copy to destination of "A50" + value in I12 (sequence#) A51,A52
Re: Format Cell based on two other cells in same row.
Automate MS-Access from MS-Excel
Sort Worksheet Range from another worksheet range, Excel 2000 & 2003
Re: Excel's GROWTH function?
Disabling Specific Menu Bar Choices
Rolling back 'folders delete' using VBA
Replace old sheet with new without losing formula ref
Excel 2003 ODBC driver without support for XML files?
Re: Matric vba array
Formula in macro with variable sheet names
Copy and paste contents of one sheet into another
Selection.Cells vs Range reference - strange behaviour (using 2007
Nested With's
Moving Shapes within VBA
Upgrade options from XL2003/VBA/VB6 to XL2007/VB.NET ...
pivot managment through VBA
List of Fonts
Run-time error after calling a procedure
List box in tool bar
partnumber search and select the cell
define destination sheet
OPC Data Collector
Help to Break links please!!
can't find macros in a macro-enabled workbook
Hourly Refresh
Hide rows using VBA
Re: Excel's GROWTH function?
Yield (ROI = Return Of Investment) issue
manually run macro's
Re: dynamic range counta error
Retrieving Textbox values from another workbook
Using formula in code...Part 3!
Can you specify an Array as a Target??
Compare cell contents in adjacent columns
RE: Copy data matching date and retain information in a monhtly report
Call Sub From InputBox
Search and select a cell when pressing enter
Dropdown Options
Re: Using VB.Net, How Do I Put a Picture (jpg) Into a Cell ?
Re: Changing the Font Size and attributes in a message box
Re: dynamic range counta error
Re: Selecting a file in Windows Explorer
Graphs to eps image
Can't Find Project or Library
Merge two sheets into third sheet
Numeric
Re: Update Links Stopping Workbook_Open Routine
Re: help on circular reference and MINIMUM value to be found
Help with calling Data Form
Data inputted accuracy check
Using formula in code....Part 2!
Copy a Sheet to New Sheet Q
Edit Pivot Query in Code
Re: pointers in VB
Re: Comma separator for numbers
How to set active cell range to an variable
Re: How to Increment Time using EXCEL ??
Re: location of combobox and chart
Re: Fill combo box from range
Re: merging all macros into one
How to pool Print Jobs
Help Please
Run-time Error 1004 - retry x times or end
testing efficieny/speed of a macro
Office 2007 Filter Copy Issue
Printing a certain amount of pages based on amount of data
Concatenate cells in one column of value in another column is same
Need some help with codes
Combining logic IF with string searches
Using ADO with INSERT query
Using ADO with INSERT query
Using ADO with INSERT query
Error handling
Macro save as from Template
Read and write an Excel file
access file based on last saved date/time
How to make tab name match cell on another sheet?
find question
runtime error 9, subscript out of bounds error #2
Can you use formulas to manipulate the fill color of a cell?
RE: Can you use formulas to manipulate the fill color of a cell?
waiting for another application to complete an OLE action.
Help Needed With Message Box
Date filldown
Two Worksheet Change macros in same worksheet? Is it possible?
Programmatically show and hide portions of worksheet?
Problem Sorting Excel Range in VBS
Macro Security to "Low"
cut rows to another sheet if a specific cell NOT BLANK
Code to add Range Value produces nothing
Writing a macro in Excel that Refreshes External Imported Text File
Code Procedure for multiple sheets
Find existing number in another workbook
List box to a Cell
Issue with filenames using FileSystemObject
AutoFilter Header Row
How To Link To An External Dynamic Named Range
Using a variable for the 2nd paremeter in a vlookup
Can I end a sub on error?
Left as a condition in SUMPRODUCT
Finding multiple values
Number of Worksheets in a Workbook
Excel Printout runs off page
Help with SUMIF in VBA
Macro Control
get application, object error
Pivot Table with no "Blanks"
List Box Setup
Last cell with data in...
Using If Then Else within a Macro
Listbox Scroll Problem
Prefill a text box on a form
Match Formatting
Excel Charts on Windows Forms
Delete rows with duplicate information
Test to see if Sheet exists
Get data from Outlook Public Folders in Excel
Highest Value In A Range
Need code to close minimized workbooks in BeforeClose event
dropdown value
How to get the PageBreaks not to appear in the middle of the table
How can I get a macro to know when it false and run a different ma
Is there a formula that can display the Tab Name? If not can a Ma
Defining an R1C1 style dynamic named range using vba
Links and Add-Ins Error
Entire Column - Dave Peterson
Worksheet_Calculate
Add-Ins menu in Excel 2007 diseppeares?
formating a cell to pick current date and update daily
Performing Data Transformations
Rename a worksheet that includes a cell refeerence
monitor a specified range ( OnChange)
Debug to Output
The "temporary" parameter of CommandBarPopup.Controls.Add
Loop through cells in columns..
Deleting #N/A
Save on sheet shift
Calculate cell once (on workbook open)
HOW DO I FORMAT A CELL IN EXCEL TO PICK CURRENT SYSTEM DATE
Last column...
Macro Running Twice
Copy data from one workbook to another existing workbook
Find & replace string in text
Function to display username/networkname
Returning Image Details
How to encrypt excel pki
Hyperlinks from one excel sheet to another in VBA
odbc connections in excel 2003
excel 2003
ScreenUpdate Usage
Unprotecting worksheets only if you have the password
run time error #9, subscript out of range
Copying data from cell to other on click or color change
VBA Functions
How do I set up two cells with a reciprocal formula?
Test Date of External Data Source
How do I create a macro to add a zero to end of a cell? or cells..
RE: How do I set up two cells with a reciprocal formula?
Calendar control
Dropdown Box Update
Print to PDF
Block Manual Entry
waiting message
Color Sort
Calendar control
Can you use FileCopy to convert a file as well?
Determine what row is currently selected
StrComp
Question about a Variable being Nothing
How to copy a drawing image between sheets
Picture Problems
if statement
Use value in cell as numeric reference to a row, within a sum func
Activating EXCEL window from PowerPoint
RE: Picture Problems
RE: if statement
Run-time error '1004'
RE: Use value in cell as numeric reference to a row, within a sum func
cell comparison
RE: if statement
Problems using Worksheet_Change
RE: Question about a Variable being Nothing
RE: Can you use FileCopy to convert a file as well?
Virtual AutoFill Macro
cell comparison
Make a particular tab visible on a forms tab control
RE: run time error #9, subscript out of range
RE: Color Sort
RE: Print to PDF
Excel 2007
Can Excel XML validation be done on Web?
RE: Determine what row is currently selected
RE: Determine what row is currently selected
RE: How do I create a macro to add a zero to end of a cell? or cells..
Get column count used range from S to IV
RE: Problems using Worksheet_Change
Macro Not Completely Working
Using formula in code
RE: ScreenUpdate Usage
Userform to size to display
How to org my questions
RE: waiting message
Test For Add-Ins
activate VBA
Want VB form to show in Excel Worksheet
Microsoft Visual Basic- compile error: can't find project or libra
print/save macros
Get outlook contacts from a Public folder instead of DefaultFolder
RE: Use value in cell as numeric reference to a row, within a sum func
RE: Use value in cell as numeric reference to a row, within a sum
Adding a hyperlink to a macro generated e-mail
Automating Refreshing Part (III)
Need autofilter and data extracting help
RE: activate VBA
RE: waiting message
Simple Custom Function???
RE: Test For Add-Ins
RE: Unprotecting worksheets only if you have the password
Define variable from cell to open a file
Copy/PasteSpecial Not Pasting all Formatting
RE: How do I create a macro to add a zero to end of a cell? or cel
RE: Test Date of External Data Source
RE: Macro Not Completely Working
rename message
RE: How do I create a macro to add a zero to end of a cell? or cells..
Filter duplicate data in excel spreadsheet
RE: Question about a Variable being Nothing
RE: cell comparison
RE: activate VBA
RE: How do I create a macro to add a zero to end of a cell? or cel
protect sheet problem
RE: activate VBA
Same Office 2003 but different VBA Tools>Reference (object ref.)
Excel 2003 hangs
Changing Value
Multiple Workbooks
RE: Picture Problems
radio buttons
Need help creating VBA procedure for Open event
RE: waiting message
FIND Beginning of field and add C to end of the field
Define variable from cell to open a file
RE: Test Date of External Data Source
screenupdating problem
RE: Using formula in code
RE: Simple Custom Function???
RE: Define variable from cell to open a file
RE: Same Office 2003 but different VBA Tools>Reference (object ref
RE: Test Date of External Data Source
RE: Picture Problems
Copy Selection doesn't work
Text output
Programmatically show/hide portions of worksheet?
listbox concatenate
Hiding a From Button
Non-programmer needs help with search function
Immediately Entering Break Mode
Obtain Path on open workbook
Combobox which are dependent
Check Box
path problem
sharing between spreadsheets
=IF ..OR.. =IF
Simple Text Editing Macro Help
Deleting rows from mutliple sheets
Macro help needed
define variable range
advancedfilter action
Inputbox default Question
path problem
looping to through rows
Subtotals problem - wierd!
group/ungroup
Distributing A Custom Menu
Is there a way to give range names (especially with relative reference) for series names and series values in Excel 2007 graphs?
Inserting blanks
Copying
Identify Shapes
Merge (not consolidate) workbooks?
EntireRow
coding vba
Ensure items in a list aren't entered twice
Code correction pls help
Partial find and full replace
Opening new excel file & inputting data into cells
Changing File Name
Changing File Name
Flash Screen/Timeout msg box
Shortcut for Format Painter
Combo Box Click Event
Create loop to insert two rows after every row of data
Code that executes against any Excel file
Free Excel and PowerPoint Backgrounds
VBA Combo Box
embedded WindowMediaPlayer keeps resizing
using checkbox to calculate another cell
Custom Menu and Menu Items
Button On Wowsheet
Copy Data from one workbook to another
password for end user
Gray Treeview item in VBA
PivotCache.Refresh
Excel.Workbooks.Open behaviors differently in VBA and VB
Dates and Combobox problems
Concatenate non-concurrent cells
Creating and accessing PDF
Recorded single column insert in macro. Macro inserts two not one
Qualifying macro run according to current selection
Retrieving value from range name
Outline level
I need the code for Audio Warning!
Hide a worksheet
Can't copy and paste the comments
Dynamic Range based on cell contents
Sort works in 2003 but not in 2000
Insert row and copy cells from the currently selected row
LegendEntries
copy cells to end of range in other column
sum for each month
move cell values over 2 cells
Autmating CSV Import???
Workbook_Open does not work
macro button to unprotect entire workbook (used after password ent
Chancing Excel worksheet
EXCEL: Feeding data into model and recording multiple output value
Comparing columns and intersection
Using Solver with Named Ranges
Looping through selected charts
Automating Refreshing (Part II)
Copy/Paste Worksheet to End of Workbook
some code sets a variable to a sumif formula, offset 2
Resizing Checkbox
Routine procedures/formatting same as previous cell
Macro pt.RefreshTable
Determine last row while autofilter is activated
Print condition and autofilter
what exactly does Exit sub do?
To set command for total amount
Copy command
Trying to import multiple text files using "fixed width"
Help with paste special
"Object Required" not displaying
Problem with VBA Macro Consolidating data
Finding a Sheet
Button to activate a macro
Macro Continuation
Hiding/unhiding columns based on user selection
Excel to Outlook email
Delete rows where colums match
ISNumber
Macro Problem
timer ticker
Linking to cells on a spreadsheet with controlled access
Can't find Custom Toolbar attached to workbook
Sorting row data?!
last cell without a blank
Opening notepad file then sending to back
Double click cell to execute macro
formating RichEdit
Closing Userform
user interface only question
i dont want vlookup to solve this
mousedown in a graph
Deleting first empty row along with the next 700 rows
Search across rows
Help with ActiveWorkbook.SaveAs
I am looking for an Action Log format
Check File Open Macro
Select Case in ComboBox
Using VB to auto generate email - unable to get stationery
Copying data
Form focus
Focus in a form
Extracting text from a string
Office 2003 @ using 100% memory
Row height & Column width locked?
Excel equivalent to Eval function
Look at numbers between 2 numbers and copy the complete rows to a worksheet.
Access remote database with IP address
VBA format for a variable cell selection
Autofilter or SpecialCells-related bug?
Establishing which rows are currently visible due to filtering
programming
Macro Recording 2007
runnung word
Disable "Move or Copy sheet "action
Identify Blanks; All Listed in Column AX
How can i secure excel files if copied from office server?
Upgraded to Excel 2007 "Compile error"
Append Excel Data from a named Range to an Exceldatabase
Need to Loop some code based on a count of Cells
Way to change or update the macro
disabling custom menu upon closing workbook
Macro for Deleting Specific Rows?
combo box in several cells
go to the right worksheet
MultiPage UserForm - Need to Prevent Duplicate TextBox Entries
VBA Code vs Public Function
Stop Macro
Search Listbox Values
Combo Box Display Multiple Column Info After Selection Made
Drop-down box & code
Sending Excel ranges to Word as Metafile pictures
AutoTextMacros.xlt: Solution?
How to retrieve Excel column as a string (AAA instead of 703)
vba browse button set to current directory
Copy tables from MS Word
Changing Cell Color by clicking on a cell
Runtime Error
Excel VBA macro
Cell colours according to date
Renumber "Microsoft Excel Objects" SheetN (XXX) ...
Change Event
Disable Copy/Paste
Excel 2003 loosing Database Queries
Clearcontents takes long, long, time
Macro to name a worksheet with a date variable?
Override normal VBA when clicking on a add-in (BEx) toolbar button
BCC global distribution list
Is it possible to make an excel macro to work with all sheets?
Protocol in Immediate window?
Open Access 2003 or 2007 from Excel
Using LINEST with a sparse data row?
Refreshing automatically
Background in email
Making a text box active when returning to a screen
The Current .Net Security Policy does not Permit...
how ot keep value and drop formula while copying
control toolbar combo box and command button
Editor Issue
Creating function
Error Not Displaying, Instead macro just ends
auto insert worksheet name in dynamic named range
creating a function
Determine if template file is dirty
how do i send a named range as the body of an email
Save As name
Populating data in ComboBoxes on UserForms
Data Validation and Error Reports
Addin conflicting with Workbook Module
Find last row and delete from +1 to end
open data form when worksheet opens
Disable "Move or Copy sheet "action
Modifying a Macro - Help Please
Clipboard is empty or not valid
Merge cells if value is zero
stop auto macros running when opening a file by code
Updating VB for info entered in a sheet
Dir for folder name?
Type of variable
creating form/filter in Excel
geo rectify coordinates in vba
vba command
Macro to create a schedule
Please help me with running this macro in Excel 2007
Using VLookup in VBA code with variable range
Date ranges
tabbing
Multiple IF NOT OR
extract data from web
thanks
Enter Button
Print String from VBA
Sort/Search Arrays
Advanced Filter not working correctly in macro
Accessing another workbook's data
Sum the value of cells, when cells contain errors
Sorting problem
Macros
locked cells and code
Code needs tweaking :P
2003-->2007
Stopping a Macro
Place Cursor in A1 on all Sheets Q
Enhancements to sub which writes cell value to comments
2003->2007"unable to set the Left header property of the PageSetup
ActiveWorkbook.SaveAs in excel 2007
Getting data from different worksheets in another workbook
Referencing workbooks in macros
Insert picture from filename & path in sheet's cell
update
Method proceeds but not taking action-Gurus help here
VBA compile error with Split Text Function
Extract Data from Text Files
image1.bordercolor not showing
Background Calculation acts as though it's disabled
pass value to excel userform - is there a constructor? how to pass
VBA code to copy and paste by values from one Excel workbook to another
Worksheet Activate
highlight a row when total is in column A
run all worksheet macros
Updating links in a spreadsheet
Listbox Selection
sounds easy but I can't figure it out.....
I receive "isref" when i do an autofill in a column in Excel
Let the user select a range from a window
slower by 10 times by adding an easy function????
Multiple Language in Excel
Another Userform Date Problem
How to break the rowheight limit
Dynamic linking or referencing of cells
Run-time error '1004' - The file could not be accessed.
What can cause Excel to save slow?
VB Script to Remove Letters from a number
Can you ask a chart which worksheet it's data is located?
Trouble Adding Worksheet via VBScript
password recovery tool
Parse Data - Code form Don G.
Open XLS as though an XLT - unsaved copy in memory
Link loses formatting
Referencing Cell Location
Define Range Question
Test if Worksheet is not in an Array
Add result feilds to a pivot table
value doesn't get passed to a sub-routine, loop doesn't iterate
Vlookup Question
Date format problem on form
Loop until X or Y?
Copying non-contiguous cells
is it possible to have excel insert zeros into data??
Inserting a row in excel 2000 although the worksheet is protected
Find Blank Cells and List Each Cell Address in Another Sheet
sorting a worksheet with vb code
Row and Column Reference 2007
Selection.Copy throws an Object Required error
Delete all cells in range matching certain values
Validation Object error
If the sheet exists...., then
Excel running Access query
save Changes and close book
2 problems with my vbs script
Overwrite saved workbook in VB Script
Real Time Graph
How to use VBA to copy selected data from one worksheet to another
Import Data from txt file
Loop +2, +4, etc. help
Receiving error 1004 - Method 'Rang' of object '_Global' failed
Next Loop
Time Sub
Automatically Selecting "Yes" in an Externally Called Message Box
Set Row Height depending on cell content...
I want to put the text in the cell of column B in front of the the text in column D.
reformat to get more hierarchical view
Kill a file
Goto in a sheet
2003-->2007"programatic accses to visual basic project is not trus
Copy data and page break settings from 1 sheet to another
Fill the cell in column D if column D is empty
Pivot table Page field content display?
Shell Script
Use AddIn to Open an addtional Excel Workbook
2003-->2007 recognize if i'm in 2007 or 2003 via code.
How to auto update currency exchange rates in EXCEL from website
Insert line every x lines until end of data
Automation error with XLA addin, fails on commandbarbutton onaction
Help
Data Validation blanks
need to divide value across added rows
inserting page-breaks
Programming the VBE Find/Replace dialog?
Duplicate value are not being removed
label position affected by wide screen?
for next loop problem
Insert image from Cell value
Worksheet printing
How to Differentiate between a Student's Score of "0" and a Score of Null?
run macro on other computer but not this one (workbook open event)
Connecting to SQL -Looking for best methods
Debug.Print convert vba
Debuging Macros
Probelm with Application.Run Method
time question
Re: Special SUMIF Formula
Going from total to details
Supress Confirmation Prompt
Auto_open to check for folder
copy columns paste in rows
use of variable in array formula
reverse or flip rows
Sub to write formula results into comments
run macro in workbook open event once only
saving web pages
Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal)
Reverse Values in an Array
Save Control To Userform Toolbox
How to find the most common pair and triplet numbers?
deter worksheet deletion
Loop Until Last Worksheet in Workbook
How to tell if xls is open?
if any range on sheet2 change put "a" in sheet1 cell a111
Data validation
Stopping the confirm popup on file save with same name
Help including exception handling - try block
Importing JPEG data into spreadsheet
Problems Adding Columns--but data close to IV and no hidden objects
pass a variable to a public sub
idea which I don't know how to work out
Dynamic Charts
why my excel data lost on cd ?
why my excel data lost on cd ?
Working with column and page widths
array formula in macro
Duplicate rows, based on date difference
Duplicate rows based on date difference
auto run macro on open of workbook if cell a1=A
Invalid page fault in module RPCRT4.DLL
Output 0 to 100
how do I compile data entered using a drop down list
Excel 2000 custom toolbar button macro assignment
Help on adding the second trendline in a "lines on 2 axes" Chart by using VBA
Excel 2007 â€“ Error 400 from custom toolbar
Function to return column where a date is entered
Updating Pivot Tables via VBA
help with calling a sub procedure, doesn't compile
Can I convert years to months in the amortization template?
problem with protecting sheet
problem with protecting sheet
Can Excel recognize code I didn't write?
Move data from sheet to sheet based on ColA
Text Box - Moving Formatted Text
Import Data from Access/Query Criteria Not Enforced in Output
Help with Saving to a Folder
Userform TextBox
shortcut key to macro variables
Text via ODBC truncated at 255 characters
Recording a macro to copy into a series of variable ranges
how do i create a nomogram in excel?
Read a Range into an Array
VALIDATION USING ALPHA-NUMERICS ONLY
VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
how to programmatically clear Document Recovery entries
FunCustomize - general how-to question?
Syntax for getting value of named workbook range
Dynamic Data from Excel to Word
Replacing "IF" or "LOOKUP" formula's with VBA Function?
Help! Can't find bug in program
ComboBox Toolbar
Copy button caption
filtering out duplicate data values
VBA and "If"?!
highlight row / spin button
Lotus Notes email from Excel - formatting body text.
retrieving named ranges from another sheet
generating random cash flow with same IRR
RTD only alive when Excel is active app?
VBA small code error?
hide row + buttons and password protect
Error trapping is not working for errors related to files
comparing a date range within another date range
spin up / spin down
Macro - cell content left then....
Can this be done with coding?
Help, Query Refresh windowm appearing....
Validation of the First Character entered in a cell.
decimal places????
Incorrect data when using xlset with autofilter
list box / scroll bar
Replacing "IF" or "Lookup" formulas with VBA function
UDF with IRR
How can I parse time and address from cell with non standard extra text?
VB Programming for Excel (and Office in general)
Macro Looks for Cell Contents & Performs Action
Custom Filter loses blank rows
excel search function
Saving Files into a Folder
controlling the Range.Replace method.
Re: If certain text is in a cell . . .
RE: Cut & Paste data in new Worksheet
RE: If certain text is in a cell . . .
RE: Search and replace using a named array on another worksheet
Macro security via Windows login name (or other)
Specified dates within a date range
Toggle Button Caption
An executable file to run a VB script?
newbie c++/excel issue
VB to find text and delete that row and three beneath it
reset checkboxes
How to improve my code?
Forms and worksheet focus
Improving this code
Auto select when using Combo box in worksheet
SPC XL2000
msoControlComboBox Value
Does this code Delete pictures or simply makes them Invisible
add in, ribbon, tab menu problem
Relatively easy data comparison Q?
Checkbox Name Change?
Help in calculating # of columns dynamically
Excel 2007 Error
Excel._Worksheet.SaveAs
Filter and Move Row Macro
Find end of column and paste formula in adjacent colmn
How do I set up a formula for greater than but less than in Excel
Capturing cell address and contents
A formula that evaluates the value of a cell relatively addressed.
help with inner loop to search for matching strings
Open text file as text not numbers
Recalc Alarm
User Data form and populating a worksheet
Copy sheet--Some cells more than 255 characters
Double Vlookup Problem
Permission to print from batch job printing Excel spreadsheet
need help on inner loop
commision on multiple invoices with sliding scale.
xlDialogOpen
Applying Bottom and right border
End of data
Incomplete query return, who can help?
look up multiple fields
VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
Highlight the row and the column that the mouse pointer is in.
Capture name of last worksheet opened
Saving Files into a Folder
Export from Access using vba
macro button
Testing for a value's inclusion in an array
Please help! Data Validation is Suddenly Acting Strangely
remove little green error triangle - how loop through to ignore er
finding minimum value
construction billing
Conditional Formatting
Detecting a single quote from a cells value
Macro to find end of column data
Macro to find end of column data
Multiple Target Addresses...
Copy / Paste Errors
Protect Drawing Objects bug in 2003?
Sub or Function not defined
printer exception, error handler, need to loop through network num
SaveAs matter: How can I save the worksheet on an external .xml keeping the .xls opened?
How to make code waiting until Outlook finishes its job
Data Validation, Dynamic Named Ranges, and Dependant Lists
LINEST & How Nonlinear is it?
Macro Import Excel Sheet into Excel Sheet
Access to Excel
Simple popup box question - font size change
error handler, goto errgetfile
Autofiltering macro does not work correctly
Conditional Formatting / Positive vs. Negative
Searching VBA Code
Macro Selects Directory to Save File Based on Sheet Criteria
How to output a sheet as PDF file
pop up box
Using IF statement
Conditional Testing Glitch
Copy and past as values
Converting CSV text
Set Document Focus to Top of Datasheet
how to reduce execution time of my code?
Text boxes and Spin buttons
Macro question.
Updating pivot items on 3 pivot tables contained on one sheet
Value or Value2
How to copy part of a sheet as a new sheet into another workbook?
Sort by two columns using VB Script
workbookbeforesave
Bloomberg-Daten über ActiveX herunterladen
Importing Soccer results from Internet Site
Need help saving an image from webbrowser!
Send an email from Excel VBA
Date Format
Still retuns to begining of range, Please Help
Duplicate a Formula in 1000 Spreadsheets
Determing closing method
Excel memory leak?
Summary of Different Workbooks
Combine data in two columns into one and sort the combined column alphabetically..how??
MS Windows Common Controls-2 6.0 (SP4)
List box in tool bar
Encapsulating Communication Between Objects
Re: VB to identify and delete any text box on a sheet
Programming Solid edge with VBA
VB to identify and delete any text box on a sheet
Answering an Excel generated msg box Yes
Returning to first offset point.
HELP!!! Macro doens't run on clients maschine
copy and paste problem
Macros detached from buttons on charts
Case Statement with multiple checks
How can I find the rowheight and use it in a formula?
Issue with command button visibility
Command button
Add a Pictures File Name and Path to a cell ?
Hiding entire rows
Merging Access e-mail field into Excel worksheet
Run a macro when I open any file
Help! - Need help with combo box list
numbers change to text
Object doesn't support this property or method (Error 438)
Macro and Today's Date
VB Code generates error on another machine?
Delete a cell when found
VB6 faster than VBA in Excel?
Find All Instances of a Value
Cancel Print