- creating dynamic controls
- Personal.xls -- What is it all about?
- Get the name of the ActualScenario
- Form_activate event appears confused
- Chart Export - Crop Whitespace
- Resetting multiple cells?
- #NAME?
- Help with Outlook & a movie list
- Prevent Cell Format being copied by copy command
- VBA - How to make the text box initially show the first part of the text?
- Question about SHeet
- Properties of QueryTable Object
- Custom Header date value as date
- Putting Array Formula into each Cell in a Selection (that doesn't take eons!)
- which function use?
- userform buttons problem
- Instead of 'Worksheet_Change' is something else??
- 255 characters problem
- Cell tab order
- NEED IMMEDIATE HELP! Open XML File in Excel Sheet?
- Spanish version runtime error
- macro to copy and paste data from multiple sheets
- Connecting to Access using macro
- Help with copy/paste based on criteria
- SQL.REQUEST in Excel 2003?
- table totxt
- ClassName or WindowName
- EDate function?
- Saving a File as read only with no prompts to save
- Another table to txt Q
- Prompting to save changes
- Run Time Error 1004, Unable to set visible property in Pivotitem Class
- Help in using Application.Version
- Row counter, copy master records
- Troubles doing Data Retrieval from SQL
- save worksheet with custom format
- cell formatting
- Catching an Open Excel File with VBScript
- Best package to make COM add-in
- Deleting blanks from the end of values in cells
- Mega formula
- VBA reference to external workbook not working - HELP!
- Change Rows/Columns in range???
- Assigning array to range inside Excel Object
- Application.Volatile messing up other function
- removing a menu item on closing
- Able to catch Application.Quit similar?
- Excel VBA- copy every 9th cell to 'sheet2'
- Copy contents of cells down
- Cells.Find
- remove dates only ...
- New Sheet Name
- IF FUNCTION
- Excel Type Code
- creation of a macro in a master data collection workbook.
- Putting formula in cell based on find
- Re: conditional formatting formulas in (color)
- OS upgrade to XP from Win98 Excel Macro 97
- need help - how to highlight row when nothing in cell
- Re: conditional formatting formulas in (color)
- Specify SaveAs Programmatically
- Re: conditional formatting formulas in (color)
- Cannot trace this simple error
- Pull Data From an Add-in to a Workbook
- Adding hundreds of hour of time
- Memory problem
- resetting controlsource cells
- Input box question -
- Sub-Totalling and Adjusting SUM formulae
- Excel 4.0 macros
- Storing an image within a cell using VBA
- Manipulating 150+ checkboxes with a macro in Excel 2000
- Kill statement error message?
- Re: Problem - command button not working
- saving web info
- Re: FIND statement when the item doesn't exist?
- How to suppress messages?
- Re: Group Box with Option Buttons
- Custom Menu Bars Not Saving
- Custom Menu
- Re: FIND statement when the item doesn't exist?
- Open Access From A Macro
- Automatic File Name based on cell content
- runtime error '1004' delete Method of Range Class Failed
- Add Lines And Recalculate
- Re: Syntax to access a button's properties?
- userforms
- Excel automatically creates a shortcut on the root of c:\
- Use these critical package from MS
- Re: Syntax to access a button's properties?
- visual basic editor lockup
- How do i get newly created mail to open on top of desktop.
- error: sub or function not defined
- Workbook size
- Re: .copy after
- Re: .copy after
- Re: .copy after
- getting data from closed workbook
- + and - signs above the column letters
- Workbook_BeforeClose doesn't work from add-in
- Dates in excel
- Pivot Table Question # 2
- changing conditional formatting to value
- Excel VBA - Printarea Selected Cells
- How to show only one part of rowlevel 3???
- Pull down menu
- formating current row to center text
- Paste to variable number of rows
- Preserving text formats with Concatenate function
- Last used cell
- Menu editor
- Trying to save contents of cell as the file name
- Gettting a reference to open excel file
- SaveCopyAs does not work
- Add name by vba based on cell content
- AutoFiltering by combobox selection
- Last Row and Column
- What is in a file name?
- Excel - To test for a Blank Sheet
- Excel VBA- Trend Function in Macro Problem
- Refedit...please suggest
- Creating add-ins
- Question about pictures in excel
- complicated question for copying ranges to new sheets
- Selecting a directory from a form in excel
- Why won't this code works
- how ti find a particular is available
- Access a internet Web Site uisng a macro done with excel
- Excel97 vs Excel2000
- Could someone help me with some coding
- Inventory
- Stopping Excel after running visual basic in Access
- Memory problem
- Quarterly Log ? How to
- Office Web Component-Data Transfer
- Filter, sort, filter and then display
- Excel / Word 2002 LOCKED
- IDE is greyed out
- For Each, Next
- MoveDown
- VBA Autofilter error in '97, not 2000
- Multiple Modules, or one big one?
- activecell color
- April Fools
- permission after migrate to off.XP
- opening a word document from excel
- For Next bug ????
- Re: communication
- Excel VBA - msgbox of excel regarding Update
- How can I detect if user is in Group Mode when a macro starts?
- Excel VBA - InsertPicture
- opening a word document from excel: file still won't load
- Initialising a variable
- Resizing BackgroundPicture Gifs programmatically for varying screen resolutions
- Create a help file
- Normal Distribution
- Excel VBA - Help looping through all but 2 workbooks
- group/frames
- Calculation Problem
- Screen resolution
- Countng the number of non blank fields in a table
- Excel - Double Negatives (Past, Present and Future)
- With active cell
- Pivot Table Resizing
- Simple Question, need quick answer please
- Tab Coloring
- Selecting Data in Column
- change name
- Repost: cut/paste excel cells w/ ActiveX checkboxes to Word
- VBA Reference to Custom tlb
- Run-time Error in "SENDUSING" configuation value is invalid
- If Problem
- Number Format
- Place code in a new workbook with a macro.
- Color Change Through DV
- Excel Menus that fold out
- My syntax not working with Auto Open procedure
- Finding Blanks in list
- Finding Blanks in list
- Hi-light area based on name found in column A
- Re: VBA Excel - Load Data button
- Re: VBA Excel - Load Data button
- Formula logic explaination
- Excel Driver Error: Cannot Expand Named Range
- newbie trying to workout copy
- Cannot Lock Text Boxes-Excel 2002
- changing bg color
- Macro to protect and unprotect
- VBA programmer feedback
- Hyperlinks
- Maximize Userform
- Dsiplay Printer dialog
- compile error: else without if
- SpecialCells and UsedRange
- Where is a macro shortcut key stored in a module?
- Cannot make macro relative
- refreshing VB function after changing value
- Re: Listbox Display
- Custom menu's
- Add code to Private Sub ComboBox1_Change() with a macro from a different workbook
- Re: Listbox Display
- Re: VB CODE RUN ON DDE VALUE CHANGE
- Re: VB CODE RUN ON DDE VALUE CHANGE
- dblclick event
- Maximun IF statements in a cell
- Auto fill down
- Rounding Nearest Dollar
- calling subs, Doesn't seem to run fisrt time?
- VBA Code Example
- REPOST for Tom (or anyone else that can help)
- vb-Copy two cells, and paste into another worsksheet
- Autofill
- Excel macro & multiple users
- Consolidating worksheets
- Microsoft Office XP PIA's
- Library Reference files
- Problems Using MS Oracle ODBC with Excel
- Help on comparing two data on two worksheet
- Excel VBA macro - need to edit code to skip a year
- Constants & Declarations for National Language Support
- Copyfromrecordset failed after install of Office XP SP3
- how do count all record in one column
- Userform and scroll bars
- Insert Rows Macro
- pivot table grid formatting problem after refresh
- excel simple prob w/running subtotals
- Sorting columns left to right leave a intact
- Need to know the Sort Column Keys
- Save to FTP
- Selecting File
- Limit to 50 char only
- Dir Path
- Having problems with adding input from combobox
- selecting random records
- Dir Path Code Problem
- Excel cannot 'FIND' data imported from oracle
- Totals and Sorting
- Detect what version (if any) of Excel is installed
- newbie with userform questions
- Fill down VLOOKUP
- Insert data returned from Procedure at 46th Row
- Trouble making a report of all Files within a Folder and all Subfolders?
- having problem with resize
- Newbie Question .. what's this
- Uncheck Forms Check box via code
- For...Each Loop Problem
- Is there a way I can change the shortcut key without having to redo the macro?
- Sorting data in sheets
- Mixing date formats in VBA
- Unwanted excel message
- Macro Secrity Problem!
- Insert Filepath into Cell
- Entering numeric values
- Command Button
- Creating organizational charts using VBA code?
- getting data from access to exel
- Subtotal Format with Macro
- Input Form on Worksheet 1, Data on Worksheet 2
- Can't Set DisplayAlerts to False
- Selecting cells in Excel
- On Screen Loop Counter
- Excel VBA - forms
- office automation Word-Excel
- worksheet
- Problem With Auto Open
- macro using excel solver
- Excel-Opening Word
- Help with 1 x 2 array output
- excel solver macro
- RE: communication
- Changing graph
- Re: Saving on the server
- Sub vs Function
- Convert Excel Functions to VBA Macro Function
- Deleting Rows
- Using IF, Then with rowsource?
- Visual Basic/ Macro date formatting in Excel 97
- VBA - Macro backward compatibility from excel 2002 to excel 2000
- Excel Driver Error: Cannot expand named range
- ActiveSheet woes
- SQL query in Excel 2000 using VBA
- Error Handling Routine
- 2 questions related to Excel under Windows 98/2000
- Open a password protected excel workbook from second workbook to fetch data using dynamic connection
- Execl 2003 XML Question
- trying to search 4 text in a word doc & print page?
- Option Compare Text
- Drop down box problem
- Flling an array
- Auto Open Not Functioning
- Delete row from ListBox with RowSource enabled
- Protect except chng colmn width
- Prompt to copy formulas
- VB Project Documentation
- Re: Format when linking cells
- Timer for auto shut down
- Transposing Data
- Excel 2000 VBA problem -- sorting values in subtotaled column
- Which is more efficient?
- Excel Formattings
- master sheet
- Error in code to Check Forms Checkbox
- Excel library reference files
- Exception Report
- Template Path???
- Character limit for DAO queries?
- Better way to test for empty Recordset
- COMPUTERWEBDOCTORS.COM FOR ALL YOUR PROGRAMMING HOMEWORK NEEDS
- workbook change
- missing command buttons
- Printing Range
- IF then write new worksheet/book
- sending e-mails from excel without 'send'
- autorun code when opening sheet (not workbook)
- Not using send button on excel e-mail
- VBA code only working up to 9999 rows
- Controls & their properties etc
- Open file Dialog box in Macro
- within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?"
- after each print, copy data from sheet 1 to sheet 2
- Copying sheet to its own wb
- Range object
- Copying multiple worksheets into a new workbook
- Macro to move between sheets
- select records using VBA
- Copying cell contents to add to existing contents in another cell
- Re: linked cells loop?
- Re: linked cells loop?
- Is it possible to move a Digital Certificate to another PC?
- EXCEL VBA non-volatile INDIRECT
- Re: Name list in the workbook
- Where is the protection in VBA???
- Hyperlinks in drop-down list
- Running .BAT file from within a macro...
- Excel VBA -Force users to populate custom form cells
- User Form
- AutoFilter
- Formula
- Sending "Enter" command to cmd.exe app...
- User-def shortcut to macro
- Web Query Logins and Access Refresh
- Substr Copy
- Macros Running Slow in a Shared workbook
- Sort/Filter by Color
- Workbook_Open() Error
- Error when using macro to write formula to cell
- Ctrl and Alt keys
- Need Class Collection advice
- Assign Macro function not working
- Application.EnableEvents
- Can I do this?
- AutoFilter method of Range Class Failed
- ADD & UPDATE
- Send a task from an excel file
- Copy method of Worksheet class failed?
- Skip empty and text cells
- Format bases on IF Statement
- Compare & create list of uniques across books/sheets
- decimal places
- help automating the Replace function in Excel
- XMLHTTP proxy settings.
- Trying to sum a range and drop the lowest 2 scores
- Changing Text Color After Change
- Copy titles from another workbook
- SaveCopyAs losing security settings
- Steps from Macro recorder for Pivot table will not run as a Macro
- Open Hidden Worksheet
- Re: changing an palette index value programmatically in Excel
- Re: Chip Pearson Import/Export Macros
- [question] about consolidations...
- Makin a Filter...
- Function, User Defined
- Closing forms
- Excel 2000 Slow Loops
- Newbie - populate (macro) GUI from Excel cells
- Comparing two sets of data
- I invented way cool analysis tool in excel
- Named Ranges - Macro Problems
- Signature Will Be Discarded
- Web Query
- How to detect current active sheet number
- Excel VBA-hide row worksheet event
- Workbook add, reqest name
- scrollbar on userform
- letter
- Scanning barcodes in a dialog box to check duplicates
- Price Pointing/Complex Rounding
- In Event printer fails
- VB OLE embeded excel document cannot be saved -err 1004
- Trying to improving existing code (portion of)
- Naming convention for a variable "Book1" while copying sheets
- Help - trying to make installation file
- Formula, not results showing
- Auto Choosing Pages to Copy
- Excel - Copy range of cells based on Combobox Selection
- VBA code
- Last Row of Data
- Batch Excel worksheet formatting
- VBA and data validation?
- Why is delimit failing me _now_???
- excel 2000 macro on excel 2003... help!
- Changing the order in dropdown boxes?
- Code for SUM with duel criteria
- Sorting
- Adding a Confirmation Step to Macro
- Data validation with VBA
- Screen resolution kernel call
- Copying Excel files and Macro problems
- combine two ranges
- Referencing other worksheet data using a drop-down list
- Filters & Sum
- listobject ... Excel2003
- Need to add mutliple columns to a List Box
- Page Setup Problem
- UserForm: Jump to the next visible cell
- VBA code
- Help with copying and pasting from user input
- Button to format selected text as subscript
- How to see all variables?
- Dynamically adding data to a Combobox?
- Random Function
- Form start position
- problem with excel refreshing Via macro
- how to find row with a given value in a column
- How do I create a cell whose value can only go up, not down?
- Newbie - How to close GUI but not Excel
- Delete a custom button by holding down the ALT key and dragging the button off the toolbar
- 2 Textbox questions
- Mail Merge with Excel?
- Who's my caller info?
- Forcing users
- Working Around Excel Row Limit
- formulas including ; character
- Advanced Filter & Named Range
- Please help me Parse this
- Filling Userform in Word with Excel cell value.
- Is ther a way to change the interior.colorindex of multiple rows
- Move a file without opening it.
- R1C1 Education
- Listbox memory problem
- if ... or ... then ?
- Time Sheets
- Attaching Command Bars to Add-IN
- MIssing References
- Order column in pivot table.
- Write data to a cell, then make it undeletable/selectable
- Timer
- Re: Checkboxes and Other
- ActiveCell.Formula Syntax
- Use VBA to access Printer Properties (Resolution, Tray etc)
- Re: Inserting a Row With Macro - Help
- Protecting only one cell
- Recording a macro with relative reference
- Re: Displaying embedded chart on userform
- Calculations on Cell Values in VBA
- list box- list all files ina directory
- Populate multiple comboboxes with same lists
- adding attachement to e-mail from Excel
- Selecting all contents on page (range)
- Deleting some cells in a row using command button and offset
- FileExist doesn't work
- Populate multiple comboboxes with same lists
- COM Add-ins and Keyboard Hooks/Child Windows
- Userform
- Autocomplete DropDown List
- Userform data
- Find and replace within VBA
- Excel VBA - Excel 4 Macro problem
- How mk code applicable to any active workbook?
- Excel VBA - Copy Folder problem
- Problem using Excel Xp Workbook on Excel 97
- If its a subtotal Row?
- Re: query (hiding the excel worksheet presently selected with the help of vb code)
- Offset Prob
- OverWritten excel file
- Error Problem
- Find selection
- Running Total on Userform
- C# and Pivot Tables
- combobox cases
- how do I create dependent lists?
- Running Solver Add-In through VB ?
- Overview of VBA objects etc...
- Timeout for OLE actions in Excel 2003
- There must be an eaiser way
- Format function doesn't recognise [hh]:mm
- data imported into EXCEL as text displayed as exponential number
- Calling a macro from an If statement
- about OLE automation
- Rename sheet if exists
- Problem using imagebox with wmf files
- Question about what the Find function returns if the item wasn't found
- Enter european date
- Finding text within a cell
- forms in xla
- Ascending Order
- ActiveSheet.QueryTables.Add using a File DSN
- Find All and then Copy the Data...
- personal numberformat
- Before print increment counter
- Workbook_open Event
- Is it possible to load XML/SSML string into workbook without using temporary file?
- Script Help?
- Excel VBA - Complicate Problem
- Listboxes
- Prevent user to drag and drop
- Using ShadeAlternate Subroutines as Macro
- how to detect paste
- Scheduled Task
- When I moved data from one workbook to another...
- REPOST: Looking for how to use DTPicker
- Using XP Events with Excel 2000 Users
- Please help with PasteSpecial programming
- runtime error 91 in Personal.xls - no clue!
- Renaming sheets
- Enter time
- Copy Method of Worksheet Class Failed
- Somebody hit me with a bigger hammer... I forgot how to..
- Comparing Data
- Unique Entries
- Data Input Box to Cell
- Using Application Events
- Abnormal "IF" request
- Event to fire when pivottable is pivoted
- Renaming VBA Modules
- Find value loop not working
- Re: Attach custom list to a cell
- Retrieving FoxPro Data using Query
- Copy Method of Worksheet Class Failed
- Complex Text Strings|Variables
- Re: Paste text over merged cells
- I need the number of a row that meets my criteria
- Copy Method of Worksheet Class Failed
- Query sheet to activate
- Copy Method of Worksheet Class Failed
- help with worksheet functions
- Add fields to pivot table
- moving ranges thru workbook
- searching a string with a partial string
- Msgbox
- Searching a String
- Soccer Tables
- External function call
- Equal scaling in diagrams
- Copy Method of Worksheet Class Failed
- Macro Question?
- Poor Worksheet Performance (for Mike Malachy)
- Refer to three cells to populate For next
- Run time error!
- Calling solver
- Menu creation - from DLL rather than .XLA
- Silly question
- Export to multiple workbooks - row limit
- ! error
- Named Ranges - Slow Workbooks!
- Converting hex to ascii
- Excel VBA - Read and modify the chart data range
- F1 key not producing "Help" window in Excel 2003?
- Excel VBA - Read the series' chart data ranges
- Remove ' at beginning of cell
- Invalid Number Format in Excel 10
- VBA - chart reference error
- Re: Paste text over merged cells
- save with date
- Copy Method of Worksheet Class Failed
- Selecting Refedit value
- sick code needs doctor
- HELP!
- Checking for duplicates?
- comparison charts
- Listen to network adapter
- Rendering EXCEL pivot kind of report using C#
- Auto invoice numbering
- Copy Mult. Wkshts Into Single Wkbk
- forget password of my vba program in Excel
- Search in Range
- Scrolling gives me error 424
- excel 2002 -Userforms and macros help
- Getting the name of the Actual Scenario
- Macro : confirm Delete
- Running a macro on multiple tabs
- solverresults
- hold down a key while clicking using Excel VB... sendkeys/mouseevents?
- Multiple TextBoxes_Populate
- Test that a workbook is open
- BeforeSave event
- advice on improving code
- save as filename
- Count Property
- excel 97 Charts and Controls!!!!
- RE: communication
- Saving while vba is passworded
- Re: Can't Set DisplayAlerts to False
- Test if Lotus Notes open
- Input Box List
- Count using VB
- Test for existence of Name
- CopyPicture is giving problem
- use vba function in formula
- xla Installation
- Custom function not computing (#VALUE!) returned
- Syntax needed for With
- Random Numbers from list
- Re: problem with code in workbook_open event
- Can Combo Boxes Be Formatted?
- "file not found" error message when launching source file
- VLookup
- MsgBox
- delete a category
- Delete Rows
- reture the range of a chart series
- Else:
- Comparing Items and Prices in Excel
- Calling Analysis Add-in Funciton in VB
- How do you know when a data refresh is complete
- Changing copy to Cut
- Repost: hiding columns
- VBA SpinButton_SpinUp Question
- WhatTheHeck?
- Re: Multiple TextBoxes_Populate
- Re: cpearson VBE question
- Nested IF Statements - Worksheet Function
- Question to speed up a process -
- numbering a column
- Adding zeros
- File Formatting!
- Using Offset on Cell Address
- Re: numbering a column automatically
- date issue
- Totals
- RE: parameter value query
- Re: numbering a column automatically
- VB Errors
- "Library not registered" message accessing an HTMLDocument object
- Range Resize
- File X1Textwindows formating!
- what is a good/best formula to extract the 3rd last word in cell A1 into cell C1
- Counting rows
- XL 2003 macro not working in XL 2000
- Scroll Bar in Excel 2002
- file handling
- On Error ??
- How to convert excel file into raw format/file?
- file handling 2
- Re: Form resize based on screen resolution.
- Send Mail With Redemption
- Help Please: Need code to test several lines
- Chip Pearson: ProgressReporter UserCancel event
- URGENT!!!!!!!!!!!!!!! Problem with macros in Excel
- Re: Form resize based on screen resolution.
- Can't dereference a missing DLL
- Back to original file
- Multicolumn ListBox in Userforms (selecting specific rows)
- Klagenfurt Austria July 2004 European Spreadsheet Risks Interest Group Conference
- EXCEL.exe has created errors and will be closed by Windows.
- Include Count
- auto execute
- Using with...
- Truncate text
- deleting wksts
- Calendar
- Automatically filling cell with data from COM port
- Date format issue
- emailing
- instead of formula
- WinZip
- Forms
- Application.WorksheetFunction.Upper
- Clock?
- Text Extraction
- Move Cell in Column A to Column B when FIND
- Calling a Sub passing Textbox name
- Protecting a workbook
- Re: Truncate text
- Merge into Word Template
- FileSystemObject
- Lowest Value
- Copying from several workbooks into one
- Unable to get the Values property of the Series Class
- Change OLAP Cube Data Source
- List source must be on same worksheet?
- Export data to SQL table
- Solver32.dll unavailable error, use excel setup to reinstall
- Question for MVPs
- having a macro work only on a worksheet
- RE: text box program
- Changing location of text file from which information is imported
- Newbie - two questions
- msgbox
- I guess only super computer can solve this
- Something works, something don't.
- Particular custom function.
- Assigning cell values within a VBA program
- Protection in VBA
- Paste Options Button Does Not Appear When You Paste Between Two Instances of Exc
- Copy text only
- placing a point on a image
- I guess only super computer can solve this
- Help with collections
- VBA code to add a reference to solver
- Transfering values?
- solver setcell= to an argument name rather than a cell in the worksheet
- Use DDE in VBA code.
- Subject line in outlook
- Merge Excel data/charts into Word Template
- userform zoom
- listbox option in form
- UnlockProtectedCells
- Custom format
- processing part of a collection
- MSChart Control Question
- common dialog box
- protection with cells
- closing Excel in VBA
- Hide Excel row in VBA
- simple workbook create/copy queries
- updating of data without overwriting the previous data updated
- Sorting rows and columns using VBA
- Insert row
- Minimise Form Button + Linked Wrokbooks Warning
- Deleting Blank Cells Subject to Criteria (Originally Posted in Excel by Mistake)
- application. ...
- creating a dos command in VBE
- add a new line on the same cell using a formula
- different font format in the same cell but using a formula
- Wav Warning Upon Attempt to Close Userform
- Problem in plotting data series on secondary axis
- conditional formulas
- use vba in excel to append data in access
- How do you determine if it's the 1st row/col of a specified range?
- RowSource not supported in Office for Macintosh (workaround?)
- Office 2003 pivot table filter clear
- dynamic textbox??
- execute stored procedure
- send zip file to desktop
- how easily indent my code?
- Read only without password
- Printing one Adobe pdf instead of multiple pdfs
- creating a running tally
- form
- adding rows
- #N/A Help!
- Calling an excel 4.0 macro from vba in Excel 2002
- Re: C#, OWC10 and forcing formatting on columns.
- Copy sheet problem
- Debug problem
- Pivot Charts
- Formulals
- Right click menu in my form
- If Then Conditions