Microsoft Excel Programming

Requesting advice on VLOOKUP alternative.
Re: Invalid call to #$#%^#
Re: try again
Checking for Open Workbook
array
Chart download
Sum textboxes in a collection
Delete creates error during Change event
how to use vb to auto fit the lines' width(from 1 to no.x line;x is a variable)?
ControlSource problem
A Stickler of a problem
Re: try again
Re: join location string with variable
Re: movign data from an excel range to an array and back
Re: Wheel mouse no longer scrolls in VB Editor
Re: Value at Intersecting cells
Re: need help in improving this macro
Re: Popup window (plz replay)
Re: Textbox_AfterUpdate() Question
convert hex-values to decimal values
Application.CounIf
Re: Why the.. does this not work???
Re: Why the.. does this not work???
API coding
Use DTPicker value as autofilter Crieteria
Copying & Pasting
Re: Highlight the debit and Credit ( positive and negative) numbers within a column
Re: Formatting Cells/Columns in Excel 97
Name conflict
Using Combo boxes in excel
Using Combo boxes in excel
Conflict between xlDialogSendMail and xlDialogPrintPreview
Re: Copy Range object
Editing XLS-type add-ins
Re: Problem with embedded Sheet in VB program
Pivot table problem
MINIMIZE CONTROL
Disabling the "X" (Close) on a UserForm
Automating Excel WorkBook With C# Suppress Excel Message Boxes Possible?
File|Close w/Save fires Workbook_Open twice
Re: formula help
Renaming chart series
Run-Time error '1004'
Re: Help!!!!!
Reference a SQL DTS package in Excel Macro
how can i delete a macro
Re: When is a defined Name actually calculated?
Do Loop
interesting problem
Re: MS Query
Find two diferent cells value ...
Dynamically create Total using VBA formula
manipulating pictures with VBA
access to excel
numbers to dates
Showing Search results in msgbox?
Using Cells( ) for Range definition
Comboboxes
Userforms and autofilters - Autofilters don't seen to work with userform
VLookup
Macro Question/CHRIS
Protect\Unprotect VBA project
Array formulas into VB programming
Re: Displaying error messages
VBA to read data from XL and import into another XL file
Modifiying a text number ( 12345 ) to have exactly 6 digit with a 0 in front
list of dates to calendar format
VBA Creating a Macro to Move some of the text from one cell to another
userforms
Digital Signature
Re: Excel data into VB 6.0
Set Print to Manual Feed
Re: Excel VBA sending emails (using iNotes)
Re: Excel Automation VS.NET2003
selecting data
Re: VBA Creating a Macro to Move some of the text from one cell to another
Re: Better than a text box?
Excel/Web bug solved!!!
Macro to copy and paste
Help with very strange cell behavior
Excel Automation VS.NET2003
input box cancel button
Re: Run Macro when workbook opens
Hide and unhide command gridlines etc...
Macro Help
Extract unique values from worksheet into form
paste special whatever is on the clipboard
Hyperlink - address by formula
Re: Protecting VBA Code
Object libraries
Excel foruma for Exclusive numbers
can't open References
Re: A BIG Thank You!
Looking for a "Simple" EXCEL Solution
Drawing object references
query source code
modeless userforms
Excel 97 under Win XP
Copy from workbook to workbook
Hide/Show modeless userform when activating/deactivating workbooks
Vlookups
vba macro in Excel
Printing .pdf files from directory from excel
Macro to generate txt files using Excel
Macro to remove leading space
Re: listbox format...
Print pdf from website
Make Function Accessible only from VBA
Running a batch file from VB
OLEFormat.object access is very slow
Re: How do I use Excel9.olb with computers wtih Excel 97?
Counting
Re: Looking to save one sheet in a workbook of two sheets...
Re: Date format question
Interesting applied spreadsheet problem
Macro changes...
UserForm To A Range
Re-posted need more detail
Excel retrieves data from Oracle
Floating control box
Help: Autofilter doesn't work
Finding data in another Excel file
REPOST: Find a row and delete it
Assignment Statement
Macro to connect excel sheets automatically to Hyperion ESSBASE 6.5
Multiple queries using *.dqy files
User Form Controls
User Form Controls
Re: User Form Controls
problems with producing results
Re: User Form Controls
Timer sticking in XP
Sending Print command in a macro
Re: Move file to different folder
open xls macro
Re: When is a defined Name actually calculated?
array question
notepad in excel
Re: Excel Toolbar Buttons
Find Date from formula
Date Last Saved
how do you skip lines when reading a text file
Copying macro formulas down
Need to cast OleObject to CombBbox
Macro Compatibility
MsgBox location
Macro to insert "0" in front of 4 character string
List Box and length
Comments Member on Worksheet Object
Copying worksheets to a new workbook
Pivot Table issue
Print Preview hangs
New to Excel Formulae
How to evaluate a text expression as formula ?
Re: macro to convert text string
Excel as a DB on the internet
Re: macro to convert text string
checking visible sheets.
How can i write a vba code to get string or integer "C15" from $c$15?
Re: newbie question (random colours)
OpenSchema on workbook reveals strange table
Search for value in a range
multiple series on a graph
Quick summary of Sheet Names
Re: Pivot Table issue
Can I use UDF in an array formula?
Counting the Number of Folders Not Files.
write out a flat file with fixed columns
file save as macro
Execute a query against an excel doc and a sql server db
textbox help needed
Activating a worksheet with a user form open on the screen
Re: -2147418113 (out of memory)
Form vs. Control Toolbox
Change Source
Re: Improved printing of VBA code?
Re: count of item in excel workshop
Re: count of item in excel workshop
Disabling macros with Shift+[OPEN]
open ftp file specifying user id and password
Re: selecting multiple rows within a Macro
Re: Last Save Date & Time
Re: Last Save Date & Time
Re: selecting multiple rows within a Macro
Sorting with a macro?
A simple function
select user security
Autofill question
Help with adding controls
Re: Open a Read-Only File by cycling thru these 5 passwords
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info
Re: selecting multiple rows within a Macro
Is this possible?
opening a workbook in the current directory
toggle grid
Excel Macro working with Outlook
Maintain links between Excel and word processor.
Silent running
Filling multiple cells based on 1 combo box selection
String Variables
How to use UserForm DTPicker.Value as Autofilter Crieteria
Automating Excel from VB .NET
Automating Excel from VB .NET
Grouping & Sorting question
Re: Running Excel as a batch job AND in the background
function array result - .xll - sdk - XLOPER - example code?
get cell value to textbox
automatically download and print a pdf file from the Internet
Re: Linking VBA code to spreadsheet
Re: Print Only Columns with Sum() in Row 43 <>0
Re: Print Only Columns with Sum() in Row 43 <>0
Re: Print Only Columns with Sum() in Row 43 <>0
Re: FILTERRING XL2000
Summing for specific criteria
How to set Timed event to recur.
Close Form with VBA
Conditional Formatting
macros
Excel - saving result of a function without showing the function
Excel 2002 original default settings
Excel VBA Programmatically delete a form?
slow down a running macro
Can I control Internet Explorer using Excel VBA?
Print Ranges
Problem with WAIT
Tab in text box inserts actual tab
Re: cell address extraction
Re: Loading 3 Dimensional Array
RS-232
Multiples
Scramble names
Re: Highlight the debit and Credit ( positive and negative) numbers within a column
Positioning Slips on a Page
Bulk Email
Consolidate Sources
Re: Changing cell fill color as result of 'if' statement
JPG Insert using VBA
Re: Why my code do not work : - (
keeping track of stock moving from one location to another
Re: Why my code do not work : - (
Timein-Timeout
word reference
Find Usedrange question
Re: Changing cell fill color as result of 'if' statement
Re: Why my code do not work : - (
sending an excel sheet via outlook express
Re: Changing cell fill color as result of 'if' statement
Re: Filling Column with Numbers
Re: Filling Column with Numbers
Excel 2002 Add-in: MSN MoneyCentral Stock Quotes
Using VBA macros in all workbooks
Re: Filling Column with Numbers
Copying the text from a text box to the clipboard
Beginner question: where to put code when form loads
Multiply Function
Excel Running Outlook VB
Re: Is a Collection the best option?
Restrict cell value to unique value within column.
word reference
Correlated Random Variates
What book about Excel programming do you recommend ?
Re: Is a Collection the best option?
Re: locating numbers in a text string
word reference
word reference
Linking cells in 2 sheets
word reference
Using Outlook *.pab in Excel
A formula needed - probably an array formula
Re: about word
Re: Testing Time /Date stamps of Files
Re: Testing Time /Date stamps of Files
Re: Always convert to number
Send data to another worksheet....
Objects in VBA and Excel
ThisWorkbook variables...
Re: AdvancedFilter question
OR function
"update remote references" - what does it do?
userform mysteriously unloads
Creating New sheets
Imaginary numbers...matrix multiplication
Re: Macro to replace negative numbers by 0
Count if - background colour & value
Re: Macro to replace negative numbers by 0
UserDefined Function that opens another w/book
Names of worksheets
Re: UserForm to A Range
Help sort this out
Combo Boxes
Replace over two cells
Is a Collection the best option?
Automatic detection of a change in a column/cell
convert an ADO recordset to a text file that can be queried with SQL
Question about Excel 2003 and XML
Excel 2002 VBA auto_open
Worksheet Protection
VBA to insert list of sheet names
Excel 2000 querry.
Cell value programming question
How to determine which button was clicked on the modified right-click menu
pop ups after saving to csv via macro
Re: Saving an Excel Spreadsheet with a particular name - Beginners
Re: a simple question
Numbers being stored as text not as numbers (SpecialCells)
RANGE("A65536")
Re: Leave last col alone
Do Excel automation re-distributables exist ???
Deleting range not a row
Combined combobox
Macro
Re: MAIL FORM CONTENTS
transferring data from access to excel
Find the row of all cells in a selection
AddIn
Re: Saving an Excel Spreadsheet with a particular name - Beginners
Re: Saving an Excel Spreadsheet with a particular name - Beginners
Pivot Table Format retention
Re: Is it possible to tell if a cell is hidden by 'Autofilter'
Re: Excel hyperlink problems
Re: Is it possible to tell if a cell is hidden by 'Autofilter'
Excel: Array & Memory
How can the macro open a sheet that is locked with a password
How to import data?
FileSearch doesn't find zip files
Copying page setup information
Blanks in VLookUP
FileSearch dislikes Zip-files
FileSearch dislikes Zip-files
FileSearch dislikes Zip-files
Userforms - listbox question
Re: Leave last col alone
lost decimal places
Need Help Please-Filtering
Anchor a Userform to a cell in the worksheet
Changing Links in Excel with VBA
Argument List Of ActiveChart.Location And ActiveChart.ChartType
Creating a large number of charts automatically
userform
querying text files with sql
Re: How do you set a default macro in excel
Creating a large number of charts automatically (repost)
EXCEL executed an invalid instruction in module VBE6.DLL
Is Solver Modification Possible? PLEASE HELP!
E-mail as message body not attachment
Distributing Macros
Excel VBA help.
Re: Problem with setting values for SeriesCollection
Re: userform
how to make self-made vba function easily understood.
Excel help
Error 462: The remote server machine does not exist or is unavailable.
Corruption?
Open file saved in HTML format
Data Validation List
Macro statement
When Save As stop running macro
HTML Database
Auto_Run Macro
Calling xla argumented macro from VBScript
Setting default directory prior to GetOpenFilename
Help to simplify code.
open & scroll to specific location based on value
Re: Test whether current drive is local or remote?
Re: Use Arrow keys in optionbutton
copy sheet1 and name sheets using names from a range
External File Data Import
Automaticly change date in Wroksheet
Looping thru cells in a named range
cut and paste using absolute references in vba
Problems On Shutdown with Excel/VBA App
Select Filtered Data less One column
read ZOOM after setting FitToPagesWide in pagesetup
goto in Word
Listbox w/CheckBox Options
sharing calendar vba
Change Function Name Text to Upper Case
Input columns with number of days in month
Re: How to get the value of a given cell address in excell
Re: VBA overflow
Events on shapes
Re: I will never, ever get this correct ...
Re: read ZOOM after setting FitToPagesWide in pagesetup
Re: I will never, ever get this correct ...
Re: I will never, ever get this correct ...
Re: I will never, ever get this correct ...
size of excel file
Re: How to get the value of a given cell address in excell
sheet protection question
Re: I will never, ever get this correct ...
Colouring rows
I will never, ever get this correct ...
Date picker?
Re: SheetName
tracking changes another way
can't change cell background?
Date formatting in a multi column listbox
Re: Operation on Ranges
Filecopy in vba macro
how to suppress overwrite prompts
Re: why this code not working
Question about creating Optimized Excel VBA/Formula Files
Re: VBA overflow
Re: Data Validation Multiple Select List?
Error changing cells in VBA if a chart is active
keeping rows hidden in outline
Re: Improved printing of VBA code?
VBA - Programmatically Change VBA Project Password
Further Help Req'd - Looping thru cells in named range
Re: Run-time error '91':
FILE > Save As / FILE > Print greyed out in Excel
Re: Make a VBA function available
A kind of what-if problem - Please help
"Search Column for Last Numeric Value"
Excel VB: Open/Save *.xls
Rebuild XL Worksheet Menu Bar
What is a clean way of controlling Scroll bars when using filters with Userforms?
Interfacing OL2002 Cal and Excel Userforms
macro to hide column based on header
Runtime Error 1004 -- Application Defined or Object Defined Error
Formulas cause blank pages to print
hyperlink to an Excel file
My post does not go through (twice)
Re: why this code not working
splash screen
LOOPS
Macro is giving me problems with sorting
Re: (Worksheet)Listbox1.additem = (Form)Listbox1.value ??
Re: Fonts
Formula... conditionnal format
Re: Print Excel Sheet PDF extension
How to construct for best speed?
Question About Pivot Tables
Enabling comments on a protected worksheet
Re: Variant to String
Excel Automation Issue
Problem copying worksheet containing code module
How to Find text in String?
Epitaph for Excel, perhaps
application.dialogs(xlDialogSaveAs) AND CHDIR
Save Macro w Suggested File Name
adding text path via macro to activate hyperlink
Date filter using now()
Problem Importing Delimited Data from IE
Re: Finding comments - help needed !
Copy last 13 items
how to bring up a data form with VBA
VBA Help
HELP! Code for Pivot Table
opening Excel report
Blank cells
Re: tomorrow's date
Stattic Variable
macro to delete a sheet
Trap this Error
Applying second filter and set print area
copying values from sheet to another
Macros
run a macro when clicking on "save as"
Macro to insert new sheets and copy information.
VBA to copy a worksheet to word as a picture
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet
Count occurances based on certain data
Passing range as argument
VBA function reading all cells as -4142
Re: External File Data Import (F.A.O. Bernie)
Selection based on values in a cell
Re: sending a workbook by email to multiple recipients
Re: Issue updating XLS using ADO
Re: Excel File To update Automaticaly
Open all files in a directory
Re: functions available on toolbar
Re: Sum only numbers?!
Errors in The GantTool
how to offset when it is a merged cell.
Pivot table problem
Week number when year changes
Help with a list box please
Using UDF in COM Addin as formula in worksheet
priority of short cut keys
Re: Sum only numbers?!
Re: setting procedure attributes
Using an Alias for a range?
how can i save excel file
update one sheet with VBA from another sheet
Sorting rows programmatically
Conditional Formatting
Re: tomorrow's date
Convert True/False to checkboxes
Re: Debugging Server Existence code
Pivot Table undocumented error
Text returned as 0
Looking up values
Execute macros under Excel and Oulook XP
Asking to Select a Range
Re: Can a MACRO prompt for the filename to open and/or save?
Conditional appearance of checkboxes in Excel
Re: Mass rename of worksheets/Workbooks
Re: Check if a String is inside an Array
ATTN: Alan Beban. Problem with ResizeArray
Mass rename of worksheets/Workbooks
Re: Mass rename of worksheets/Workbooks
Excel 2000 and SaveAs
Worksheet_change
Passwords in EXCEL
How to exchage data with other programs?
Macros - call or launch from fromula
Array
Re: Jump to cell?
Activate Non-Excel Window Through VBA
Embedding pictures in Excel
delete multiple columns with one line?
new to VBA...loop?
Complex conditional statements
Paste columnwidths in Xl2k problem
Excel 2002 and Access 97
Annoying delete empty rows question
Re: Check if a String is inside an Array
size of multidimensional dynamic array
filters
Protecting a portion of the Sheet
FormatDate
Macros/VBA
date in listbox
Cell Truncates to 255 characters in Macro
Re: Database info in Word doc
Re: Automatic Row Generation/Insertion
Re: Autosum variable range in macro
Re: Autosum variable range in macro
How to delete an Excel Macro from VBScript
checking for errors in combobox's
using a macro to define the contents of a cell as the save as name
opening file
copy multiple cells
Re: Cann't use "Match" function inside VBA
Determining if a Add-In has been loaded from XLSTART
multi users
Disable "File Not Found" dialog box
Not seeing integer
Re: Determining if a Add-In has been loaded from XLSTART
function to compute average without zeros
copy to same column
Auto Open
Re: Autosum variable range in macro
Regsvr32 return value
Re: size of excel file
Re: UserForm Loss Focus
formula to display dbaseIII columns/rows in Excel Cells
Additional ToolBox Controls
strange behaviour
Re: Application to find Kilometres
if it is possible to add a combobox to a self-made function .
retrieve value in file (NO VBA)
ComboBox
code to strip back (from the right) a directory but not the file name
Sum of vlookups across all worksheets.
Sorting Unions
default value for combo box
Find/replace help
Referencing to controls on a worksheet
passing values from one sheet to another
Workbook, worksheet rename
TreeView: add more than one node to nodes collection
Importing UTF-8 Encoded CSV Files. Problem
Re: Excel -> PDF
Spellcheck via VBA in excel?
Excel 2000 VBA: select filled cells for printing
Re: Excel -> PDF
Advise required in relating two lists
Re: if it is possible to add a combobox to a self-made function
Re: Setting print area
Check Box influencing other Check Boxes
Hide/Unhide Macro bug
Help - 'finding' a quote mark (") ???
Macro - trailing blanks
macros not enabling
Excel NewWorkbook event
Fatal Error in creating worksheet
Worksheet change
help with Or statement
Programmatically open / edit vba-editor
name of a sheet
Can anybody Share goof Pivot Table Examples?
Excel 2000 - Page break so group of rows not split (VBA?)
Macro help urgent urgent
Re: Suppressing messages
Re: Moving data to sheets
[ODBC Excel Driver] Too few parameters. Expected 1.
Re: Macro help urgent urgent
Retrieve data from e-mail attachment
name of Workbook
Search and Replace text strings within Macros
countdown timer in a cell
COPYING A LOOKUP CELL
Wondering If Possible
Re: Add in question/problem
Printing an entire workbook from VB
Maximum Size of Excel Forms?
Excel Macro To Convert XML File
Recording the last saved date of an external file in a cell
Rename a Range, programatically?
listbox
Re: Pause in execution
Re: Set Focus in "Form" environment
VBA interactive commands
User defined worksheet functions
Re: Values in a MultiColumn Listbox
Re: Execute macros under Excel and Oulook XP
Emailing with Attachment from Excel
Re: Macro InputBox with Drop-Down List?
Re: Data mix and listing
Re: Macro InputBox with Drop-Down List?
copying values
Re: Excel User Form Macros
Re: Multifile Code Error
Pass Strings > 255 Char
Validation With Dependent Dynamic Ranges Lists
Returning ranges from xll
Re: VB questions
Breaking link to another sheet
Changing a formula on the worksheet
Slow Draw with Excel VBA 2000
Filter out one list of text in another list.
Re: Named Ranges and VBA Add-ins
resizing and aligning groups of ActiveX controls together
TextBox Properties -- Don't move and size with cells
Testing to see if a sheet name exists
NEWBIE: How can I do a "soft reference" in Excel/VBA?
Validation of time in code
IEEE-754 float to hex conversion macro?
VBA macro for xml conversion?
Minimizing a user form
Using the Vlookup Function in VB Code
Re: Checking if workbook open (where path is unknown)
Re: Hide the principal screen
Re: Named Ranges and VBA Add-ins
open excel workbook from template
Re: Repost: XL2000 Template Wizard - help needed to update database
problems viewing excel over internet explorer
Newbie question on UserForm
Re: #VALUE error in UDF again
Re: Unload Me
Elapsed Time
UserForm_Initialize? How to update.
ReadOnly property of word document not returning proper value.
Re: QUESTION
strange behavior by ActiveX controls
Re: Using Class, WithEvents and auto-instanciating
Import - query table - retain trailing blanks in fields
runtime error...
how do you hide a forms command button
Re: timer within a macro
Re: Creating Data Validations
Counting items in a listbox
web query
Circular Error using MAX fnc
Re: Excel 2000 Windows VBA vs. Mac Excel 2001 VBA
Text on shapes
How do I check if a user clicked the Print Cancel button
public variable
Worksheet_Change not working when using paste
File open dialog
This Workbook or Worksheets for VBA
Read Image From SQL Server n Export to Excel
Loading Add-ins to a Protected Project
error with "with statement"
Run Macro if certain cell change
numbering new sheets with the same number
Re: macro for converting text file to excel
Converting Format to a "Data() As Byte"
Dates to months and calculating values for their months
Re: Problem with Data Formatting
Macro for formatting
Re: macro for converting text file to excel
Need more CF capacity
Re: help with excel recipe book
Selecting Rows Programmatically
ComboBox.ListWidth question
Re: size of excel file
Adding Cost Codes
Insert Row using Macro, Group By Date
Checking 2 c if workbook exists
Re: starting an external program with a command line
Re: starting an external program with a command line
Re: Writing a formula in code
Change mouse to "busy" pointer when I bring up a form
Focus back from modeless userform to sheet
Excel Combo Box Formatting problem
Unopened workbook values
column width
Filecopy in vba macro
Filecopy in vba macro
"Small" Multi-Dimensional Array Slow Writing To Cell
Shared Macro
sort blank cells first instead of last
Worksheet change
Typing in a Combo Box
Re: OnAction
Re: Unopened workbook values
SetFocus problem
Save As... crashes Excel
Re: opening files
Re: opening files
Re: Workbook_Open macro created in Excel 97 problems on MAC
findinf text in multiple excel files
Need VB script for telnet application
textbox.value doesn't create a number?
Accessing custom document properties
Help Internet Explorer Automation - How to run the script's ??
numbers as text?
macro crashes excell xp
Re: selecting range
Range of cell
Re: Accessing Data from Closed Workbook
Returning Key Focus
Re: countdown timer in a cell (Tom)
Excel VBA (DisplayFullscreen and the Windows Toolbar).
Re: Creating Collections 'on the fly'
Re: Macro to hide rows
repost... Listbox
Finding the sum of yes/no answers
condiionaly copy to another sheet
Excel Questions for VB6
Can i Access XLL file(Excel97) in Excel XP
Re: Time calculation based on filled information
Validating user input to a listbox
thanks
XP to 97 VBA error
run code after cell contents change
Trapping Double Click Short-Cuts?
How do I create a button to reset ComboBoxs
Re: Solver isn't working...
Accessing Data from Closed Workbook
Re: add text to label (label from forms toolbar)
Method? Function? Operator? I dunno ):
Workbook Reference for Macros
Chart source data
Command Usage
Hyperlink to a chart sheet...?
Taking Data of cell from worksheet to a userform window
Web Folders -> Excel file -- asks for password again
Re: how msgbox from Word when ran from Excel?
How can I create this argument? For every 20 you get 2?
Need advice and code help with working with *.dbf files in Excel 97
Learning VBA
disabled macros
Undo Redo Reset Buttons
Months between two dates
Re: Automatically naming a worksheet tab with dates?
Re: row autofit