Excel Programming [Archive] - Page 170

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