- I Need Help with my loop macro
- Silly I know
- Import several txt files into separate sheets within 1 workbook
- Layering and staggering UserForms
- Not Enough System Resources To Display Completly
- workbook issue
- Array multiplication in VBA
- Use Office spreadsheet component in a ActiveX dll
- Grades
- Referencing password protected worksheets
- Spreadsheet component in an ActiveX dll
- Excel Object Documentation
- help on insert rows and fill down loop until end
- insert data into macro code from text input field?
- Automatic Vlookups in Forms
- Excel VBA extracting data
- Unicode string parsing? Please help!
- SetZoom in PageSetup
- Question on Removal of Column Filtering Upon Closing of Spreadsheet
- Extractind data from external database
- Put subtotals in a different column
- How to tell Who Opened Excel File.
- ACCESS TABLE EXISTS-ADO
- Never show User Defined Function Qualifier
- Linking a text box to an external Excel workbook
- "Mouse Wheel Trouble in Excel VBA"
- Referring to a user-selected range
- Finding the last entered value in a column
- ex - list box display sheets
- how can a user form be made that can find show and edit info for inventory
- How can I share my function with others user easily
- Open Copy Close
- How can I name the Module or class after I insert it into the Excel
- Disabling Commands
- Excel doesn't find DLL under XP
- Activate first blank cell
- Referencing labels dynamically.
- Find a Min positive value
- Store variables between XLA sessions
- List files in A1 Cell Downwards??
- Can macros alter locked cells in excel?
- Preventing linked cells from updating
- How can I...
- John, Bob, Chip...
- Copy generates an automation error.
- question about - excel macro copy chart to word document
- autofit rowheight after auto change line
- Combobox - add manual entry to future list
- Copying Sheets
- How can i autofill cells
- Input Box error when scrolling
- Excel Crash - page fault module
- Error msg "Microsoft Excel is waiting for another application to complete an OLE action"
- VBA autofilter bug??
- Conditonal Formatting VB Code?
- 2nd Conditional Formatting?
- cursor or mouse move
- Open Workbook
- Fill Down Blank Cells From Imported Reports
- Moving a variable number of Sheets to another Workbook
- Copy a file in VBA
- IF Command to Stop Macro
- Waiting for a valid input
- One line of code messed up!
- Help with Document Not Saved message
- Out of Memory error
- Select blank cell
- Not allowing an Excel Worksheet to be opened in Word
- Connecting to a DB in VBA
- return value from a fucntion
- UDF Question
- Set background color of a cell in VBA
- Help Tom Ogilvy
- Converting VB arrays to IXRangeEnum
- Extract image from toolbar button
- MS Month View Control for use in XL Userform
- Need help in excel with "Statement invalid outside Type block. " error
- Mailing from Excel and message question
- Closing Excel Object
- Print enveloppes' address from Excel
- Identifying cell types in column using .SpecialCells(xlConstants, xlNumbers)
- Setting timeout for Web queries
- Excel 2002 CDO Email Problem
- Which routine called Sub()?
- Solver code does not save results to sheet - What am I missing?!
- Q: Declaring a dynamic array
- how to import data from text file which has more 70k rows ?
- Sheet copying not working
- help with a billing sheet
- Continued Cell Formulas Across an ODBC
- PLEASE HELP!!!
- Excel Macro for VLookup Function
- limit textbox to numbers or spaces?
- Another question..
- How to find a specific inform with some cells and return total
- Problem with Worksheet_Change event
- Using for loop in a macro
- Custom toolbar in C#
- How do I combine these two?
- Compare checkbox with cell value
- Problem w/.EnableCancelKey = xlErrorHandler
- "Reference is not valid" error when using analysis toolpak in an add-in
- Macro
- Call macro from active workbook-duplicate shortcut keys
- Nested if /and formula
- Date Specific Input
- What variable controls wheatehr a cell is visible?
- Code to run an Access query from Excel
- write records to another worksheet based on criteria
- Help Crafting an Inventory Spreadsheet
- Exporting data to text
- Modeless Wait ?
- open file dialog-select file-import worksheet
- Add Icon to Toolbar
- VBA - Reading the file name and path from cells
- Find out Operating System
- automatic counter or auto-increment
- Formula help needed please
- Coding Format and Organization - VBA in Excel
- Trouble Opening Workbook
- Trouble Opening Workbook
- see if dynamic array used
- Delete Method of Range object doesn't work in VB script
- PivotChart formatting: macro for multiple unique charts
- VBA programming guru needed - HELP!
- Create Paste Values Button
- comparing or matching corresponding value
- Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell?
- Dynamic text in Mail Merge - any idea?
- Linking a table in Access to a table in Excel using MS Query
- Need to identify object selected.
- Sending Excel form to Exchange Folder
- Sending Excel Form to Exchange Folder
- update links when copying files
- Help sending active sheet to email list
- Run macro at specified time
- When DIM statements don't work
- Worksheet_Change sub causes funny results
- VBA Macro to "paste special"
- AutoExec - Enable Macros
- Excel VBA - Pivot table - Hide calc items when shows 0
- Blanked Password enter
- reconising matching no's in 2 seperate lists
- Using Application.Run in VBA
- User Forms
- forget file password
- protect only part of a worksheet
- C C+ Excel Coding
- custom round function
- COleSafeArray
- User Form Question
- How do I read a date from another page
- Capturing Sheet Events
- Follow up question for Tom Ogilvy - re: linking a text box to an external workbook
- Outlook Automation, Deleting Tasks
- TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
- Saving an external file without making it active
- schedule help
- Replacing One Sheet in Several Files
- Sharing data on a worksheet over the internet?
- code code
- Subdividing 1 grouping of data into 6
- Shown Drop-down list if login user=C
- How can I select all Controls in a wooksheets
- Excel file inflation
- New to vba trying to assign # to strings
- Delete new sheets?
- Dropping a UserForm
- macro to sub total a unique cell value
- Range Names associated with Sheet Name
- Excel .xls files
- VLOOKUP Problem
- list box record select
- Type Mismatch error
- Lock/Unlock problem
- Make counter invisible
- Userforms
- Parsing Data
- how do I link Textboxes in a userform to a Cell in a Worksheet?
- Question about comparing mixed case string values
- Combine Sheets From Different Workbooks
- vblookup newbie question
- Setting VBA passwords from within code
- Creating Command button Conditionally
- Duplicating data from sheet 1 to 2,3,4 etc
- Printing sheets with populated fields
- Code to return the data a chart is based on
- Limiting number of instances of a workbook
- Problem with EventClass
- One Record Only
- Copy/Paste to file of same name
- Cell Event Handler
- Median Function - Compatible with Subtotals?
- Help with Excel and MS Sql Server
- Change text color
- Password protection
- Can't Unhide Rows
- Worksheets hidden
- checkboxes on userforms
- Question about disabling message boxes if possible
- Loping through files in a folder
- Problem with VBA help
- formula does not work in macro
- Vlookup and text
- Paste formula into selection
- Macro print range
- printiing range
- time specific date input
- time specific data
- Preventing partial row deletions to avoid row data shifts
- Activate sheet event
- Activating a listbox in a dialogsheet
- Referring to a worksheet using variable
- setting a formula in cell on a totals sheet using VB
- Setting a value from a formula
- Search In Sheet using macro
- Unique generated alphanumeric number
- Excel Closing Problem
- When a value is changed manually or dynamically in a cell, how can I tell?
- Using Char() in Macro
- Copy Value in Excel
- Combine all text file in directory into one file.
- Macros with shared workbooks
- remove all blank or empty rows
- Find display the result
- Trapping Workbook OPEN errors
- Multipage Error Handling
- On Error function
- VBA won't recognize form object
- Macro to find row and delete it
- Very New in Excel Programming
- Drop down list
- loop count
- cursor position
- Populating Combobox Methods
- UserForm Checkboxes
- UserForm as Progress Indicator
- Date format
- Macro to search a column for a specific word and replace with
- Copy to a specific row
- Populating ComboBox Methods
- Colors in a diagram
- Disabling Menu Options
- Gathering info from saved files
- Macro to find an occurrence and create blanks rows
- Call a Web Service ???
- input form
- SUB ROUTINE
- Dynamic Web Queries
- Question about references
- Comparing 2 Lists
- Question to Chip Pearson
- Need Help Modifying Code
- Selecting or Entering a Textbox
- convert Works 3.0 database spreadsheet into excel 97
- Macro in Excel
- Run-time error 6 Overflow
- HELP - lost post
- TO TOM OR KEN: macro to calculate selected range
- Date Match Input Macro
- Directories
- single dimension array
- Delete Text Box
- VBA AVERAGE/IF condition
- Breaking text on the basis of condition
- VBA newbie - can i search the spreadsheet based on the active cell?
- Invisible linked workbook?
- excel add-in called Vision XL
- Chart Questions
- Help - Selecting and pasting into range
- Text to Form Textbox and back
- An easy one!
- Regional settings problem with TEXT(value,fmt) function
- Macro running before all others
- Worksheet_Change - loop within a loop
- How to check if the directory exists?
- Problem activating a sheet
- pivot's table problem
- Troubles opening a CSV file from code
- My last week question: how delete the Office Clipboard (XP)
- Adding image with code
- Renaming FORM button
- Problem with updating of texts
- Conditional Formatting a Button
- Exit a macro from an error condition
- Running a macro from a hyperlink
- To have an entire row highlighted to some color if any cell in that row is selec
- Borders - non-contiguous ranges
- shell out of excel into another app
- How do I Launch a Macro on a different sheet
- If Function
- Macro assigned to custom button - keeps changing
- What is the decimal value of xlDataValidation constant
- Moving relative
- Copying sheets
- VBA project unviewable in office 97
- Excel 97 Send To
- How to have a userform displayed and be able to work in a different spreadsheet
- How do I not "SAVE a WORKBOOK"
- Howto Improve speed?
- Copy a Macro
- Pinpoint pixel
- Date re-format
- Adding Range to List
- PasteSpecial takes too long
- EnableancelKey=xlErrorHandler not working in UserForm
- Date and string help
- Syntax error on codes
- Auto remove specfic excell attachment from email ?
- Lotus 1-2-3 {Windowsoff}
- Data Refresh Issues...
- Refer to a column
- DDE Links...
- How do I copy and paste ranges from VB 6.0 in an Excel spreadsheet?
- Macro to combine several worksheet formulas
- Combobox array
- Data from One Worksheet split into Multiple Worksheets
- Inserting Page Breaks every 40 lines...
- Protected sheets
- Contional Row Delete on Interior Color
- Web Query
- Delete rows that DO NOT contain certain text
- Syntax error on codes
- Combo box formula - how do i include it ?
- dde link update in vba macro
- SetFocus Problem
- Newbie - cell contents B4 change event ?
- Show data with line's like a IP-network
- CopyFile usage
- how to run a macro only if a cell contains a certain value
- Help in Excel VBA
- password protect on workbook
- Conditional Formating
- calling VBA functions from a cell
- How to access a called sub program to edit?
- Excel 2003 macro names
- Group Controls
- relative cell references in vba macro
- Excluding numbers
- Disable recalulcation upon open
- Whoa horsie Slow down
- password protect on workbook problem
- Problem occurs when upgrading Excel from 97 to 2002
- all macros into one..
- Date to nothing
- $ format in cell
- Sending email via macro- setting the importance setting.
- Can MsgBox Do This??
- Sending email via VB - address length
- Todd Huttenstine
- Add cells if values are the same in multiple columns
- Copy and Paste a Worksheet Range to Email Body
- Assign Chart Title w/ VBA
- Drop Down Menu (non Data Validation type)
- $ in front of text in a textbox
- Can a function returning a date return an empty value?
- Comparing data in Excel with VBA
- Run time combobox control in excel
- save clipboard as wmf
- Question about releasing memory
- passing text box stiing into variable
- reading cell contents in a macro
- how to add formula to this macro???
- Please, any help with a problem finding vba code
- Open Another Workbook and Call Macro
- RowSource Problem
- startup macro on condition of filename
- How to add an argument to every cell in a range containing same type formula??
- refrence in vlookup
- Graph As Status Bar
- How to Clear value a listbox!
- saving/creating a directory
- looping through text boxes
- Convert Text to Formula
- How can I do this? Please help
- "minimize" button for userforms
- TextBox
- Run-time error '91' on Cells.Find()
- Unique numbers in a range
- Word.Document - user defined type not defined
- closing excel after 5 mins idle
- Unknown Formula
- Creating and using a config file
- number and text format
- Calculation problem in pivottable
- refresh a cell automaticaly each second ?
- How to write a macro using a user selected filename when reading a textfile
- Finding which Workbook a Range belongs to
- Standard Deviation with a macro tool
- SubTotals method
- Saving hidden data with a worksheet (preferably without using a hidden sheet)
- Working Days
- Changes to UserForm lost
- Data Tracking Template Wizard
- SubTotals Method - TotalList
- re-copy a macro
- date stamp
- variable userform caption
- Using MS Newsgroups
- Copy Sheet w/o VBA code
- show userform, hide sheets
- how to open a folder from a userform
- Select & step
- Error causes Excel to shut down
- How to capture row number
- OpenDatabase-Problem
- Re-assign LinkedCell in VBA
- form
- FORMULA
- move mouse or cursorpos
- Changing a macro to save as Unicode text
- Reading all files in a folder
- Offsetting from the Reference of a Cell, not the cell
- the retun button
- comparing 2 sheets
- Combine 2 macros
- sorting dates by month
- Missing References
- Excel Format documentation
- Macro, autofill formula to end of column
- AsktoUpdateLinks Property
- Macro to re-calcluate and count times run
- Printing code
- key board short cut for validation list pulldown.
- Trying to save as tab delimited
- Hyperlinks to Excel File from Website
- Parse formula
- SHEETS
- Count Down Timer in 1 sec. increments
- Duplicate Object Name Lockup
- Excel VBA - Range value of the Clipboard
- VBA Code works in 2000 not 97
- Brain teaser
- How does the ActiveChart.Location() work
- How to find and sub total a specific number of cell above the target cell
- PivotChart formatting: macro for multiple unique charts
- Checking to see if a Range Object exists?
- Command Button Function - Macro
- why!?
- Duplicating rows and changing cells
- not for the newbies...
- Excel charts on the fly with ASP
- Excel VBA - Error handling problem
- ClearOutLine Method
- vba question.. matching in columns
- Need some help with enclosed script
- InputBox and Password
- VLOOKUP and IF
- copy a sheet
- Save a file with Protected Macro
- unExcelling Excel... well almost...a twist!
- Workbooks.Open(filename) : Returning err: Object reference not... (in VB.NET)
- custom functions
- bloomberg API
- Error 49: Bad .dll Calling Convention
- convert word files to excel file
- Displaying Unique Values in a Combobox
- CommandBarComboBox.AddItem - String Length Limit?
- Import text file without specifying a path macro won't work
- Excel within the body of an email
- Relating Worksheet(I).Name with VBComponent(J).Name
- Visual Basic Code in Excel
- Controls.Add("forms.commandbutton.1")
- Write VBA code into a sheet module using VBA
- Re: counting cells in a column based on thier color
- "Unload" selection after running macro?
- Re: Add a Column Macro
- Message box at file open
- Checking a cell for a specific color in Excel VBA
- Merge two pieces of code into one
- Cut & paste editing problem.
- Auto Sequecing in New Work Sheet
- Pixels values
- Adding commandbutton at run time
- Input Boxes
- Notation on Revision of Projects
- Textbox Enabled but not where you can type in it
- Using the Sum Function in VBA
- More games than work
- Conditional Sum Tool
- SendKeys, Windows Active screen Question..Pls Help!!!
- Change text in legend
- Linking data across worksheets???
- List comparison and update of values
- add rows to data based on situation
- How to open a Word or HTML document using VBA code in Excel
- worksheet change tracking...
- Making combobox listing containing values larger
- Excel close/save/prompt problem
- DataType Conversion
- advanced filtering
- Help with figuring out last date
- templatae wizard
- Find Last Row Hidden
- Excel COM Add-In: Error in MS Code
- Re: Checkbox to hide or show rows
- Help with code for two cell accumulator
- Looping thru columns beyond Z
- Option button task
- Formula between Worksheets and Drop down list
- Error 91 but only when sheet is protected
- Macro file format not valid
- Row/Column Insert/Delete
- Urgent-formating of columns
- Syncing Horizontal ScrollBars of Two Excel ListBoxes
- Refer to a Name saved prior my macro Starts from VBA excel
- Linkedcell Problems...
- Forced Capitals
- Excel Add-in
- MBTimer.OCX file
- question about custom button
- RunTime Error "1004" QueryTable is Invalid
- Howto Show importerd userform
- problem with Subtotals and ClearOutline method
- Combine VLookup and MAX ?
- How to display japanese characters?
- send contents of cell b4 to a plain text file
- Evenet when excel menus are changed
- Remove VBA code
- Visual Fox Pro ODBC msi package fails
- Setting the range in a chart using VB
- Column Width Excel VBA Problem
- copying between office apps ( excel & Word )
- different ver Excel - problem with decimal separator (for experts)
- Modify excel userform controls through vbproject?
- Uninstalling an add-in
- Excel Add In Problem
- Transfering data from one worksheet to another Worksheet
- How to run my macro on Insert->Rows , Edit->Delete
- Open sheet1 always!
- x Axes valus
- Import useerfom, module in .xlt
- protecting sheets from a macro
- Want to Bind ADO Dataset to Excel 2003 Pivottable
- Transmittals & logs
- tmp files - so many tmp files!
- Combobox: Selecting values from a row and place in combi box plus update
- Count Down Timer (Seconds)
- Populate a matrix, How?
- Data Migration
- closing excel after closing a workbook
- combining Two excel data sheets
- Re: VBE code pane
- Checking with code to see if a Workbook is Protected?
- Floating information box in a worksheet
- Importing data from external source
- Re: VBE code pane
- Opening .csv
- Can border formats be locked?
- Bob Phillips
- extracting information from workbook to another
- create TEXT files for EACH row in EACH xls Spreadsheet
- What's wrong with this bit of code
- Re: 4th Repost with no answer, Urgent reply needed!
- Need to merge 1500 files into 1!!!
- worksheets
- hiding menubar & toolbar
- Help finding changes made
- QueryTable Field Name formatting
- starting a msdos exe from excel
- VBA Excel.Application
- checkbox identification
- On Sheet select Macro
- how to send a workbook shortcut as attachement in an e-mail from a userform
- Column Total Needed via Macro
- Importing Data from a Stored Procedure (SQL SErver)
- macro that sumif a specific range
- make new .xls file
- Add Unique item to Collection
- Inserting Picture Excel Sheet
- Re: Use current sheet name in Macro
- Question AND my 1st positive contribution
- Help reading in a text file
- using AND and OR as an if then condition
- AutoFilter question
- how do I: click in cell and make it change color?
- Exporting chartsheets and breaking links
- personal.htm & personal.xls in Macro
- Pivot table....building arguments for the .RowField property
- Getting VBE to recognize a new sheet
- Whcih financial year?
- Solver Bug Fixed?
- EXCEL keeps running in task manager
- vba to add and name worksheets
- Rnd function used in VB on network
- Code to open new workbook
- Loading Excel Array from VB Array Faster
- Formatting SubTotals
- MBTimer.ocx Reference
- File name seach within open filetype
- Re: Running macro at startup
- Requesting file names
- ODBC question
- specifying workbook for Sheet1
- VB Printer Object
- overflow error
- Creating Table from Web-Based Material
- Excel hides below other windows
- Re: Running macro at startup
- Searching in a row with push on a button
- isolate macros
- Re: Running macro at startup
- Loop through workbooks in a folder and return the value of cell M43
- Re: How can I return a Cell reference to a variable.
- Worksheet data linking ???
- Licensing an ActiveX control
- Drop down menus...
- Command Button
- Delete extra rows at the end of macro run
- Re: Delete extra rows at the end of macro run
- Demonstration using XLS files
- Getting output from an excel output back to cscript..
- Loop using cell names
- VBA and Crystal Ball
- RE: Running macro at startup
- Status Bar Every Nth Loop
- Is this "If Statement" Possible?
- Turning Design Mode off in VB code
- How Do I Display a Range of Cells in A Message Box Using VBA?
- Reading PivotCache for Pivot Table
- Trap Right CLick Insert
- How do I: Cycle through selections by clicking on cell
- Transfering VBA Array Column Range to Excel Column Range
- Cell Reference within NamedRange
- Macros terminate early
- Cell content formatting
- Dropdown Macro
- Worksheets - Add / Move between
- insering a row to spreadsheet using VB
- help
- data between sheets
- "file not loaded completely" error
- Option Base and reading from Access
- Pasting a Range to Word
- Creating VB code from VB code (it's incestuous ; - ) )
- macro runs except from function
- Excel Print Page setup macro...
- Masked Edit Control Version 6.0???
- clear object
- Permission Denied: no write occuring [Excel2000]
- Data Form question
- System Root directory
- Macro to find the 6th occurrence and move range
- Excel has encounterewd a problem etc
- serializing excel objects
- Calculating Last day of month
- mkdr
- SAVING A COPY OF WORKBOOK W/O THE CODE IN IT
- Combo Box List
- automatically enter time
- Emailing Web Archive Formatted (non-interactive) Excel files....
- Save as FIXED LENGTH
- Multilanguage issue
- for Ron de Bruin
- can we hide #N/A display because of VLOOKUP
- removed vba code
- what's wrong with my code????
- VBA - Preventing duplicate entries using a macro
- Date in worksheet on opening ...
- Importing data from SQL database - Variables
- Generic Macro
- pivot table - %structure with subtotals
- How to Include exl charts from closed worksheets into PPT slides
- Email an Excel form input using VBA
- Excel-Macro running through SQL update.
- short message after button click
- Search on a part of the cell value
- From 1 sheet to the next?
- Updating multiple cells from a UDF
- VBA Database access
- VBA Database access - How?
- Coyping from Excel to an MS Word Header
- macro to find a text and return a message
- VBA Auto selecting and calculating ranges
- Delete certain rows of data...
- Best way to Update Master Database - via Spreadsheet - sent to sites
- Worksheets - Add / Move between
- Excel VBA Highlighting/selecting an unknown range of cells
- Macro
- I need to select some values in a Listbox????
- Insert path and file name in excel 2000
- Delete row if value in Column X is 0?
- Calling Webservice from Excel
- Incremental filling of cells
- checkbox numbers
- ListBox Scrollbars
- WORKSHEET
- reshape area
- copy data & format to mutiple sheets
- Moving in multi-sheet document
- Setting up a SourceData:= in VB
- File size comparison
- checking for duplicate worksheets
- Getting the Label or Caption of MenuItem Selected
- Email worksheet using VBA Code
- Enter formula in cell
- how to create ado recordsets from rows of data?
- Protect sorting buttons in menubar
- Autoexec Macro
- small excel project
- Serial No. of PC from VBA
- Formatting to Percent using Excel Object Model
- Conditional Sum
- File Copy Macro
- Pivot Table & Time
- Allow access to cell but don't change cells formula
- Stop Excel Updating formulas when cells are deleted?
- dynamic color changing within cells
- Subject line in E-mail
- How do I include a wider range in my code??
- Using Functions from an Excel Addin
- Creating a range
- Creating a VBA form in Excel
- Range Selection shouldn't be this difficult!
- Plase help me clean up my code
- how to refresh entire sheet?
- Re: UDF 2000 compatible?
- Re: UDF 2000 compatible?
- Creating formula range by last name.
- Copying text from a text box into a cell on another sheet
- HARD PROBLEM! Need help stat!
- Automatic spell check
- What is wrong with this code?
- summarizing data from several worksheets
- Active VBE Module ?
- locking information in a cell
- F2 + <enter> without sendkeys?
- FindControl ?!?
- Make A Set Of Date
- Combo Box uses
- Excel Validation Problem in VB6
- How to get the 10 lowest numbers out of 20 in Excel
- Get Value of Equation on Chart
- Add-ins
- Bob Phillips: Program Right Mouse clicks?
- How to Make Multiple List Box Selections Populate A Column in Excel
- Re: What is wrong with this code?
- Determine data type for Pivot Field
- formula help
- Bulletproofing a worksheet
- using AutoFilter object
- Using worksheet codenames
- Problem - Filter based on color?
- EXCEL MACRO DEVELOPMENT
- XL Versions install base
- Msgbox - Puting current date in a message box
- align data in a cell from VB
- Removing links
- Question on custom commandbars
- VLOOKUP - indirect reference to other sheets