- Re: Protect All Sheets code not working
- VBA has "lost" some datatypes
- Unselect data in a Listbox
- DisplayStatusBar when DisplayFullScreen = TRUE
- Loop macro for a Newbie
- Access automation from Excel
- VBA Path Confusion between Appl and Personal.xls
- Changing color on a range of cells
- How to by-pass password ?
- Macro Writing Help?
- Show Macro list (tools->macro->macros)
- Conditional statements
- Test message
- Checkbox Macros
- Macros Problems
- Listbox Propery code
- data from combo box in userform to spreasheet???? URGENT!!
- Text problems
- How do I paste data to an variable row?
- looping through range and deleting cell contents.
- SaveCopyAs macro
- Renaming a standard module
- Password Macro
- script for Jolly Giant
- Urgent!! Combo boxes 2 spreadsheet?? Thx
- Excel ODBCDIRECT
- Type Mismatch Error help understanding
- VBA Code Printouts with PageBreaks
- missing link
- Prevent more than one check box select
- Downloading data from a web page
- Listbox default
- Making numbers display as currency in lables
- How to create a macro to copy data from a column to a row in another worksheet?
- Formatting a ComboBox selection
- Fill column macro that stops
- Listview in Excel 97 vba.
- Copy for Backup Purpose.
- Looking ior the commnds for several things....
- Sheet code
- change date format??
- OUTLOOK from Excel
- Re: Error of ClearContents
- Function return a Date, wrong format
- VLookup erro
- copy\paste with vba
- numbers in words indian number system
- How can I copy the FORMULA in a cell to a different cell?
- un merging
- Google Search 6.0
- Sheet Protection
- Website about excel macro programming
- Excel sound alert problem
- negative value
- selecting multiple sheets
- Windows XP freeze
- Macro to enter formula with text
- VBA - Put data in cells
- rename folder o files with value from inside each wbk
- pivot tables: multiple consolidation ranges
- Copy Sheet Problem
- FormulaR1C1
- WorksheetFunction
- UserForm question
- FormulaR1C1
- Sum up
- Disable Macro
- Run Time Error, FormulaR1C1
- Re: Window Animation
- opening or activating another workbook file
- Remove commas from Windows buffer
- How show the UserForm only
- How do you change the default printer?
- Comparing two Cells - using Offset and compare - Stuck!!!!
- printing
- VBA reference to Outlook
- SelectionChange - What am I doing wrong?
- Numerical Data vs Text
- problem of asp to dll then to macro?
- Message to Tom Ogilvy regarding SelectionChange
- Escape for special characters in string
- Macro to delete charts
- Data Entry Validation in Excel
- Averaging formula help, please.
- Deleting every sheet in workbook after Worksheets(4)
- Help please....
- Running Code looses focus to Outlook and stops
- Condition added to Sort Code
- Autofilter
- problem with dates
- Filter and Delete Picture
- How to know the excel's constant
- import array text to row data in excel
- Declaring a variable?
- dot value
- copy all pagesetup settings?
- RunAutoMacros does not work correctly from vbscript!
- Re: Width problem with Form
- Close file
- Reading information from all workbooks in a folder...
- Differentiate between "" and Empty in array elements.
- adding a line at the end of a macro to name the cell
- creating new workbook from single worksheet
- Visual Basic HELP
- to add new usernames
- Left Worksheet Function
- Excel linked to Access
- Invisible/unfindable Comboboxes creating .emf file problem...
- Create a drop down calendar in a cell?
- Module
- AutoScale on Charts
- extend vlookup
- Autofilter and protection
- Reference using Excel with VB.NET
- Error when printing to Acrobat
- Crystal Ball CorrelationMatrix macro
- I need assistance please
- tricky rand situation
- data records in a table extracting
- bug in printing excel worksheet!
- MsgBox
- Import IE/WE Favorites programmatically
- combining 2+ wkbks into 1. Code needs tweaking please
- Make easy moeny
- Macro to compare values and return exact matching value
- Send mail from vba with the outlook distribution list
- How do I dedect a right click event?
- How can I use data formatting in VB?
- relative position in macro
- Can you use an IF statement to launch a macro?
- Re: Window Animation
- Open Windows Explorer and select item
- Detecting open files
- Extracting Data from External Source - Automatically
- worksheet name
- Common Dialog Error ! (Please Help me ! urgently)
- Macro to Open and Compile Multiple Worksheets that are password protected
- Gradebook and Individual Report
- VBA --- Corrupted xls file
- reference an ole image control's .Picture filename?
- macro programming problem
- Compare and Append
- running macro at the background
- timing a recorded macro
- Need help with a simple problem
- Chart Fill Effects
- Re: entering data
- Disable Doubleclick
- UserForm TextBox Decimal Places
- using outlook distribution list from excel vb
- Conditional copy & paste
- Displaying Cells Comments
- Scripting.FileSystemObject LAN
- Paste a sheet as a link
- Browse function
- Objects and Variables
- Form titlebar height
- For Tom Ogilvy re Copy Sheet Problem
- excel file format specification
- Using Solver in Browser
- Hide and show
- how can I insert jpeg file in the cell?
- Restricting cells
- Print if populated
- Excell 2003 - COM Add-in - Tools | Add-Ins
- How can I activate a combobox by keyboard strokes ?
- Stubborn Link Data/Value Problem - Help Appreciated!
- print labels diff date on each
- Create Excel Worksheet in C# / VB
- Frame Border Color
- 4 variables to one sheet, then back to original sheet with answer
- GetSetting & SaveSetting in Thin Client Environments
- Disable Doubleclick for a range
- DAO Late Binding?
- isempty
- Changing Thumbnail Pictures in a UserForm
- how to run recorded macro without showing processing excel sheets
- Auto Save
- Can't open an Excel document
- cell format
- Help::how to run macro without displaying workbooks..
- HOW to run marco without displaying the workbooks
- Macro Help
- Close the Excel Application
- MACRO TO UPDATE CHARTS !
- How to tell : how many rows a merged Column run over ..
- Comparing Ranges in two worksheets
- Identifying commandbar names in non-English versions of Excel
- DateDiff("w") -- problem
- Close Internet Browser
- need to remove zero while joining two strings
- Opening A Folder Using VB Code
- Online Tutorials about Macro
- loopig in Macro Programming
- How to view graphic files from excel?
- Protect Code
- sophistication with graphs
- Book on VB
- CRLF in text box
- Creating a User Form to update a list
- control element
- Next Blank Cell
- sqr function in vba
- Pasting the same Value into a Range of Cells
- vbYesNo
- Stop Highlighting a Range
- Userforms - Display result of a calculation in a textbox
- Looping Macro to remove data where value is 0
- How to save each sheet as a separate excel-file
- DIM is what i am
- How to run macros and make the workbooks invisible
- formula for numeric order
- Tom Olgilvy Question
- Code Cleaner
- Adding code to worksheets
- Save As macro
- Copy from Column to Column
- (Thanks alot TOM)How to run macros and make the workbooks invisible
- thanks TOM. How to run macros and make the workbooks invisible
- How to retrieve the name of a picture within a worksheet?
- Vb Code not working
- Excel 2000 to Excell 97 Vba Problem
- How to supress a Save prompt?
- What is the hierarchy of code execution?
- Hide/Unhide sheets
- Excel file embedded in Word doc--limitations of work area
- Modifying text in Chart Tips
- Q. Pie Chart problem. Want to add series, from another worksheet.
- Time Calculations using VBA.
- Cancel in Save As and Open
- Formula for regression
- How to permanently delete a custom toolbar?
- Same macro in two files
- Shift-Control Arrow and RefEdit Control?
- Excel 2002
- ado connection string for excel 2002
- Selecting multiple columns
- Run Time error '1004' when running Calculation method
- Visible Property
- Workbooks in multiple running Excel applications
- application is not getting closed through automation
- DDE equivalent in Excel 2003 / .NET ? (push technology)
- Seperatin data ffom one column into another column
- DAO Nomatch in office xp excel vba
- Text Box exit
- VBA insert messing up Vlookup and Match
- System error &H8007007E (-2147024770). The specified module could not be found
- Animationen
- Variable in a VB Code
- Pivot Table Chart
- Selecting the first cell of a row
- ActiveX Component Can't create object - Any Explainations?
- Insert Rows Macro
- Run a macro in the active cell.
- SaveAs command when a file already exists?
- Macro Button??
- Excel 2000 Find without select VBA
- Error Trapping
- last Cell in a selection?
- Excel Addin help!!!
- Functions in Statusbar Won't Display
- Scroll Bars in UserForms
- Re: Add-In - Component not correctly registered
- Count of unique values in a filtered column using 'find'
- With ActiveSheet.QueryTables.Add
- Currency
- Excel Display Problem???
- VLOOKUP Issue
- Last saved
- Disable Add/Delete/Move Worksheets
- ADO & semicolon delimited text file?
- using variable as cell location
- Source data of a pivot table
- Possible to generate a GUID in Excel?
- Add a Column Range to an AutoDate Macro
- entering individual array formulas with vba
- Changing data returned from an autofilter
- Excel and COM
- How to verify the existence of a file with formulas in Excel 97?
- Force Delete a Sheet
- Copy a Sheet without physically opening the file
- OnChange Event for a Cell
- Excel VBA - Chart title problem
- Excel automation "Error loading DLL"
- sub vs. function bhavior regarding 'Workbooks' obj. functions
- user's page doesn't show on screen unless a print preview is done?
- Export PDF information into Microsoft Excel
- loop command in Macro
- loop command in Macro
- Class Modules
- MultiPage
- Ampersand in front of font name
- Class Module Scope
- COPY MACRO
- Does an open dialog box slow down or stop a Macro?
- Conditional data move syntax
- I'm having some trouble with variables in Excel '97...
- Monitoring application-level event problem
- How to step through top row of a Range object
- Copy/paste text in cells into a textbox
- create a user input form
- excel - formula anb VBA
- New Data Type - Latitude and Longitude Calculations
- Chart title
- Workbook Deactivate Event
- HELP!!! Beginner needs help with VBA coding
- Autofilter across two workbooks?
- Determine File Type
- passing value with button to macros
- Loading a web page on a web browser control
- Copy/Paste Function for multiple columns
- AutoFilter Question
- application.caller
- <Pass the Torch> from a Closing Workbook
- <Pass the Torch> from a Closing Workbook
- Autosaving Workbook
- help !!! please... closing excel application using automation
- Range Selection with Arrows Keys
- How do I display text in a (popup) window?
- Search and Compare two Workbooks
- change VBAProject References Library
- Total Line in Report
- Basic UserForm question - please help
- Run Excel add-in on client side
- Help! Please help with my code
- Adding Code Module to Workbook
- ActiveX message XL2003
- Ctrl-v doesn't work after changing Application.DisplayFormulaBar
- How do I refresh a form in excel?
- Multiple excel windows
- Insert row with macr
- help !!!!.. Excel object not closing
- problem with change from excel 97 to xp
- Propogating errors after closing Workbook.
- Resetting Excel commandbars on close event
- Sorting into Surname order (alphabetically ascending)
- combining data from two sources
- Compile Error in Hidden Module:
- auto filling relative worksheet references
- CSV (Comma Separated Values) delimiter ?
- How do I drop an Open connection in Excel
- Password request to run macro
- Macro or VB Code
- Lost toolbar
- Progress bar in statusbar
- Recording macro to activate other macros
- VBA - AutoFilter - 'nonblank'
- Refresh label on user form with RefEdit
- True - False
- Check Box Macro
- How set column width using mso-... in style sheet ?
- How do i change the format of a cell based on the condition of another cell in same row?
- More questions about variables and procedures...
- Postioning combo box
- Cell Protection fails with validation lists
- excel vba interface with outlook (office 2000)
- Interacting with Explorer
- Password Protecting a Macro
- Combobox programming
- Macro to Finded Defined Names with #REF
- Saving using a path
- Declaring as Object rather than Excel.Worksheet
- Detect Password Protection on a Sheet
- Macro To Create Other Macros And Buttons
- Ckeckbox size
- Finding referenced worksheets used in a worksheet
- Importing fractions with proper format from CSV
- Chip Pearson: A Question about RegServ32 and DLLs :)
- Subtotal and Total Columns
- Protecting Multiple Worksheets
- Change cell format programmatically
- system error &H8000FFFF
- macro for conditional number formatting
- PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET
- Using up, dwn, end, right, left in vb programming
- Applescript Problem
- Printing To A Specified Printer
- Range Name Found??
- Passing a Range to a Function Problem
- Library references
- finding the last row populated in an excel object
- Color of Cell Background
- Need help with check box coding, urgent!!!
- Screen Updating
- VBA code in multiple workbooks
- combining data from two sources
- Need help with check box coding, urgent!!!
- elapsed time in msgbox
- Automatically run a macro when opening an Excel file
- help worksheet event code
- automatically fill up a cell?
- Macro security question
- string manipulation
- Sorting Range Help
- Information Positioning Problem
- copyfromrecordset performance
- Help me make a function dependent on current sheet?!?
- Changing one range on multiple sheets.
- Input Box Cancel Button
- Using a Macro with the sheet protected.
- Silly Question
- Cell Color Change
- How to prevent the MS Excel error dialog by errorhandling ?
- Displaying answers that are off screen
- Module Names
- How to find lost macros?
- CopyFromRecordset does nothing
- COM + Excel + Win2k3 Standard Version + IIS6
- Displaying all the states in a VBA combobox
- Comparing text instead of values?
- Subscript out of range when adding worksheet
- Creating a Range object in .Net
- Formatting Codes for header and footer
- Apply password to multiple Excel Files?
- Excel XP removes AS part of statement
- vlookup problem
- editing code with code
- question
- How to pass values from a userform to a standard module?
- Excel 4 Macros in Excel 2000
- Inserting Rows
- Passing a Range to a Function problem (still not working)
- RE: Selecting to end of column
- Calling VBA function that is in another module
- How do I deactivivate a workbook?
- Publish Excel Pivot Chart
- Rich Textbox not "trusted object" in Excel 2003
- Rows and Columns View
- Copy a range of data then E-Mail
- Prevent entering duplicate cell data in a column
- Moving multiple row cells into one row
- Solving Circular Reference Formulas
- Autorefreshing excell external data while opening from VBA code
- one macro calls the other
- select last cell in used range
- How to define a print range?
- macro to export files but not replace an exsisting file name
- Removal of spaces
- ADO and Excel versions
- setting up excel for multiuser
- Same code, different line
- how to run a macro in word
- How to wrap text in combo box?
- listbox problem
- Slow Looping
- Solver and VBA in the same model
- How to prevent pasting to every sheet in workbook
- KeyPressed Event
- User selection
- Visual basic (combining wrkbks)
- replace doesn't
- auto filter and auto fill
- Excel Programming
- Excel don't quit in ASP.net Code
- Keep cell reference when picking up information from another database
- Testing for contiguous cells
- Keep cell reference when picking up information from another database
- Changing XL97 Application Icon
- excel windows 97
- Counting using conditions
- EXCEL 97
- color coding largest in a list
- Cell access
- searching for a null cell in a column
- Message Box if cell value not in specific range
- Picky/Choosy
- Help with formula please
- Using datetime fields as parameters in a query...
- Excel to Visio to Word
- Cell identification in x,y coordinates
- Macros
- Concantenate using VBA?
- Pivottable, month, sorting
- Crash Using Watch Window XL2000
- Combo Box Question
- Printing non-adjacent areas on seperate sheets in one print job
- Modify duplicate code
- Week Numbers
- Re: Filename with current Date()
- Controlling Word from Excel
- Filename with current Date()
- calculation in menu/tool bar using option buttons and pull-down menus
- Excel and Dbase
- Set No of Sheets in new workbook
- Bi-weekly date calculation
- How to run a macro in word web page
- SumProduct function
- Text box on userform
- Importing a Directory Listing from CD to Excel
- Excel database access
- Emulate C/C++ struct in VBA?
- xlDialogFormulaFind Dialog Box
- Creating a PivotTable in a Different Workbook
- cleaning up a field
- Finding last number in cell
- test
- Protecting and Unprotecting multiple sheets
- .saveas and .close methods from Access
- excel sqr function vba
- ABS Excel Function
- Sorting data based on validation cell
- Find, Lookup, who knows???
- How to trap the error message "Remote Data not accessible"?
- reading/inserting variable dates within a macro
- New Workbook New Session
- FileSystemObject CopyFile with UserID/Password
- Listing External Worksheet references to your sheet
- Saving template as non executable file
- Creating a Data Entry Userform
- SUMPRODUCT QUERY
- Excel VBA Calculate Problem
- copying sheet with macro
- Macro to protect/hide formulae
- Code Bug
- Control on worksheet to display 2 col's of data
- Error trapping don't work
- Trying to *simply* programmicly get a bmp file to be the plotarea backround
- Retrieving data from Access via SQL/ODBC
- Run code for multiple worksheets in a workbook & Column Formatting
- VBA Code statistics
- buffer overflow
- Easy Q: Visual Basic and Excel
- formula for rounding
- VBA reference error
- Macro or VB HELP!
- How to loop through all ranges in a worksheet
- help with type mismatch error
- Tricky vba Raffle Ticket Problem?
- Range of cells
- Using cell color as condition in equation
- Macro to protect/hide formulae
- VBA DAO 3.6 Database - How to release resources on the PC after multiple Queries
- Help with the Excel-object
- Digital Signature
- Installation error Access add-ins
- PivotTable selection
- Creating a dynamic list
- App Close and File No Save
- Open File with Links?
- Copy value and fill blank spaces below it until new value is encountered?
- Re: Using a macro to write modules
- Using a specific range to populate a list/combo box
- Switch between workbooks
- Re: Using a macro to write modules
- When to use .INI files
- Command Prompt
- ReDim Problem
- close work book via macro
- Control on worksheet to display 2 col's of data
- auto fill columns
- Calling functions from Excel worksheets and the Find function in XL '97
- Protecting & unprotecting worksheets
- Cells().value is null but I can see data
- How to references objects that exist on local or network drives that aren't open.
- OptionButton type name?
- Comining lots of functions into one User defined function
- Exceeding the limit of Nest IF's
- help with user form that won't go away
- ActiveCell not recognized
- Export method question -- Spreadsheet ActiveX component on user form
- Offset function with merged cells
- Query Sheet using a WHERE clause?
- tickler for date + 180 days
- EXCEL FILESEARCH
- Question about scoping variables
- Import ascii file
- Replace Functions not working
- Macros to hide/protect formulae
- Copying workbook
- Excel hangs when trying to open a file
- VLOOKUP with a Boolean membership condition??
- High Tech Question ?
- Error with Target.Name.Name in Worksheet_Change event
- Check for sheet name
- Find Value in Array and report on Location
- Opening a text file for input
- Adding colour background to control
- System asks to save when no changes made?
- Com with Word
- Can we Pass String to FieldInfo Array to OpenText Method.
- Loop command in Macro
- Pass string as Parameter in OpenText method
- Comparing two times (HH:MM:SS)
- Opening Files based on list
- Help with Solver
- Excel VBA- Get user input, search the for match, output to text file
- Need a macro to run sort automatically
- Copy without borders!!!!!!!!!
- Using classes defined in an add-in
- ODBC connection by udl
- quick money
- Inserting rows macro
- Msg Box Question
- Custom ToolBars
- Excel Macro Help!
- Passing Values to Function
- Function Definitions
- Re: Other undocumented VBA changes?
- Assign macro to button in EXCEL 2003
- Find First Cell In A Range
- Buttons Control Tip text
- I can not find the msexcel.olb file for Office XP?
- Adding all the data to one sheet
- Application.WorkSheetFunction.DafeDif (not DateDiff)
- Passing SQL Query Result Into A Variable
- need a loop
- Macro with in a formula
- Toggle Text in a column to be visible or not visible
- VBA created formulas won't autocalculate
- Fixed Columns
- Sum Filtered values
- Macro Error Message
- Macro Error Message
- Hyperlink
- method vbproject of object workbook fail
- Installing XLA on Win200 Server (Office XP Developer)
- why doesn't this work?
- Bad or Missing References
- Problem with quitting Excel opened through automation
- if in excel the file is already open...bomb
- PivotTable selection
- How to find out if a button exists on a sheet
- Converting Values
- Reading the pin voltage fm RS232 port into excel by using VBA
- Requiring Cells be Populated
- Date format on import
- Creating Specific Excel Formula Question.
- Removing duplicate entries
- Changing from lower to upper case
- Clearing shading before printing
- Deploying a .NET add-in in Excel 2002
- reverting to first page on exit
- Excel Embedded Links
- Macro to Start on a New Line Each Time
- Hyperlink Macro-links to other excel files
- Add spaces to end of field in save as PRN
- Re: Driectory changing
- Re: Unhiding rows in Excel 2003
- Get address of cell clicked
- reading variable "from" and "to" ZIP codes
- Write new VBA code from within a MACRO
- refering to option buttions
- Alternate to Range.Find
- VBA Excel Function
- Creating an "update" button and using a macro to copy data from multiple sheets
- All open workbooks
- Simplify
- Using bold and normal font within one cell
- FINDING LAST ROW OF THE DATA
- SQL data access help required?
- Excel macro - Help with duplication validation macro
- Re: How To Get 1 Million Visitors
- Option Buttons
- loop to name ranges
- Calendar Control
- Going Bananas
- Get…UCase or LCase ???
- Macro to hide formulae
- Excel VBA - Trying to change color of cell conditionally
- How do I have excel not to prompt user to disable or enable a micro
- Looping thru files
- Identifying and deleting all but the first and last cells for certain date
- continue to move data until all moved
- Creating a PivotTable Report from an Another PivotTable Report
- Annoying prompt: ActiveX and app initialization
- Userforms and Print Preview
- VBA with EXcel 2000 and series line colors
- ascii file import round 2
- Identifying Duplicates
- Get…UCase or LCase ???
- Excel 2003: Changing an XML Map
- Access Report
- Split query
- Where do digital signatures reside?
- MultiPage control: Easy question
- Rounding Logic Question
- Copying Data onto sheets
- Macro Dialog Box Help
- Normal Distrubtions with Upper/Lower Bounds
- Excel VBA - Graphics
- Generating a list of all possible number/letter combinations
- Subtotal using VBA
- Macro Help / Question
- Newbie needs help in VBA
- Simple hiding columns with vba does not work with a checkbox
- Compare items in 2 ranges
- Newbie needs help in VBA ;creating a click() function
- Change Cell Data of a Required Column
- Coping all cells with data.
- Delete empty rows in a worksheet
- Want to hide check boxes
- Still stuck with importing a delimitted file.
- Ascii file import round 3
- Run module ON OPEN event??
- VBA-Graphic
- Help with the basics. Starting out.
- Parsing data - variable length cells
- search value not formula with .Find
- Upper and Lower Bounds and Rnd
- Upper/Lower Bounds
- Removing a user form with code
- Tracking changes made in cells
- Re: View the data in a cell on a userform
- Removing and replacing toolbars...
- Help with Run-time error
- Help, Unable to start Excel
- Programing with a "Find"
- Anywhere to see list of predefined functions available?
- How to Cancel a Save?
- macro disable and enable.
- Move a sheet
- unable to edit macro!!!
- Multiple commands from single IF.
- Someone please Help!
- username and password for form excel vba macro
- date in color
- how to add message box after a macro is completed
- 3 conditions if else statement.
- Looking for some source code for navigation bars
- Using same code for Multiple cmd Controls
- Suggestiong coding...
- Why my cell format is not copied when I copied workbook?
- message box while macro is running
- Newbee Q: How to make search field in excel sheet?
- accelerate in loop
- Pre-checking checkboxes in a dialog box
- Search more than one result
- Coding help needed
- How to DISABLE THE CONTROL BREAK shortcut keys
- help with algorithm
- Can I toggle this Code - to Stamp and to UnStamp?
- vba function description visible in Formula palette ?
- How to delete a row depending on a script
- Visibility
- Multi line Select Query
- A Question for Ron de Bruin
- Running out of memory
- What's new in 2003?
- Auto_Open/Close Mods
- Visibilty cntd
- Events in Excel for executing functions
- Macro to insert and delete rows
- Lookup Tables
- password recovery
- help with code
- Trouble exporting chart to htm file - need help
- Sinple one.
- Different Values & Printing.
- Multiple workbook recap
- Search for common data lines (loop)