- If..Else Statement in Excel
- Assigning the name of a userform/control to a changing string
- Combo Box Values
- Demo of Wheelmouse Scrolling Listboxes
- The Tab Function
- The Tab Function (Take 2)
- find next unused row
- A question on read the record from excel
- Debugging F8/ tracing
- control toolbox
- Copy Multiple Spreadsheets into One Workbook
- ActiveX Controls on Excel sheets
- what is a vb script
- Re: Quasi array formula
- Beginners' Question : How to move selected columns & rows to a two dimensional array
- problem (bug?) using =HYPERLINK in database query column?
- Worksheet Change Event Help Please
- ComboBox Values
- Copy selected data to new workbook
- ResetColors failed
- Re: How to create picklists programmatically
- Excel textbox problem
- row highlighter
- Accessing/Clearing range in hidden workbook
- Newbie. Please help me find a loop solution
- Converting XML data from SQL Server to Excel spreadsheets for reporting purposes
- excel and powerpoint instructions. Possible?
- Re:Find out from a date if it is a red letter day or not
- Web Query fail to Refresh All but individual refresh is ok
- Web query timeout
- Two really easy questions
- tough problem - working out if data is within certain boundaries
- Code to Hunt Linked Cells
- removing text within a cell
- Code to copy chart
- Msg Box
- Re: Newbie. Please help me find a loop solution
- End loop macro with count
- Beginner's question
- Open Method disabling Macros
- PivotTable: AddDataField method
- Re: Code to copy chart
- Re-assigning the value of a variable for a for loop from
- Sending an array to DLL Function
- Modify Calculation
- auto find xls files and values
- Re: dynamically linking cells
- setting label to open folder
- Re: The Find Method
- Re: Macro - Pasting clipboard in a find box
- IF ___ then fill color???
- Re: Logic Question - Can you help please
- Creating a directory from a date
- Control Source
- Excel 2002
- Re: Paste in Find and Replace Dialogue
- Opening a worksheet with a button?
- Re: Importing files
- Re: Paste in Find and Replace Dialogue
- Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
- Re: Finding Empty Rows
- Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
- Re: Finding Empty Rows
- Formatting the default Excel sheet
- RS232 to Excel
- Excel VBA
- Re: Code for Grouping Text Values in Pivotfield
- Using Built in Functions in VBA Code
- TextBox.SetFocus
- Re: Excel VBA
- VBA to Find & Delete
- Web Query & Cookies
- Responding to Enter Key
- Vlookup issue
- Hide worksheets on start
- Re: UserForm Control
- Re: UserForm Control
- MS Excel - SQL Parser with VB .NET
- Sorting with worksheet protected
- Automate macro
- Re: Joining text in multiple cells
- newbie programming
- Replace File
- Creating worksheets then name it
- My Apologies
- I need help
- macros, functions, and command buttons
- Re: Worksheet name used in a formula
- User-defined function creating circular reference
- Changing Author Name in an existing cell's comment
- Using a variable to represent a Checkbox Name(OLEObject)
- Personal.xls only partially effective?
- Determining if a worksheet exists within a workbook
- Delete userform/module using VB
- Excel macro on a DOS command line
- SetFocus method in VBA
- find data on 2 different sheets?
- Re: Button To Cancel Macro
- Re: Delete cells in row A with just zeroes
- A code problem with short Estimating worksheets
- Re: macro that runs for multiple files
- disable menus on opening Excel
- _How could I get the code to find out the resolution that user has in the computer
- What order does VBA look at userform controls?
- Re: Counter
- Re: Counter
- Excel 2002 Automatic Macros
- Code help.
- Determining whether function called by Excel or VBA
- Macro
- Adv. Filter & Worksheet Change Event
- Command Button Properties
- Single command button to select one of several choices.
- Do Until loop with if statement
- Re: Collating Sheets question..advice plz
- Re: Worksheet name used in a formula
- Permit DoubleClick but prevent other editing
- Re: Empty Cells!??
- Re: Run-time changes to subtotal parameter list
- Re: Network drives
- Re: DDE and application.caller help
- How can I do this using MS Excel ?
- Sending data to Outlook for emailing
- Setting values in another workbook
- Copy with NumberFormatLocal included
- DCOUNTA formual in VB Script
- Excel returns blank values using ADO/VB
- Spinn Button
- Re: ComboBox items
- Koppeling Excel en JPG-Afbeeldingen in aparte map
- Problem with using Protect when userinterfaceonly:=True
- Search For Data In An Excel Sheet Thru Code
- Looking for break even axample.
- Excel Spreadsheet Corruption
- Close button on Custom Menu Bars
- Re: curious date results
- Re: Need Code Enhancements
- Re: DCOM98 and EXCEL2000 collision
- Mouse Click Event
- Need Code Enhancements
- DCOM98 and EXCEL2000 collision
- Date function and combobox
- Decreasing/Increasing decimal places
- Counting Colums with Data
- Finding Duplicates
- Excel 2002 and 97 compatability
- run macro for all files in the directory
- Running a VB Script
- open for append
- Re: Excel Page count
- Re: Excel Page count
- Import and transpose tab seperated data from text file
- writing cells with variables from vba
- Re: How do I set the name of a WorkSheet?
- Macro Questions: Returning multiple results, description of parameter syntax et al.
- Re: writing a variable to a cell
- References question
- Re: writing a variable to a cell
- Re: Countif Function
- Macro to Paste Special
- Revisit "Close without Saving Changes", please?
- Recommend a good book for vba for a beginner
- Re: Automate Control Tool Installation
- Re: Countif Function
- Activate Column after locating text in a row
- Excel Getobject error
- Custom formula
- Re: Countif Function
- Re: Designing Multiple Spreadsheets with scaled data access.
- executing macros with variable names
- Cannot shift objects off sheet
- Countif Function
- Countif Function
- Re: Zero out the cell macro
- Project won't compile...
- Re: Macro to Paste Special
- expected sub, function, or property
- Disable Control s
- Put copy/paste between books in macro
- Selecting Cells to set up Advanced Filter
- Re: Unhide row
- Formula Probs
- Thank you all.
- upload a button image
- Pivot table not refreshing
- Running macros
- Formula Problem
- Format a cell IF...
- Trendline Equation
- 1.)Input Boxes 2.) Condensing a Code
- Re: Formula probs
- MSForms cancel
- Programatically Breaking Links of Copied Chart Sheet
- Obtaining Series Name and X/Y Value Ranges for Charts
- sql.request for secured Access Database record retrieval
- tool bar problems
- Copy formulas to certain sheets
- Unprotecting worksheet in a macro.
- Re: hiding vba code
- Re: Automatically generate a unique file name via macro...
- Re: worksheet tab - rightclick choices
- Re: Sheets(array) method for printing grouped worksheets
- Re: Enable Macros Warning
- Embedded form?
- Re: cboBox to read data from a spreadsheet Range
- How to make drop-down lists show more rows
- retreiving number of e-mails from public folder in Outlook
- Sorting Names in an Array
- Re: how to kill excel using a vbscript
- Re: Scroll
- Printing question - Spreadsheet......
- sorting zip codes
- Re: retreiving number of e-mails from public folder in Outlook, next step
- Re: Save as CSV without being prompted
- Re: Formatting in VBA
- Re: Automatically generate a unique file name via macro...
- For Each
- Re: pull value from last cell in a column
- Determining the immediate caller of a function
- How to Pause or Stop a running Macro
- Spin Button
- run a macro on an in-active workbook
- countif and AND
- Re: Page Formating & Macros
- Custom Toolbar (Macro path changes)
- Re: Save as CSV without being prompted
- Excel tries to reopen the file
- Searching / Calculating Multi-Dem Arrays
- writing to a cell
- Re : Excel event handler Worksheet_SelectionChange
- Possible to delete or edit a desktop shortcut?
- Pop Up Screens
- InStr used in SQL query
- Re: Value of Zoom print setting
- Re: cboBox to read data from a spreadsheet Range
- Re: Empty Cells!??
- LTrim
- Re: Beginners' Question : How to move selected columns & rows to a two dimensional array
- to kill a excel process
- Re: Sending data to Outlook for emailing
- Breaking a word by each alphabet and inputing it in different cells
- How to: reset the pull down menus to item 1 on start up?
- Re: How to: reset the pull down menus to item 1 on start up?
- FormulaArray and Formula prinicples
- Data Validation
- Re: Unload from Memory
- How can I create several instances of Excel ?
- Key behaviour
- enabling custom meu items?
- Re: writing a variable to a cell
- FindFormat
- Customizing the Legend
- Toolbars
- cell color within a function
- Number format in a message
- Highlighting 'corresponding' cells
- Re: charts
- Hide/Unhide a row in Excel
- run exe program and locate current workbook
- Protection
- Web Query
- Deleting Macros
- Conditional Formatting for Currency
- Cashflows
- Popup form from Excel not VBA
- Programming behind a button
- excel 2000 workbook.activate not 100% reliable with alt+tab
- Re: Change hyperlinks en masse?
- Richtext Control
- Re: Enable Macros Warning
- show a userform
- Re: Automatically generate a unique file name via macro...
- Calling a function from within EXCEL
- Print Macro : Object not set
- Symbols in UserForms
- Rename attachment
- Rename a sub
- Re: This is just a test!
- Re: Macro to print on both sides
- Help with Formulas
- Worksheet_Change Event "Circular Reference"
- Application.Calculatefull function
- ON ERROR
- column drag-and-drop
- Re: Loops
- Passing a value to a variable from Userform
- Sort method of range
- Saving macros before re-install
- Re: Formatting Problem on Double-Zero String
- Re: Macro to print on both sides
- debug errors....
- User Form
- Please help: Running a macro only once
- Excel Web Query
- Close database if it is open
- Non-absolute named ranges
- Keeping original data format in a pivot table
- Form output naming
- Conditional Formatting
- Re: Does destroying the ADO Connection close the database?
- variables in last cell
- Re: Does destroying the ADO Connection close the database?
- DateLastModifed and Open File
- Copying files ...Network to Network
- Re: Naming Worksheets in VBE
- Re: Naming Worksheets in VBE
- Unlocking Cells
- Re: marco variables or substitution
- Re: Unlocking Cells
- Copying ranges
- using end and down keys when recording a macro
- Deleting a Prompt Message
- Proper way to pass errors up the line
- Re: marco variables or substitution
- Pivot Table - Change SQL Statement Problem
- I can't solve this one...can anyone help
- RunTime code problem
- The Macro Window
- Re: Enable Macros Warning
- Creating a new word doc and putting some VBA code behind it
- passing variables from excel to word
- CLEAN function does not work
- SUM using Three ranges. Two Comparisons and the SUM Range
- Re: Userform button options
- Re: Date Created reported as wrong
- Re: UserForm not passing Boolean variable
- code break
- Why am I getting NA
- Unable to launch html helpfile
- SUMIF
- Re: Programming a current procedure
- Age function how to
- Re: Dynamic Values in Procedure
- Pivot Table Problem
- Delete row where active cell is located using VBA
- Re: Delete the row where the activecell is located with VBA
- Data Entry on a Form
- Re: finding a range of cells to match a date
- Re: Hangs on Outlook after sending excel ss
- copy to hidden sheet
- Please help
- Excel 2002 to automatically e-mail me a reminder
- How can I get "File Close" to prompt me to "Save Changes" ??
- Re: copy to protected sheet
- copy to protected sheet
- Assigning Selected Cells to Code
- Help Creating XLL
- Re: finding a range of cells to match a date
- Starting a macro by changing a cell in a column.
- send page by email
- execute code for all 12 months
- Contect Menu Help
- counting non-empty rows in a column
- inserted code into project but can't run it in run dialogbox
- Newbie : Advanced Filter Criteria
- Use list box to navigate to different sheets...
- Variable Filename/Worksheet/Workbook
- Help with some code please
- hide row automatically
- backup file
- CommandBarControl class
- data validation
- Re: VLOOKUP
- Re: VLOOKUP
- coloring limits
- Line numbers
- Re: icons for custom menu choices
- Macro Help, Please
- Re: Unwanted Protected Code
- Undo & ErrorHandler
- Insert colum with 0's
- Help files will not display
- Change location of where file is stored
- text box on a form
- Hyperlink question
- Re: cannot get total
- Extracting values from multiple EXCEL spreadsheets into one
- Using Arrays in InputBox Method
- Re: cannot get total
- Comparing Two Columns - Multiple Words in Same Same Word
- Comparing Groups
- Running a batch file from Excel VBA
- help
- ...................................WOMAN IN DESPERATE HELP!!
- Apply macro to closed workbooks
- Exception 0x800ac472 when accessing Excel
- CONCATENATE
- Re: Hiding rows quesion
- re ControlButton numbers , Id:=???
- Re: CONCATENATE
- Evaluate OptionGroup in XL Dialog
- Enable Macros
- Validation code not functioning correctly
- scraping text from the active window
- Re: Duplicate values
- Re: Duplicate values
- Checking Listbox Items
- Re: Problem - Deleting a Picture from a Cell
- Templates
- looping through worksheets
- Randomly fill in rows
- SumProduct or Array Function for summing by month and year
- icons
- Copy VB code to other workbook?
- relative vs complet reference
- Randomize a list of names
- add VB6 Clipboard object
- INDIRECT reference
- utility to add standard comment
- programmatically close help file before Excel closes?
- C# (sharp) and Excel
- VBA Runtime Error
- Macro records in R1C1 style
- locating and separating out duplicates
- Re: looping through worksheets
- Excel not warning if another user has the workbook open
- Data validation using calculated list
- how to assign ranges on different sheets to an array
- auto add column
- File save location with Application.GetSaveAsFilename
- Form control not working
- subtotalling where # of columns vary
- Controlling the mouse
- Need help creating a userform with optionbuttons
- formatting
- Click event on Scrollbar
- Re: Find button in excel worksheet
- XLL support discontinued?
- DATA VALIDATION
- Start Excel from Java
- DATA ENTERING IN DATA VALIDATION
- Re: adhere to cell menu left-margin
- DATA VALIDATION
- error with data validation
- Free animating ActiveX control
- User Defined Functions
- Web Data
- protect sheet blocks filter
- Re: 3 problems giving me grief. Any help appreciated.
- Building a form on the fly
- Resuming code after closing a print preview
- Whole vs decimal
- create column & Row in userfrom
- List all Functions
- Auto_Open disabling
- Default Date: Today
- chart titles
- Replace Function
- Re: Replace Function
- Event Question
- Re: Simple Question
- Random file name
- Re: Automatic print area
- Changing SQL Statement for PivotCache linked to multiple tables
- converting workbooks to worksheets
- exception at 0x6503999b (VBE6.DLL) - Please
- Menubar locked in Internet Explorer
- Re: Set Value for Date/Time Picker
- Counting selected entries
- sum with two conditions and a wildcard
- Replace Excel-Icon on Worksheet Menu Bar
- VBA Excel 2000 - one shot multiple cells modification
- Copy and Paste ranges between files
- Excel97 cannot access file
- api call routines
- long IF statement with lots of OR's
- Re: Save CSV as TXT
- Re: PAYMENT CALCULATIONS
- use shell function in vbscript
- Break Modes
- Trouble with Focus
- ListBox Populate
- Macros disabled on all but one of 3 windows in excel
- Compile Error! Can't find project or Library --- Help!
- Copy Word table to Excel
- Macro to change security level
- Cell Formula
- Any way to grab a .csv file from a folder using Wildcards
- Frequncy of unique values in array
- XP vs 2000 macro error
- Script?
- add-ins error + setting workbooks
- Exclude directory from .FileSearch
- mail message 1.0 Type library
- Re: How to set focus back to sheet after showing a user form
- deleting rows, takes a long time!
- copy/paste macro
- time of day automation
- Using the Vlookup formula
- looping from one column to the next
- Force File Read-Only?
- User Defined Type Structure - want it to be variable not numeric literal
- Force Read-Only?
- excel chart embedded in asp page
- Error Handler not handling error...
- code for lookup,& triggers.
- Re: right right$ left left$ mid mid$
- Finding a cell
- Re: right right$ left left$ mid mid$
- selecting a range
- importing prn file
- Excel crashes when created files open ...
- Getting Application.Sum to act like =SUM
- Two AddIn Questions
- Re: right right$ left left$ mid mid$
- Time of Day Update
- Commenting custom formula fields/formula on formula editor
- Stuck myself - can't bring back "VeryHidden"
- hide #VALUE! and ######
- Re: Color Coding Cells
- Option Explicit and Arrays
- Is it possible to assign a macro to a pivot table?
- file search with excel vba
- Userform Textbox writing to a cell
- Conditional formatting
- Disable a command from with in a workbook
- Fill & Filter in VBA
- CommandBarButton.OnAction prop fires when set? Arg!
- How to enable macro when Excel doesn't give you an option
- Stopping pivot table refresh
- Running a macro on a template
- Event triggered by Hiding/Unhiding columns?
- Re: external range in VBA (user defined formula)
- How can I start a XLL using VC++?
- macro that loops to multiple columns
- Re: Find button in excel worksheet
- Re: how to assign ranges on different sheets to an array
- Application.save gives a workspace file?
- Microsoft AccessLinks add-in
- Selecting A Range
- Re: Selecting A Range
- Re: Save CSV as TXT
- Re: Clear destination, then copy betwen workbooks
- Macro to Select Pages & Show Print
- Control tip text
- Bitwise And
- HOW TO: embed binary data in Excel - an odyssey
- Linking two userforms
- Scrolling text
- FYI - VBE Breakpoints Skipped due to Conditional Format
- Selecting A Range
- Re: external range in VBA (user defined formula)
- Re: Text Boxes on Userforms
- After save event
- Selecting a range
- How can I get the record from excel whit asp?
- About disabling Excel window size-change ...
- Re: How to set focus back to sheet after showing a user form
- Re: Approach to a Menu of Multiple Print Ranges
- Saving only active sheet
- DataCombo seems locked after changing TabStrip
- DataCombo seems locked after changing TabStrip
- Magic Shrinking Listbox
- count cell styles
- Re: grey ghost toolbars in Excel
- menu question
- If Worksheets("Test") Exists Then Delete It
- Opening CSV Files
- Help with borders
- Multi Select List Box
- save txt file
- Event detour
- Creating a custom calendar form
- Excel to Text
- RE: Stuck myself - can't bring back very hidden
- How do DLLs Work?
- HELP: converting HH:MM to text
- How do I move a pagebreak?
- Re: Copying from one cell to another
- Excel/VBA GetOpenFileName/MultiSelect Problem
- Loading text file
- List Box catalyst to cell reference
- Randomize a list
- syntax for a sub ( )
- Re: Help with selecting a range...
- Re: Freeze Panes with Object Model
- Re: Help with selecting a range...
- Re: Help with selecting a range...
- COM addin call missing
- Re: unprotecting pswd protected sht
- Re: Change Sheet By Macro
- addin a module on fly
- Re: unprotecting pswd protected sht
- Macro fails without VB help files
- Time Format & Unload problem
- "window scroll" event
- subtotalling - # of columns vary
- Automating Acrobat from Excel
- Send Mail
- Printing Multiple Ranges from Multiple Worksheets
- Re: Excel macro
- macros disappeared
- en-/disable macros pop-up
- Check my code to use template?
- Re: Import and transpose tab seperated data from text file
- Replacement for INKEY$
- Windows Common Dialogs in VBA?
- Better way to 'unhang' my workbook
- Default recordset type?
- Re: activex component can't create object with SAP 6.20
- "Store" ufm.checkbox values for later use
- i need help with a formula
- Re: disable pop up when overwrithing saved files
- Custom Functions used through the wizard
- Re: disable pop up when overwrithing saved files
- Re: get value of a cell with a mouse click
- Exporting data from Excel 2002
- "Microsoft Excel has encountered a problem..."
- More UserForm problems
- naming multiple public variables generated by single function
- disable pop up when overwrithing saved files
- Images will not display
- Embedded Word Document not painted until I click on it and activate it with the mouse
- reurning currently opened file name
- Modifying the right-click popup menu of a shape
- windoes system directoty?
- Passing parameter from Excel to stored procedure?
- Print all data from list on seperate form
- Updating database table from Excel?
- Combobox
- Using Dialogs Save
- Using Outlook with Excel to Input Names into Email
- Date/Time data source refreshed function
- Re: Macros run slow in XP
- Excel macro to VB executable
- Need UDF help; cycling through various sheets using VBA name property
- Saving excel spreadsheet in a cell
- macro to clear rows
- Re: Other applications
- Highlight Cell on Focus
- Re: Paste Clipboard from Word to last row in excel
- Text paragraphs and image
- move this rectangle to hide the unused cells
- Re: Ignore MsgBox if run by automation
- Re: Ignore MsgBox if run by automation
- Option buttons - disabling
- Preventing print when cells are blank
- Unwanted MS Acccess Query in Excel spreadsheet
- Hidding columns
- Re: Record Worksheet Content as Macro and Execute from another Worksheet
- Re: Using VB to find next cell in range
- Re: Using VB to find next cell in range
- Ever see a link with these symptoms?
- Toggle State on Custom Menu
- Re: split data in many workbook
- Re: Object Arrays
- Userform and passing date values
- Re: Object Arrays
- Re: Object Arrays
- How do I disable the Margins button in Print Preview Window
- Find links with code; change from G drive to C drive
- Selecting a range : New Question
- Code page for data in Excel spreadsheets
- Cannot run macro from toolbar in a file on another pc
- running macro while in the edit mode
- Cell Lost Focus
- Repeat importing text
- Adjust RowHeight progammatically based on number of lines of text in a cell
- Add submenu to custom menu
- visual basic macro in excel
- Place Subform data onto specific cells
- Microsoft Excel cannot find the data...
- visual basic macro in excel
- Place Subform data into specific cells
- Problem with saving REAL type to txt file
- How many entries can you have in List Data Validation
- dynamic range without using OFFSET()
- Deleting Shared Files???!!!
- sum & VLOOKUP
- Reverting to open workbook in excel
- What is the equivalent of 'Shift+Enter in a cell' in VBA?
- data validation in excel 2000
- Looping thru custom controls
- Automatic coping on 2 column
- why don't buttons work?
- sorting using VBA
- Code to Change Chart Type
- determining last column
- Disable read only
- What's wrong with this line of code?
- Mask an entry using InputBox function
- Which formula should I use relative to a date.
- colour and value transfer
- Variable TextBox
- Re: tried to execute application from VBA
- Re: dialog raise event?
- Missing Word 10 Object Error References
- Re: accessing CheckBox on Worksheet
- Form Popup
- Re: tried to execute application from VBA
- On Event Macro's?
- Please explain why following code doesn't work....
- Last Active
- Is there a way to remove numbers w/o remove formulas
- Hllapi Call to Extra!
- ADO newbie help please
- Re: Date Format - Unchangeable
- Saving a new file with a macro
- Password to hide and unhide sheets
- Password to hide and unhide sheets
- Re: additem to listbox built on the fly
- Re: protecting macro code
- Re: Change Sheet By Macro
- Copy one spreadsheet into another without activating second spreadsheet's user form
- Print Range
- Error in formula will saving
- Use numeric data from a textbox on an userform
- Inserting Hyperlink from a Query
- Get User Input
- Finding the first few characters in a cell
- picking up real time updates from bloomberg
- Saving an Excel file as a CSV using a Macro
- Formatting with IF Statement
- Strange (forms) ListBox behavior
- Disabling the Update links message
- XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select
- Re: Assigning Multiple Macros to One ComboBox Control
- Populating Active X Controls
- Cell in Range Testing Function
- Re: external range in VBA (user defined formula)
- Re: Asking user to set a printarea when none is defined
- Should I use Excel for this software project--or something else?
- Re: Assigning Multiple Macros to One ComboBox Control
- looping to create multiple files
- BeforeRightClick() and Cell menu
- Coping Values - Not the cell
- Re: Manipulating Excel pie charts with VB
- Array Questions
- Help with version control
- date question
- Re: Inefficient VBA Code - Worksheets Property
- KERNEL32.DLL error after running EXCEL Macro
- Can't find informations on TrendLines
- collapsing columns base on criteria
- Running a macro to concatenate
- Stopping "Link Worksheets?" message box (using automation)
- Even Better
- Re: Copy/pasting between 2 workbooks...
- Re: Calling Excel FUNCTION MACROS Programmatically from VB
- Re: Timer function
- NETWORKDAYS
- Re: tried to execute application from VBA
- Re: Copy/pasting between 2 workbooks...
- Using Excel Interfaces
- Assign data to chart series, using array
- Re: Get User Input
- Macro to delete last charcter in a text string
- Opening an Excel Pivot table sheet with right information
- User Form Apology
- Re: Run Macro on many files at once