Microsoft Excel Programming

For Each...Dynamically formatting multiple worksheets
Can a macro be suspended during user input?
Copy of protected document was unprotected in 97 and protected in 2002
Re: split cell content without using a specific character/sign
hyperlink breaks if space within hyperlink
Re: mediaplayer
Moving Row Data
Re: Regression
Re: Searching directories...
Re: Range object to Array object conversion
Limitations in UDF:s
Re: Subtotal detail reference?
Re: Range object to Array object conversion
Re: Range object to Array object conversion
Re: Can't deploy my .xls to other PCs...
Re: Saving a file(new) using the multiple cell contents as a file name
Converting DataLabels to Numbers
Textbox object does not update
compare rows...
Re: OpenText bug ?
Problems clearing a cell
Re: controlling another program from Excel
Re: Need new idea for universal path
Re: Searching directories...
Update links using VBA
Re: Update Links automatically using VBA ?
Downloading drawings from a list in excel
Regional Options and Decimal symbol from VBA
scan rows
Re: Built In CommandBars
Re: transpose matrices
Re: Auto Select a file not knowing its specific name
vlookup
Easy Question - Opening a workbook
Get data from a CSV file
Re: Copy Data to a new sheet
Re: reading cells from a spreadsheet using VB
How to disable the Ctrl+Break ?
Re: Need new idea for universal path
Recordset Opening Excel File
Re: Copy Data to a new sheet
INDEX
More UDF problems; some won't update, some won't stop running!
Alternative to Indirect Function
FileSystemObject question
Re: Worksheet_Change Event Not Working
Re: FileCopy error
delete upper triangular matrix ???
Re: Auto Save in Excel 2003 (XP)
Which Path not found?
call dll's from Excel asynchronously ?
FileSearch Problem
Re: Conditions
Re: My workbook doesn't works on no other PC exept mine....
Debug/Compile: Compilng excel macros? What it generates?
Modifying an Access record in Excel
macros
Access a built-In command?
Pausing a VBA macro
HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004
Default for Dates in User Form
How to Save on a Network Drive using UNC?
Auto Open Excel at Specific Sheet
macros and screen updates
Tallying columns
Mcdonalds -> McDonalds
"Headroom" on <Files=99> in config.sys
Re: Workbook Open code
Re: Workbook Open code
The For Loop Worked, but need critique
Re: transpose matrices
Using an ActiveXDll with Excel 2002 when the DLL uses a VB Form and VBA uses a Userform
Re: Accessing properties of a series with no data
Re: Relative references to multiple selections
#div/0!
Relative references to multiple selections
Re: How can I discover the FULL list of vbConstants
combo box web ability
MSG Box triggered by move/copy
Copyfromrecordset Bug ?
Wildcard in conjunction with data comparison
PasteSpecial failed
Poor Worksheet Performance
programing book
Hide Columns before Print problem
Re: transpose matrices
A pun on Google
Re: Sum only numbers in red font color
Re: Sum only numbers in red font color
Re: Sum only numbers in red font color
Auto_Open Check date and Close
Dim person, needs help
How could I do this? Email status...
column widths
checkbox
Auto loading of a user form sometimes
Save protected file into unprotected file without password
Copy range between workbooks
macro that cleans single the unblocked cell
How to hide a loaded .xls...?
textbox query
Data Validation is it proper to use it in this situation
Updating Excel imports
Re: Input Password to Open Linked Files
testing for non-empty cells
Formulas not data 0
Get data from one sheet to another
Particular cell in Range
Help with the Find method
Re: VBA - import txt file using space separator
Re: Arrays: querying with two variables, why doesn't it work?
How to get the 'current row' from VBA
How to obtain the shortest range that encloses all the non empty cells?
Re: Do the Addins belong to a workbook, or are they global to all workbooks loaded?
How to use a cell text to call a macro ?
Re: 2 buttonbar questions
Re: Pasting a range of information from a foler on F Drive to another folder on same drive
Array
References
Macro to move to next cell
excel 2002
Passing a Variable from Worksheet to Workbook
Re: Help with Macro Code
Re: Auto_Open Check date and Close
counting occurances of a char. within a text string/cell
vba: Taking average of values in one column based on a corresponding value in another column
Help to get Calander functions on Excel XP
Re: Restoring Excel menu bar settings that were changed by code
Re: Typing a quote character Vs pasting a quote character=> whathappens to the resulting CSV? Interesting!!
I got those pivot table blues, ...
Re: Typing a quote character Vs pasting a quote character=> what happens to the resulting CSV? Interesting!!
make appointment in outlook using data in excel -- set recurrence
Re: Auto_Open Check date and Close
Re: Something slightly harder...
Need Help Summarizing Survey Results
Subtotals
query
can I Link a database to excel work sheet
Modeless form disappears on deleting sheet
if statment
Re: Last cell in column
OLEobject on the sheet
Re: disabling shorcuts
Worksheet Tabs
Disable options
Newbie Question
create .TXT file Log
File Checking
learning expert level
Spin Button to increment or decrement the date in cell A1
Name a range
Excel VBA to access URL as Textfile
For Each Sheet in Workbook
Re: Comparing 2 spreadsheets
Re: Auto_Open Check date and Close
Used Range Problem
Stop Dialog box from appearing within macro
Fw:code needed
Repeating (Looping) a Macro
Macro to name a range
Network Path
Cell formatting with 2 variables
enter into an excel cell...
Export to excel from ASP: Text data interpretation issue
Locking command button size to cell proportions?
Taking VBA from Excel 2002 to Excel X on a Mac.
Pivot-table versus crosstab queries
Re: Question about "End(xlUp)" property
Re: Question about "End(xlUp)" property
Multidimensional Arrays - VBA
array
Unlinking workbooks
Re: Multidimensional Arrays - VBA
MS Excel Sheets...how to copy and paste ?
If... Then Loop problems in Worksheet Event
Screen Size and UserForms
Re: Enter Excel Design Mode and Exit Design Mode
Re: Used Range Problem
Clear clipboard
aliases
How can I find a handle number of controls on Userform?
Print Multiple Sheets
Re: Cell Protection
Locking cell color pattern when sorting rows?
generating sheet with command button & code
Opening and saving textfile into XLS
Re: crash changing const to public const
Re: Problem: SaveAs / SaveAsCopy methods
Adding components to multipage programatically
Re: Cell Protection
Inserting Records
Assign Macro problem
Delete duplicate rows
Declaring Variables
Re: Cell Protection
Re: UDF returns #value in XL97
Re: Expected:expression
listbox doesn't scroll properly
Emailing from Excel
mysql backend
Open Winword-file using a Excel 97 VBA macro
Collecting values for later display?
Error Msg
Disable Database Object
Macros
Checking for existence of macros or code in an Excel Spreadsheet
"Problems obtaining data" error refreshing Excel pivottable
Excel Add-ins
Tutorial Available
need help with a function
ctrl-key adds up to cells.count
Dialog Box Control
Timer Event
Textbox does not print properly
Runtime error '1004':
GetOpenFilename - Problem
square boxes when using vbcrlf
Checking characters using VBA
Re: Making command button code "more flexible"
Validate value in cell
Change name in Save As?
Re: Making command button code "more flexible"
Template Wizard - "Saving to Database" Problem
Read cell formated as Time
Saving a time stamp with a macro?
How to hilight the active cell
Simply silly question
Running macro in a browser window
VBA References
GetSystemMetrics32() [Screen Size and UserForms - pt 2]
need help with a function
Conditional Formatting
finding blank cells in a row in Excel 97
Macro Auto-refresh?
Valid ControlSource values
saving toolbar buttons on custom toolbar
Limit in the number of Dataqueries in Excel 2000
Scrolling in Combo Boxes
Adding tabstrip and runtime
Control button question
Julian Date
Add leading zero(s) to cell values in selection - An Example
What is correct syntax for a CommandButton?
Creating a spreadsheet from Foxpro using Object Model
Query in Excel
get metadata of pictures
Re: For Each Sheet in Workbook
Negative Value not computing
Question
Pivot Table Borders
create custom filter
Form Unload
Re: test for autofilter
vba excel 2000 device i/o error
Counter does not reset, on 2nd trial
newbie userform problem
open all files in a folder and ...
Vaciar Portapapeles
text wrapping in excel
Re: Decoding Part number entries for all values embedded
Help with FileSystemObject?
Code to change references
VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other?
Too many sheets is there a way to index them?
Help with macro to update list (database)
Adding a webBrowser object dynamically to a sheet
VBA Syntax for VLOOKUP to return array of return values
SOS VBA Code Emergency: need to copy tell to empty cell direct below where values in adjacent cells in different column are equal to each other.
EXCEL AND ODBC AND QUERY
Re: Abort or continue
make appointment in outlook and send email reminder - all data in excel 2000
Abort or continue
Re: Refreshing a Worksheet
Re: Refreshing a Worksheet
Re: VBA Code Works in 97, Not in 2002
Code simplification
Re: Developersdex.com
Function to Find Last Non-Null Entry in a Column
How to make an alert system by Excel ?
Populating a form by search criteria
For each...loop for checkboxes
Compile error
Re: How to make an alert system by Excel ?
Re: VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other?
Re: How to make an alert system by Excel ?
How to keep values in classmodules
Birthdays database
Close current Workbook after calling macro in other
Re: FileCopy
Problem in running an application
Hide VBA Modules?
Find last used cell in an column
Auto Change Formula in different sheets
Re: How to detect Acrobat Distiller open
Run time error 9 (subscript out of range)
vlookup
Excel properties
copy and paste from different sheets into one sheet using a VB code
Selection.AutoFilter Field represented by "all"
Working with Grouped cells on Protected sheets
Working with Two WorkBooks
Re: For Each Sheet in Workbook
Re: Code for saving as a .prn file
Variable Undefined When Blank
Code Problem !
Re: extracting data from word2k to excel2k
How can I get the time-zone info of a user?
List of Names
Simple stores control using Excel
format cell type problem
Referencing Cells
ADODB Recordset
Re: Looking for a macro to curve fit using multiple regression
RE: USING ACTIVEX EXCEL.APPLICATION
Control of named ranges
"over-lay" one range onto another range so that only blank cells are affected
Re: find last used cell on worksheet ?
Re: Put Worksheet Name In A1
Put Worksheet Name In A1
Re: The find method
Looping Through Worksheets In A Workbook
Creating Links Between Spreadsheets
Working with mac addresses in Excel
Re: Wow ! Excel 7 has a secret macro "RemoveAllFormatting". Where is it in 2000 !?
Re: Printing Excel Dates (Format dd/mm/yy)
Add-in udf
Re: Print Copies in with statement?
Adding new row(s) to end of worksheet
Data format issue
Goto method fails when assigning a macro to a button
Property question
Re: Ctrl + End
Date Difference
Re: Cursor Movement in Macro
Re: Cursor Movement in Macro
averages
Command line parameters into a macro
Control Toolbox button
How to code/run a macro?
How do I aasign a macro to all workbooks regardless of filename?
Re: Continuing print code problem
ADO
Simple VB and Excel questions
Re: Parse cell reference
REPOST: showing a userform
Re: procedure won't call
Re: Macro assignment to button gets reassigned
Copying Sheet
Excel 97 & Excel 2002 date problem
Array question
Re: Formulas in VBA
Creating Global Macros
Re: Repost: Looking for info on how to program a userform to use filters
Returning User Initials
Re: Ctrl + End
RPC ERROR - 1ST TIMES WORKS FINE - 2ND TIME ERRORS OUT
Is this an array question?
UDF Function Arguments List
Re: Ctrl + End
Re: OMG! This seems to easy I can't get it
EXCEL: trigger web query from macro?
Re: DLLs and VBA: Who free's a variant?
Re: Clear a Carriage Return from a String Value
Cursor Movement in Macro
Re: Clear a Carriage Return from a String Value
Re: Clear a Carriage Return from a String Value
Problem With Select Case
Re: Maximum rows in Excel
Single space? - help
Re: Toolbar Buttons
Re: Maximum rows in Excel
Re: Maximum rows in Excel
How name a copied worksheet?
Record changes made from a vb form
File does not open/copy
Can I save a macro in a template?
Re: REPOST: How to handle errors
Retrieve data from a spreadsheet
Number value to text as percentile
VBA: Userform Linkage Difficulties
Re: Opening CSV file causes date differences
Re: Calling From Shapes
Visual Basic Programming Difficulties with linking Userforms
Passing Text from User Form to Spreadsheet
Re: How to detect Acrobat Distiller open
Re: link cell format
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False)
Visual Basic to Excel Refference / Tutorial
Reference to a range in another workbook
Re: Help - PivotTable Drop-down not Sorting
Excel 2000
Solver Fails in Excel XP
Re: Finding out which page a cell is in
Re: Best Excel VBA Book?
Re: DLLs and VBA: Who free's a variant?
Reference to a range in an Excel Add-In
TEXT, CHAR and CODE
Using the Web Too!
ActiveX distribution
Copying Formula
MATRIX calculations with VBE
Changing Excel Icon in the Active Window
Command Buttons on XL User Forms
Excel; vba; listbox how to reorganize list in alfabetical order
File Search code
Gantt charts on Excel Spreadsheet
Compare ranges for exactness
Two Workbooks
Re Quad combinations
VB reformats dates when opening .CSV in excel
Re: Too much output... PLEASE HELP!
Password & VB editor
Help Please Cut/Paste Macro for DVD Subtitles
Re: Visual Basic Problem with Chr(34)
Re: Visual Basic Problem with Chr(34)
Re: an event for onsendemail?
FileSearch Code
Hyperlink
Excel 2000
SendKeys {Enter} acts like Return rather than Enter
convert Numbers to Text
Check changes on a sheet
Re: Excel 2000 Date Import Problem
iteration and error "#div/0"
Sending data to a different workbook
Advanced Search
Make sure file is in correct folder??
Error Message Wkbk Open
Mysterious button
floating table?
ActiveX component can't be created
suppress popup message
Re: Referencing a range from another workbook
Code problem
Macro to perform mass header change on 100 worksheets
bloating of the .XLB
Re: Sending data to a different workbook
Using GetOpenFilename
Re: Break out of Code
Automatic Macros Invocation
custom functions in formula bar
VBA Excel Charts
Re: Syntax for variable search
messageboxes and forms
Re: text format in csv file
Saving a single cell
Re: VBA Excel Charts
Re: Syntax for variable search
AutoCalculate
Textfile-problem
Re: Syntax for variable search
Re: Using Form and Worksheet At the Same Time
Constrain to visible area?
Re: Syntax for variable search
Re: Strange results using .FIND in Excel VBA
Re: Watermarks
ccrptmr.dll
Re: create a timesheet/calendar in Excel
Re: another messagebox/form question
Re: Save sheet when cell value changes
Re: Runnig macros in background mode
Re: Runnig macros in background mode
User-Defined Function pre-empting Built-in Function? How to undo????
Select all/Deselect all button in a form
all worksheets except
Merged Cells and Tab Feature
Re: Before Close on "This Workbook"
Dynamically change column color in chart
hiperlinks to sheet (dinamic or based on a cell valeu)
Entering time values
Re: 2 bugs in Excel
Micr
How can I invoke windows environment variable in excel
Re: Auto_Open & Before_Close
Re: Before Close on "This Workbook"
Opening a workbook containing macros from VB
Move to Next Row
How to use .GetOpenFilename in For loop?
Re: Need Row Address
Set Workbook to invisible?
Scheduling macros to run automatically
get information from Print dialog
Setting the system clock with excel
Macro to protect/unprotect worksheets
sum of lookup
How to repeat code for 11 files?
Sorting troubles
Make cell entry event change another cell?
Running macros assigned to toolbars
show cell values on a form
Automatic email from excel
Re: api viewer
Picture Transparency/Mask/Overlay .. no APIs
refresh query
Excel solver time limit
Consolidating Monthly Databases
2nd post regarding Data Forms
number into percentile text
Re: Error Handling
Rum macro in procedure
Re: Error Handling
Question about VarType
Hiding Blank lines in named range
Does anyone have a hotel budget workbook I could use?
Import multiple files macro can't find files
Re: Graph problem with VBA script
Re: Formulas in VBA
cancel query refresh - vb
timer conflict
Excel VBA To Control Access
Debra's sample code to hide a Pivotitem
Update links with automation VB.NET
Re: Is there a way to remove a range from within another range?
Microsoft_Sale ,Software,Hardware,Visual,Gaming
Microsoft_Sale ,Software,Hardware,Visual,Gaming
Re: Do you know this?
Re: Do you know this?
Naming a Cell
How to distribute Control files (OCX) to users?
Change numeric value to words
Page Length
Datagrid ActiveX Control
Comdlg32.ocx
how to vlookup returning a concatenation of 2 cells
remove anything before period in column
How to add textbox/buttons to an UserForm
Re: Populate Combo Box With Filtered List
Class doesn't support Automation...
Re: Help Please Cut/Paste Macro for DVD Subtitles
Message box
Page set up from VB6
Re: Page Setup
ODBC Link changing selection criteria
custom functions in formula bar
Page Setup
Limitations of a shared workbook
Re: Compare ranges for exactness
Annoying bug.
Opening a ReadOnly file in Excel VBA
Assign Macro to Command Button
Re: Identify - Automatic links to information in another work book
Next Charachter
Export Excel to SQL Server
Get Month from date
Re: Next Charachter
Re: Hide Sheet
Re: Get Month from date
Re: .AxisTitle
Update formulas
Worksheet_change Method
code for sorting
pivot table xml
Mysterious debug mode
Excel Addin Developers
Checking valus in cells
Null statement
How to retrieve the directory of the currently open file?
VBA Control Checkbox
Copying contents of a listbox
CalculateFull in Excel 2002 (XP)
Year as text
COMPARE AND COPY
Problems with VBE - Please Help
Re: Help Please!
Excel 97 issues
Fast Export
Get columns as "A, B, C etc"
Page Cut
Some macro help for a loop please?
Inputing Data
Please help Frustrating VBA code writing problem
On_Open color coding
adding columns to formula
Registering function WITHOUT it appearing in the expression builder
create new macro in new workbook
Position of MsgBox
How would I do this.... Multiple IFs
procedure too large
Can't check ActiveX checkbox on worksheet
ActiveSheet.Protect UserinterfaceOnly:=true
What is the differance between cdate and ...
Re: dialog box
Apologies For No Subject. Chart Title via a Macro
excel/website interaction PLEASE HELP!!
Re: Year as text
Macro for selecting entire row from mouse cell selection
Is there anyway to restore a workbook?
Re: Suppressing Msgbox during Testing
Re: Assign Macro to cell???
Suppressing Msgbox during Testing
hyperlink in email
Re: Adding chart using a macro
Re: Merge cells using macro
Counting the # of pivot tables within a work book and passing in as a variable
Re: REPOST: How to handle errors
Baby Gates and Microsoft
Imposter in Newsgroup
Re: subset of numbers
Tool-Options-Calculations
datetime in query
How best to extend user's options?
SIMPLEST way to disable "close" button on form?
Re: Newsreader settings
waiting
Re: Newsreader settings
Word Issues: Linking from Excel in VBA
Re: Visual basic to step through range and store a value based on text attribute value.
Re: Visual basic to step through range and store a value based on text attribute value.
Macro import
Help for 'homemade' function
Wildcard pattern matching and replace in string
Adding data to end of range
Basic Userform Controlsource question
Why # appears on its own ?
The Best and Simple Way????????
Built-in file dialog question
FTP in vba macro
Need a formula for returning the value of the cell shading in a cell
How do you identify if a worksheet is in the last position in a Macro?
Automated Naming of ranges...
Printing
Re: Printing in a Macro
Formula for VBA
Finding data in a Range / Returning Cell Location
open a word document in excel
VBA problem
I got an Excel Macro/Security question that is driving me nuts.....
Refering to Cell's Name in Macro
How can I emulate MROUND in VBA
Re: ListBox
Inserting time stamp onchange of any cell
Re: Year as text
Re: getting #value! when I figure I should be getting a diff value
IE link to a sheet
Re: end of file marker in spreadsheet to .prn file
Re: REformatting PivotChart
Empty custom toolbar
Empty custom toolbar
PivotTable: RefreshTime vs. ChangedTime
How Can I copy all value of the array into the range?
Loop though all data in PivotItems in a Pivot Table
Thank You, Bovey
Copy/paste based on adjacent cell contents
Re: RoundUp Function
command button
Re: Problem using UserForm in Macro
Re: Problem using UserForm in Macro
Use of integer variable for sizing of matrix
Closing Excel error message from Access 2K
Create a calendar object in Excel Cell
selecting rows
Randomly Select Cells
call procedure
help me!
Minimise Maximise Problem
Problem with working out the amount of quarters between two dates
Repost: Worksheet Change Method (Bob Philips, Ron De Bruin)
Re: Assign Macro to Command Botton
Re: Sum of Totals from a large amount of Info + colour presentation
Re: Designing a flexible reporting template
Re: Userform reading a cell value
'Object library not registered' in Excel97
Re: Change cell value immediately after a save
Re: Change cell value immediately after a save
Verify a directory exists
Removing Macro Virus Warnings Upon File Open
Re: Login Box
Programatically adding worksheets to a spreadsheet
Re: Sum of Totals from a large amount of Info + colour presentation
Re: Help with closing a UserForm
i am puzzled how to change the red corner of a cell with comment
Re: xla-files
Re: Too many rows in Pivot
Compare Lists
Bracketed Range References
Trouble with simple If and Else
Sending a workbook with a message
Re: Date Question
Re: Removing Picture from Cell Command Bar
saving excel sheet from ASP update
Re: Designing a flexible reporting template
Code to print most (not all) pages within active workbook
converting a spreadsheet to graphical representation
Help with worksheet consolidating
Clearing cells
Re: Too many rows in Pivot
Excel 2000 VBA undefined function problem
Re: weird focus problem
Re: weird focus problem
regsvr32
Re: Variable Declaration??
IF formula error
Dumping the contents of a VBA array to a sheet
Cell Protected Error
Forms.Close
Variable reference
Sheet tab date
Excel Macro Warnings
Change figures to words
Optimizing in VB
Re: countif is one way, any others?
Re: Inputing Data
Activex combo box won't display values
Macro that inserts rows and copy values
web hyperlinks to excell worksheets
Cycle through all the available Fonts
Search Mutiple Excel Sheets.
SAP Business Explorer (BEx)
VB in Excel is liitle bit different
Excel Programing Resources
Re: Is there a better method to achieve this?
Visual Basic: Combobox Complications
Re: Problems with Excel Com Addin
create macro
Fill Macro
Re: countif is one way, any others?
fonts ?
Syntax - Add Range Name based on Selection
printing to a PDF file
Pivot table visibility
EXCEL - 97 and 2000 (Want to bring in data and check against a template..
Re: xla-files
Event validating two ranges with dates
If, then...
Changing Query source location?
Re: Data keeps getting corrupted.... URGENT HELP NEEDED!!!
Can't delete directory created by a macro ...
Blank help window
Excel reading user defined fields in Outlook
Re: Saving workbook sheets to individual excel files
Re: Auto fill based on cRows calculation
compare books
Re: entering keystroke commands in a formula
Re: how to change the style of a cell with a comment .
Re: Data keeps getting corrupted.... URGENT HELP NEEDED!!!
Dir( ) Problem
Re: Data keeps getting corrupted.... URGENT HELP NEEDED!!!
CopyFromRecordset only pastes 1823 characters in a cell!?
auto run a macro
how to change the red corner of a cell with a comment
Linking to specific cells in a changing table. How to Index?
how to obtain the result of the formula in another cell
Re: Work Order Template Numbering Macro
Re: Over=protection - Can't even select a cell
Re: Over=protection - Can't even select a cell
Data Validation
Predict Y-values on new X-values based on other actual X and Y values?
Create a PivotTable from a VBA array?
First day of the Month
Determine the position of a MsgBox