- grouping sheets
- Accumulate data in pivottable
- File name
- Objects and Variables
- Left and Right function is not working
- Rescale the Chat using VBA
- check whether worksheet's there or not
- Error message
- Verify that the vbe is active when using sendkeys
- Turning off all the mac ros and code in an Excel Workbook
- urgent. looping thru all records and applynig formula to get new results
- Excel and Progress
- turning off unwanted warnings
- 2 sets of option buttons on one user form?
- Auto Close function in Excel
- Event proceedures
- reformat numbers
- copy named range
- find and replace macro need help
- Differentiate between cell colours
- Making a query from a web page using VBA.
- Adding worksheets
- Random Sample with proportions
- Browsing for a folder name?
- Auto-Click Save on Clipboard
- Entering Query Parameters by UserForm
- Error updating pivot table source data
- How to name a chart for referencing in VBA? And move it.
- group rows in a range based on criteria from another range (vba)
- VBA - graphics
- Phantom spaces/quotation marks when using SaveAs Text
- conditional format limit code
- how to supress clipboard notice?
- problem excel 2000
- How to use macro to rename worksheet with date +"text"
- tab in userform locks program
- #NUM!
- # added to number in function procedure
- referencing worksheet as a variable
- Macro selecting blank rows/columns
- Re: Printing Slow Down On VB Repetitive Use
- Loading images
- asp.net Office Automation - in or out of process
- Help on file and folders Please
- Print Macro - Printing out of Order - 2nd Post
- Call MS Word envelope printing routine?
- Obtain Process ID using .NET and API Calls
- Looking up two entries in a listing.
- Read only
- How to make a button conditional
- Pivot Range Name
- Border VBA
- Userform Question
- Combobox ItemData
- Re: Verify Data Format via VB
- AutoFilter help VBA
- Change cell color if data present excel 2002
- Interrupting a loop
- Find Cell Value and Activate
- red Color for same value cells
- VB6 to VBA conversion. Form vs. UserForm differences. Object variable types
- Wrapping text in VBA Code
- Problems with User-defined Function
- Update filename
- Addd Net Connect Win98 vs W2K
- Querying sheet of unknown name
- Active workbook
- Re: formula to sum LAST five (5) values in column
- Deleting rows based on cell criteria
- Select Range of sheets
- ParamArray
- Sort Sheets Procedure
- Need Help creating multiple graphs through coding
- Syntax error.
- Repaint causes form to flicker
- Rundll32 & user error
- Re: copy-paste error
- lost double click ability to open files
- Help! need some adjustments!
- Re: Loop through open workbooks
- Re: formula to sum LAST five (5) values in column
- Error with For Next
- Buttonless MsgBox?
- Format Event Trigger (XL2002)
- Setting value of a public var from a form
- RE: Error Handling
- Using XMLMaps from VB(A)-Code
- Validation (Drop down list vs simple text length validation)
- Re: Validation (Drop down list vs simple text length validation)
- Re: Validation (Drop down list vs simple text length validation)
- Hide Row Based on cell value
- converting VBA into a com add-in
- Copy each control & rename
- Web Farming
- Naming a range with VBA...
- Copy Sheets
- display a set of data as a calendar
- web query w/login and password
- Clarification: using excel to send data to ethernet device over TCP/IP
- control a network device based on web data
- Which button was pressed?
- Help needed starting a macro
- QueryTables Error
- Macro to insert replicates in database
- If integer is text???
- Filtering or linking Page Fields in an Excel Pivot Table
- Newbie: How to define the font size in the status bar window?
- Is there any method to remove...
- Re: Password protection of an Excel Add-In
- Refer to the cell in which a function is entered.
- Re: Password protection of an Excel Add-In
- saving file as personal.xls
- Re: Password protection of an Excel Add-In
- Trapping and preventing a form from being e-mailed before validation
- New Formular Needed
- Dynamic hyperlink reference
- Problems with date format in userforms
- Range help
- If / True
- Not Enough Memory
- function help
- Macro : seeking max value after an Autofilter
- Setting value of controls to ""
- Last Cell
- Update Chart in Pivottable
- Protecting worksheet
- Multiple simultaneous macros and userforms
- RE: How tp query a spreadsheet table?
- Sending variable data to a web site to be computed then brought back to Excel
- Desktop Shortcut
- Saving data in an add-in
- Printing Multiple Worksheets
- Saving a very tricky code
- open work book to current date
- Changing what is displayed in an image control programatically
- Having trouble importing CSV files with a macro
- Average of 2nd/3rd/4th/5th/6th last cells
- Conditional macro execution
- Cell Formulas vs. VBA
- pls help
- Validations - Building a list of
- Run time error 28: Out of stack space
- VBA Copy & Paste_Pt II
- Indirect not the correct solution???
- Save .csv with overwrite
- Code suddenly won't run on XL2002
- Protect cells
- Formula Assigned To Variable
- Commands at the line prompt using Shell
- Excel VBA - Solver conflict?
- Pulling Array from InputBox
- Complete a "helpsheet" code
- Need help with the Like Operator
- Re: Parameter Dialog Box
- Multiple Selection from COMBOX or ListBox
- Set smallest cell in row,col as BOLD
- Can't add a reference to specified file
- vba or formula help?
- PasteSpecial Error
- using code from an addin
- AutoFilter & UserForm
- UserForm Wont Load
- Manual Input During Macro Execution
- AutoFilter Values + DropDown Boxes VBA
- Pivot Table Grouping
- Pivot Table Grouping
- Detect macro's parent workbook or worksheet
- QueryTables Object Variable or With Block Variable Not Set
- "><" formula needed
- Copying spreadsheet out of excel with formulas (pressing)
- Min function
- Retry - Find and Replace Macro
- Problem with populating textboxes in relation to drop down list
- ColorIndex
- Exporting Graph
- Referencing a fixed cell in VBA using an IF statement
- Offset from new name based on what's checked in Userform
- automate 2500 cut/paste/format from internet to EXCEL worksheet
- Hide all images on userform
- Create a "helpsheet"
- Excel to Access question
- Problem with a defined variable
- Need new approach on forms I set up
- Help with perplexing form problem
- Code to halt a macro
- macro terminates with no error
- Capturing Print and Print Preview events
- Re: Userform Question
- UserForm | Incorporate a calendar
- Left Side of Excel Screen Turns Gray
- Finding Matching Pivot Datafield
- Increasing a range in a loop
- Finding cells and values
- Re: populating a multi-column Listbox
- Re: populating a multi-column Listbox
- Problem with Autofill Macro
- Re: Concatenate
- IF Statement
- Deleting multiple rows within a spreadsheet
- Tidy up data
- Extracting duplicate data from two lists
- Re: Concatenate
- Re: Concatenate
- TCP/IP
- Read Range Data into Array
- Simple Question
- ListBox Multiple Selection
- Wheres the bug
- Wheres the bug
- VBA Copy & Paste
- Undo with custom Paste function
- vba function
- vba function
- calling a function
- vba function
- What Is "Me.Worksheets(..."
- vba function
- Lookups in arrays
- Populate list or text box
- Workbook Formatting
- Listbox Index Problem
- storing an equation in a macro
- SheetSelectionChange
- lat long conversion
- Return MS Word word counts in Excel?
- Navigation Buttons
- run out of memort
- DIm Variables
- How to show a userform using excel macro in multipage
- an off topic question
- array of rows
- Text too long
- Desperate for help with VBA List Box
- Passwordchar Example
- Price look-up
- Multiline edit list box
- Items in a Listbox
- Temperature dependant variables - can excel do it?
- update access mdb ...
- Defining a Range
- How to avoid clearing undo stack after macro?
- is there a maximum size of parameter for a (Fortran)DLL call from VBA
- How to open a zip file from the code?
- Selecting rows in a spreadsheet
- Ranking 'off sheet'
- Concatenated Formula
- REPOST:Need help moving XL2K to XLXP, please
- Refresh
- processing message
- Comparing Spreadsheets to find information
- click event for changing cell color
- select X first/last columns of a pivot table with VBA
- Delete Sheets
- Copy before hidden sheet
- Halting the Worksheet_Change event
- Using Variable in RANGE
- Using Variable in RANGE
- Problems that in excel2000 arent BUT in excel2002 (XP) are!!
- Turning off Active-X properties
- current row - VBA
- Any Visual Basic Users Having Mouse Scrolling Problems?
- pdf to excel?
- References to ADO library for ACCESS connection
- Finding the Last Day in the month
- need formula to set value based on a date
- Getting Excel to update Outlook Calendar
- Macros
- unable to open excel file
- Why system asks me to save change even after I call save method(VB.NET)
- How to get last row used in sheet DATA
- deleting last 4 characters from file name
- Signed workbook depends on physical location of AddIn - Digital Signature Invalid - workaround?
- Validation lost on advanced filter copy
- Data Validation Criteria
- Macro to copy down specific number of rows
- array formula in Name Definition.
- Shared Addins
- AcitveX only runs with admin rights
- copying all formulas, except sum
- copy protection
- xls file size / memory errors
- Search a column for the last five cells?
- Saving with date in filename
- How to plot chart in VB program
- How to restrict the excel sheet containing Chart
- Copying Cell Using Macro
- UDF tooltip
- How to replace a macro with an addin??
- Undo change
- HTML HREF Opening in Browser
- Help with Workbook_Open
- Help with vba coding/userform....
- How to lookup hyperlinked cells
- Using Macro & offset to put in formulas
- making a userform work ,oops
- Copying across VBE
- RE: Searching zip codes
- macro connect to Sage DSN
- Automation Code Problem from Access to Excel
- Re: how do you have one cell alter another cell
- Simple Macro
- Sort Orientation
- Adding up values of textbox in Userform
- Macro to save worksheet
- Control Toolbox grayed out in Excel Spreadsheet
- Date Change
- Thanks
- Importing Text File
- Selection and Areas
- Activate Chart
- Printout Code Problem
- I need some help here
- where is the workbook_open event handler???
- Tab go into the editing text box not next object
- Reading a tab separated file to excel ActiveX spreadsheet (C#)
- multipage question
- userform
- Userform to spreadsheet
- verify open windows
- Excel macro problem cursor down
- Tab-key
- ([([([ Page Breaks Problem ])])])
- Variables not showing value
- Running a macro every half hour
- How Do I Expand A Set Range In The Match Command
- Auto Duplicating Worksheets and Insterting Data from Different Worksheet
- Macro to hide rows containing no data
- external reference
- Excel Version
- Golf Statkeeper
- Excel 2003
- Setting References in VBA
- Test
- Excel 2003
- Does CoGetInstanceFromFile work with worksheets?
- Opening A File From Excel VBA
- Executing a Macro From a Desktop Icon
- format a listbox
- Column
- Relative Macro Assignment
- userform macro button problemo
- Excel 2003
- Looping Text
- i have a really long problem,
- delete items from a column
- Problem with Office Developer XP in Excel 2003
- run time error
- preventing closure of active excel window
- Licence help wanted
- username
- hiding rows
- Excel VBA Beginners problem
- makes a new list
- Summation of cells tied to Checkboxes
- counting formatted cells in vba
- Excel end user reports and preventing changes to users excel settings?
- Protection options through VBA
- FTP FILE TRANSFER PROTOCOL FROM VBA?
- Functions
- **HELP** Can This Be Done
- Copy/Paste based on cell content.
- stillcheckbox remains a pain Frank
- Getting Windows user (Account) from a VBA routine
- Calling Access Program from Excel
- Formula to return Friday's date: m/d/yyyy
- Excel 97 vs. Excel 2003
- Excel 97 vs. Excel 2003
- userform data to spreadsheet
- vlookup, with more than 1 result
- Match & Indirect
- Clarification please...
- vba code to reboot
- Help: Profit margin
- Automatically Assigning a Macro to a button
- Automatically Assigning a Macro to a button
- vba weird messages - "catastrophic failure"
- Open Event Code Bug
- Last cell
- INSTERING A ROW
- Macro command to open a file
- Variable with value before being assigned?
- Overflow when translating from C++ HELP!!
- Hide the DisplayPasteOptions
- Order in which add-ins load
- On error
- Can this procedure be made more efficient?
- Password protect data entry to cell
- Resizing a Range
- Ranges using offset
- Re: code doesnt work
- Opening new workbook
- UserForm Problemo
- Creating Macro's
- macro to email excel files
- Msg boxes
- Can a graph use array data instead of ranges?
- Help
- Re: code doesnt work
- opened workbook (not resolved question)
- Pass Variables to Subs/Functions confusion
- changing a Word doc to Excel
- Formulas for...1. Counting unique cells 2. Display unique contents
- Re: code doesnt work
- Ignoring cells with no value
- Re: Clearing the contents of merged cells
- Copy Sheet
- RUN Time error 9
- GOTO another sheet
- User Form
- Print header change
- Excel VBA - Storing text in a variable, and "'Cells' of object _Global failed"
- excel VBA: input boxes
- Re: unable to hide the "ask a question box"
- macro
- Macro to search, compare, copy and delete
- Seperating Letters from words using character
- re:enter button in vb
- Change a positive value to a negative value
- How do I get a reference to a control on a sheet?
- Userform inside another userform
- Pivot Table Names
- If criteria not met then message box
- User form keeps getting smaller...what the ???
- Printing Marcos
- Attaching a similar forms to many templates
- Re: Spin Button...
- Exporting Data Question
- Converting numbers to column letters
- data validation
- Excel - get address of cell
- Count days
- Need help with Macro
- Populate Column Header on ComboBox
- Custom paste macro
- Using vb to launch a shortcut
- HELP! XL2K to XP -what reference am I missing?
- Pad with leading zeros?
- recalculating advanced filter?
- Copying to another Workbook
- Re: Getting "compile error" "method or data member not found" on reinstall
- Worksheet Password Protection in VBA
- Mode Function
- VARIABLE SUBSTITUTION
- Name not recognised
- Date macro
- Aligning lists
- Copy and Paste hidden cells?
- inserting latest picture file
- Will Excel create a checkbox?
- File Conversion
- ActiveSheet.Printout or Page Setup?
- My problems with simple addition ...
- don't bother
- blank cells
- How tp query a spreadsheet table?
- Formatting part of Cell
- Exiting a VBA Macro by user intervention
- Re: Change from 2K to XP - global macro location chnge?
- error on oXL.Workbooks.Open
- Excel VBA event trigger problem
- if function prob
- enter value, calculate, in same cell
- Re: Change from 2K to XP and Excel.xlb toolbars
- UserForms and Variables and Types of data
- Copy before sheet
- calculate the average of a column then move it to excel
- VBA to number worksheets?
- Re: When saving add automatically contents of a specified cell in document properties
- Can an advanced filter do this...??
- How does msgbox stop the OnTime event?
- Problem with SendKeys + active window
- Delete Multiple Worksheets
- Active Directory
- Add library in vba
- Complex Match problem
- Excel filename into cell
- Maximum length of a line?
- extracting part of string value
- Refresh Browser with vba
- wraptext is not updating when using references to another cell
- Variable scope
- Thanks, This works perfectly
- Help with e-mail macro
- Excel VBA - Last Author properties
- Loop code problems
- Re: ssfHistory & ShellSpecialFolderConstants
- Excel in batch mode
- Sheet Name not accepts special characters
- Code for Case & Number format
- automatic text insertion in preformated spread sheets
- VBA question about Variables
- Hide zero column in Pivotreport
- A good book on using Powerpoint VBA to drive macros in Excel ?
- Excel Web Query
- Printing
- Printing
- openning spreadsheet
- Using the result of autofilter and performing tasks on each value
- Hiding sheets with macro disabled - with a big twist!
- for next with web query
- How To Copy Sum of Cell Values vs A Single Cell Value
- Non contiguous to contiguous
- How to disable Visual Basic Editor in Excel file
- Create a separator line using conditional formatting
- While reading excel file i am getting null values
- Macros to run in any workbook
- Highlighting only cells with data in them
- Highlighting only cells with data in them
- Pie charts in Macros
- Looping though *.xls files except for the main consolidation file
- Re: xlDialogActivate to Select Sheets?
- New to VBA from VB6
- How to disable Ctrl+Break
- Select Cells with VBA
- Powerpoint and Excel
- Intelimouse scroll wheel
- Control Box Option Buttons
- textbox options
- No debug box
- protect print_area?
- First empty row after last used row
- code to terminate access after certain time
- telling Excel to go down relatively
- Command Button
- LegendKey modification Error
- Changing backcolor of commandbutton
- Help with Menus
- Problem with setting Pivot Table data orientation
- How to make the "Save As" prompt appear with vba?
- Formula to search cell to see if it Contains a value.
- Programatically saving XML file as Excel spreadsheet
- Auto-Formatting in Excel: changing values
- Print Area when subtotals are on.
- Save at start of month
- User form
- Search Using Autofilter - Field
- else if code
- ADO SQL - Using text functions in Select statement
- Virus Warning
- Easy one (I hope) Using Sheet Names to reference sheets in other Workbooks
- Conditional formatting & interior color
- Circular Reference Conundrum
- excel vba - spreadsheet code "apply to all" problems
- Pastespecial and cut
- Column Sort (VBA)
- Re: Active Cell
- Recall a variable referring to a worksheet name?
- Re: Active Cell
- Need program to ask me to save changes when closing
- Make "BeforeSave" event supply a default path and file name?
- Slow Macro on Page Margin Change for all sheets
- Solver
- Excel column widths change on different machines
- Finding Max Within 3 Columns
- Print Macro - Printing out of order
- If Range("C1") is in MyArray
- Custom Worksheet Function not updating
- dynamic subtotal %
- Add-in conflicts
- Control Properties Not In View
- Lock down a new instance of Excel App
- how do I create a checkbox?
- Does anyone know why this won't work?
- Using an Excel "object" with my VB DLL
- Problem- Recording macros for "file save" and "File open"
- MyBar doesn't run automatically
- Creating a action for a defined object
- Email distribution list
- Not found objects
- macro function is too slow!
- a round of applause to frank kabel
- Date Validation
- oh, and another thing
- Strange PrintOut Behavior
- Thanks!
- save conunderum
- Copy cells from other workbooks
- For Next & Hidden Sheets Issue
- remove reference via code
- 2D array lookups
- Find loop
- does textbox contain a number
- PRinting two many repeated lines
- Accessing selected cell from modal dialog
- lock customize bar
- Search form
- I want to protect a cell but allow formula values only
- Late Binding
- Using Add Method of QueryTables gives error
- Special Action on E-Mail Error Condition
- Try again: VBA to automatically install ODBC data source
- Obtain a Process ID
- Using For Next to reset Pge Brk Preview on all sheets
- hide a page on a multipage control
- Make an unsaved file copy in memory?
- User defined Spreasheet Functions - How to add "help/ assistance comments"
- CSV to TXT: how to
- While reading excel file i am getting null values
- VBA References - when is Office Object Library Reference set? Best practice re. Early/Late binding ...
- Return to Original File
- Restrict Population to MS Query by Cell Ref.
- BIFF8 Sample
- Object Variable or With Block Variable Not Set
- Getting sheet name
- Remove Close button
- How to check output folder has been created in the network path?using VBA programming
- Trying to run MS Excel 2000 macros on MS Excel 2002
- Loc and LOF functions
- error in sorting
- Cells.find restricted to a single range??
- Compare two ranges and display equals in list
- "Excel - Get Date"
- Clear Contents Of A Text Box In User Form
- Hide and printout area conditions
- Combox box question
- opening diff. worksheets in opened workbook
- getting external data
- select distinct row
- finding empty rows and deleting
- divide and conquer --- help!
- find next blank cell
- Suppressing Enable Macros QUestion
- Saving time
- Add sheet and rename with cell contents
- Userform w/ Multiple listboxes that link
- Vertical Entries for VBA.Array
- Can VBA log into SAMBA
- Copying data from different sheets
- Anybody want a job?
- Sort of Data
- Excel compile
- weird problem with PivotFields CurrentPage
- Conctenate
- Outlook from Excel
- Re-post of existing problem
- Compile Error: Procedure too long
- Finding first (end of range) empty cell
- Digital signature on workbook/addin invalid when files moved?
- HyperLink Windows
- Lookup and Select Row
- Referencing an Older Version of the Excel Library for Development
- Mouse drivers that work with VBA & horiz scrolling?
- sending a cell to a textbox?
- Copy Selection to new sheet
- if macro
- Referring to Microsoft Excel array in VBA
- change password
- Editing text within a cell
- Simulating a synchronous process
- Range selection not working
- need form to initialize without closing
- Find Help
- sortingproblem
- Copying unlimited range of data and closing the file
- Problems with Excel 2000 from 2002
- adding text for a specific range
- Time to learn to find the right folder *sigh*
- Capture scrolling event
- Delete Rows
- User Form/Input box problem
- Visual Basic
- Fill a ListBox with items using VBA
- Count Cells with text a specif color
- moving automatic vertical pagebreak
- Re: Help with VBA
- Cell size format
- recursion depth, 'Out of stack space' in Quicksort
- Message Box Question
- GetOpenFilename - How can you filter files starting with a letter...
- Excel filter range
- VBA - closing without saving changes
- Find and Replace HELP!
- Pivot Table PageField
- Get the GAL in excel
- Field in Access
- Mileage Chart (I'm a beginner)
- Download data from website
- Read a current footer value
- Using a "File-Open"-Window in a Excel Macro?
- Linking files together
- Creating and closing CSV file
- movable formula
- clinka32.dll
- make the parameters show up when you create your own functions
- Make toolbar buttons appear only in specific files?
- How play a wav file
- Finding unique sets of numbers that total 200
- Problems with Personal.xls
- find and insert missing values
- Shortcut Ket after the fact
- Argh...layering object problem in userform
- access sheets in another workbook
- Macros
- the "Procedure too large" error
- Not Enough Memory!
- Notification when Filter is selected
- Workbook Open event
- sub to create a sub
- Combobox Item Number
- Link Combo Box to Autofilter argument
- excel vba array problem
- Excel VBA-Personal Budget: Identifying text in a column...
- Beginner question (I hope)
- Excel2002 autoformats dates,
- Help please- user selectable image
- Excel VBA - Setting Print Area in VB
- subtracting ranges?
- Formulae In User Forms
- Save file, refer filename to cell and change directory
- Last Time Updated in Footer
- Status of sheets in a workbook
- Select rows after finding last cell
- Annual Percentage Rate & ARM
- How to Format a ListBox column
- monitor small/large font code
- Start excel from DOS?
- Restricting access to OLAP cube data
- Prorating calculations in Excel
- identifying which cell calls my VBA function.
- Excel AddIns VBA Locking v Unviewable
- Excel VBA Locking / Unviewable
- WorkbookOpen code not executing properly
- Re: Vision Objects as Controls?
- Re: sumif not working if using different rows
- RE: AddItem Method - Combobox value
- Using Outlook Object Libraries V8 & 9
- Concatenate a strings range.
- Certifying Macros in a Domain
- Printing
- Creating Custom Toolbars
- Inactivate message boxes
- Recognise value not formula
- AddItem Method
- Re: Tom Ogilvy
- Formulas not updating when add new inputs
- Re: Tom Ogilvy
- Save As
- Save As
- problem with buttons
- Streamline macro code.
- How can you determine if a cell is formatted as a percent?
- Changing Pivot Table Fields Programmatically
- Blank grey toolbar after code !
- Solver constraints not added
- Available serial numbers...
- Sheet construction on server security issue
- Prompt for new folder
- Formula for finding text
- import of txt list to Excel
- Help please, what Function?