- using escape key to exit a userform
- Re: "If" VB Syntaxe
- XL97: Out of stack space opening web page as workbook
- Processing a set of Excel Files
- Last Row Macro
- Selected Cell
- Re: Activate Macro on Activating a sheet
- Re: Importing data
- Help with Formula
- Macros and command buttons
- Problems with using SQL via VBA to extract db data and copy to a worksheet
- Looping thru the active selection
- Initiate perl script in linux from a Windows VBA program
- export from excel to word
- Why 2 legend entries?
- Re: VBA error check using Excel functions
- Excel VBA syntax problem
- Macros to Cut and Paste
- How to Activate unknown file name
- how to select multiple rows using vba
- edit cell names all at once?
- How to execute a macro when data in a pivotchart changes?
- Exit Excel programmatically
- Excel VBA - MsgBox to display variable value?
- Controls in Excel
- Creating a Sum
- Whats the equivalent for NETWORKDAYS in VBA for excel ?
- Macro Help Please
- Multicolumn Listbox and ordinary listbox
- How to jump to fisr empty row?
- Matching cell in one column to value in another
- Excel exception problem
- Sending Email Through Excel - Disable SpellCheck
- VBA - SaveAs hangs (2003 vs 2k ?)
- find workbooks with macros
- Need a Quick answer on this one.........
- Read data from a text file (*.txt)
- Disabling Close, minimize, and restore
- excel with embedded word doc
- Userform
- Error Trap for bypassing Password Protection
- Hidden data?
- Print Box
- Send active workbook as attachment
- Recordset Problem - object is closed
- Tracking Workbook usage
- Need to Pull Data into a Comment
- Deleting shape series and trendlines
- Excel 2000 not working at all
- One more loop question
- EXCEL VBA question
- Need a macro to move data from column into rows
- plotting chart with user selected range from current workbook
- Loop through all files in a folder
- Source an Access Table for a dropdown list box
- Same sub different results
- Help with Error: Type Mismatch
- colored a cell
- Delete Entire Row If Q
- Hide row from VBA
- Find a hidden entry
- Sorting
- Macro.
- Have a Formula I want to put in to some Code Q
- Quote qualified data export
- detect upper and lower case letters
- Copy Last Draw & Paste
- Enter= New Paragraph in Text cell?
- possible "or" function?
- Macro needed
- Creating a Macro that loads the most current dBase file.
- Add Up Q
- Copy Last Row & Paste
- Macro to split mult text in the cell to separate cells
- Macro to various text values in cell to separate cells
- create new Folder
- NewMenu
- Writing Unique Solutions; what could be wrong here?
- Macro programing
- Vba Help Required
- 911 Excel Cache!
- "=ROW()-1" type of coding doesn't appear in a filter / is there coding that does?
- Fix If statment to accept Upper or Lower Case
- strange printing/looping problem
- Help for a VBA rookie
- Specify style and color of marker in chart
- if a=true and b=5 then....
- HELP----Row cut and Paste
- Amend Access database from Excel
- Names of macros for toolbar buttons
- Sending spreadsheets through Lotus with a group mailbox
- changing directories...with vba
- VBA Code printing problem
- building a smart league table
- "Cells" become "CellS" - why?
- input message
- Pasting Q
- Code is Running Too Fast
- Help with 1 code line
- Re: Help with 1 code line
- Sorting times - getting messy
- Find Function via VB
- Web queries
- copying output from pivit tables
- Works with Excel 97, not Excel 2000
- Stepping through For Each...Next backwards?
- Chart component
- Shared Workbook Question
- Excel 2000 and TextBoxes
- Converting to R1C1 in FormulaArray
- for...next and criteria1
- Import CSV with match
- controlling another application via VBA code in Excell & sending keystrokes & mouse clicks
- Userform troubles!
- Excel Add-in
- Excel 5.0 compatability problem?
- Ack. Going to another column Take 3. Sorry!
- Date Colum Date Formatting & Validation
- Combobox run time error
- keep focus & window steady
- Prompt user automatically
- One more macro
- Passing Number Format to a Variable
- Can you reuse links??
- Menu for user forms
- 2 column List box
- Convert range of text to values
- Web Query for Currency Rates
- why does my excel file size increase when I use visual basic editor
- sending email from Excel
- Passing format to variable Part 2
- Worksheet_Change Event triggered off specific cell
- frm Excel 97 to 2003
- Option to continue or cancel
- Why does the EnableSelection-xlNoSelection stick thru the user interface?
- Auto- Fill Dates?
- Excel VBA problem
- Decrease file size
- Newbie vba - How do I reference cells in another workbook
- Macro Question
- Can it be done
- macro auto run
- Excel VBA - hidden rows / autofilter
- Message box
- Help creating link & formula from user input
- Zip&Email-VBA
- How to Sort Data by columns and display the data on GUI using Visual Basic
- listbox as filtr
- Cell Bound Combo Box
- on press detection
- Combo update filtering
- Grey Panel/window
- VBA saving
- Macro to Close and save all changes
- Filtering File names
- Msgbox query
- Userform Print
- Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X
- screen clips
- XML selecting sinlge nodes with name selectionNamespaces
- RTD Throttleinterval. How do you change it?
- msgbox query
- Do.....Loop until IsEmpty(....)
- XML
- Cells.Find doesnt work on columns other than A
- List Charts Macro
- new class w/ graphic objects
- Hidden Files
- Select method of Range fails
- Can information from 2 columns show in one combo box?
- focus
- Appeding user data to the end of excel file
- Running Macros in Access from Excel
- timesheet
- Using forms
- On Click Event?, and how to use
- Missing References
- data from a sheet to a matrix
- on press
- OLEObjects clickable?
- Copying of sheets
- escape character
- #N/A Using SQL.REQUEST
- IF Limitation?
- Excel 2003 Autofilter Problem
- Testing for hidden rows
- how do you add a row of data like in a database
- Information into tables
- drop downlist that captures criteria from another sheet
- VBA Forms and Illegal Operations Galore
- Duplicates
- Selecting filename in cell from file browser
- Macro problem
- Selecting range question
- Breakup cells having 2 words with a blank between them
- msg box help
- Make Sure User Selects 3 Cells
- Reverting to a date
- Worksheet_Activate
- HPageBreaks oddities...
- Re: R1C1 type refences in VBA for column identification
- Loop through all Open workbooks
- Two Match Statements.
- How to set up a sub-total routine?
- Excel ADO SQL StoredProc
- macro to select sheets/page in a workbook and print them
- Re: MACROS & COMMAND BUTTONS
- VB coding for showing "find" dialogue box?
- MACROS & COMMAND BUTTONS
- Display HTML help file using FollowHyperlink; want browser to have Focus
- 2 Questions about inserting rows.
- extract time from excel serial date
- Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue.
- Sheets select method fails when workbook is opened by another workbook
- Re: printing using IP address
- Re: Decoding a Range String
- Excel VBA - Assigning macro to button.
- run macro automatically
- View range in a macro
- Is there a way that I can control a row's height with programming? (or cell contents)
- sum function
- Trying to set the Collate default to off.
- Re: Run Macros Sequentially
- Msgbox button labels
- Fill with a formula until Cell is Blank
- AUTOFILTER copy and paste
- Convert an empty string to a double
- Series Code
- Cell comment string trunckating
- What does undersocre line mean
- Mouse pointer
- Color index values
- Macro that querys only the most current dBase file.
- FaceID Toolbar (The best one ever!)
- Worksheet_change
- hiding showing columns using checkboxes
- Re: Print Preview
- double array
- Re: Visibility Problem of Embedded Buttons in Worksheet
- Re: Copy VB Project
- Programming lag..
- clear the clipboard?
- Autoexec Macro
- colors
- Excel vb running a batch files and parsing output issue
- Import from web query problem
- loops and If's
- Hide/Unhide Columns representing dates as per Current System Date!
- How to add menu button to exisiting menubar
- Shared Workbook - Hiding rows as per Username
- how to Pause a VBA procedure until user presses Enter
- formating an excel spreadsheet
- Loop too slow deleteing xltoleft
- SaveAS w/ a variable name problem
- How to run Reports in excel
- Pivot Tables - slow...
- Goal Seek
- How can I set the title permenantly
- function returning array
- Need Mac File Type Code for CSV formats
- Copy Rows and insert these rows before a page break
- Files properties
- How to detect user quitting excel
- Activesheet.delete
- Select last cell in range
- Getting excel array dimension
- SmartDocument: RefreshPane() doesn't update TaskPane immediately
- excel to word.
- Last Row Help
- Protection & Macros
- search facility
- Query returning more data than will fit on worksheet with VBA DB query...
- If Then Else Help Please
- How to create UTF-8 file from VBA?
- Excel Macro - Calc to last row problem
- Word Mail merge
- Q: find range, listbox - format and fit columns
- Editing a Row
- SQL-Query from a textfile?
- Additional thread in VB in Excel
- Sort by color
- Find&Replace on a lot of *.doc' s via an excel macro?
- Subscript Error
- Arrays
- Excel VBA - Activate Open Workbooks to format
- changing colours on stacked bar chart
- Cells coloring PivotTable
- VB's equivalent to VLOOKUP?
- Excel VBA - Easy way to paste chart to word document ?
- Coloring problem
- Question to overwriting a sheet
- VB to Find Rows
- Cut and paste
- For Next statement
- Creating a vehicle running sheet??
- Set Active Worksheet onOpen
- List of VBA Functions
- How to find if something has been changed on a worksheet..
- Custom Lists file name
- Showing an angle in cells
- Tabbing
- Count Bold Numbers in Range - multiple rows
- Computer Identification using VBA in Excel
- MsgBox Properties
- How to convert and email spreadsheet
- Pasting column after end of spreadsheet.
- Re: Pasting column after end of spreadsheet.
- Excel With Outlook
- Re: Marking my sub into a function i can use in excel
- Search for text in a cell
- Differentiate b/w False and 0 with InputBox fn
- copyright symbol in text of a label in VBA
- Macro Formula Updating Problem
- Telephony
- Conditional Formatting
- Name of color for a particular colorindex number
- Two Date Coloumns to replicate in second sheet on one line
- Extending Selection
- Linking Sheets
- List boxes
- Simple Shell Commands
- Listboxes 2
- Defining the subject of an Email by value in range
- User defined file name in an OpenText File command
- Searching a Column
- SAveAs executes combobox code
- Importing CSV format issues
- Differences between Excel '97 and 2000
- Locked workstation breaks code?
- Generally speaking, which is faster?
- Disabling an AutoRefresh of Scrolling in VBA
- Protection problems
- Macro Help Please
- Easily iterate through the columns?
- Need help with Macro
- ZipXP
- Formula doesn't compute. Can you figure it out?
- Adding new rows
- VBA Problem - How to collect and display text information from applicable cells.
- Counting Variables
- Invoicing
- Automatically selecting the next option in a drop down menu.
- pivot table
- Convert Date Time in Spreadsheet Column to Date only
- Recordset or Object is closed HELP PLEASE!
- Automatically special pasting a range each week
- Excel macro
- Message Box if Attempting to Save over Master
- Alternatives to VBA in Excel
- Spinbutton help required
- Searching a column (Repost)
- Re: eMail a sheet
- Hash a range, output a Long Integer?
- Re: eMail a sheet
- Re: eMail a sheet
- Userform: Textbox changing with selection in combobox (list)
- MsgBox question...
- autofill macro has error when there is nothing to fill.
- Position Cursor to A1
- Wondering if there is a way?
- Time Function
- msgbox if you input text instead of numbers
- Re: worksheet to workbook macro
- XLS to CSV conversion
- Excel - Saving as a Web Page
- Find method using User input
- Delete Key Error Message
- Copying Dates from One sheet to another
- Look up VBA documentation using Excel Help
- systen variables
- Creating a Worksheet in VBA
- Creating a folder automatically
- Ron de Bruins Delete Row Code Q
- Macro Run-time Error 1004 Application Defined or Object Defined Error
- InputBox function - prompt string limit
- filters
- "View" in Macro
- date picker
- Sorting Worksheets in Alphabetical Order (Left to Right)
- SourceData in pivot table
- RE: Pivot table field swapping in code
- Deleting old connections
- Run Time Error '13' Type mismatch
- Reconnecting a Link
- Opening excel files automatically
- personal.xls file
- Reminder for backup
- Programming lag
- List of VBA Functions and Constants
- Testing msnews.microsoft.com
- Validation
- Automate CD Burning in VBA
- error handling - check chart existance
- macro was working, now it's not working
- Macro doesn't work in Excel 2003
- Excel validation problem
- Changing to a selected folder
- how to change the defult location of Pivot Chart
- True / false output problem
- Excel 97 Macros in Later Version of Windows
- Delete a line in text file
- Delete a line in a text file
- Delete a line of text file
- Copying cells within a loop
- useless file
- Slow Macros ...3
- Re: Shared Workbook - Hiding rows as per Username
- Dll error resulting from "CreateWorkspace"
- Clearing a column
- Hide and unhide worksheets
- Pivot Table Calculations
- Keep certain rows only?
- Horizontal Report
- join sheet 2 below sheet 1
- Pictures or colors on tabs of multipage?
- Random Sort
- Private type - please give example
- cells not changing selection after sheets array
- Colour Formular (Not a function!)
- macro virus protection
- Filling down problem in VB
- Save and exit automatically
- Create New Folder
- to find cell
- Range Paste in VBA
- read range in excel without MFC using ole2.h
- Formula help!
- Images cannot be assigned to Listview control
- How to get the indiaction in Listview columnn header
- Application.quit
- Creating a table from one varying source
- On open/closed events-and stuff
- MS DOS Commands
- Path name
- clear form combo boxes problem
- OFfice XP SP3, Strange Things....
- add a toolbar button for an add-in
- Assigning Macro to "Buttons"
- Remove Macro
- conditional printing
- Selecting cell using range.offset
- Print group of sheets by VBA
- Excel VBA - Find User Inputted Variable
- VBA trouble when using Excel 2003 vs Excel 2002
- Adding comments in a range (!) of cells
- Populate a combobox
- VBA Code to remove VBA
- Indirect validation possibility?
- How to compare 2 lists in Excel VBA?
- Excel VBA - is there a multiple slider sliderbar control
- Excel 2k VBA problem - For loops interating a sort
- Problem with UDF
- com addins. Which book(s) to buy?
- code to force xls file to open after several hours passed
- Load xla addin on demand for particular Excel instances
- calendar/date control
- Selecting printer from macro
- Indirect reference
- TextBox.Activate - QUICKY OFF THE TOP OF SOMEONES HEAD
- grapic chararcters in a userform
- Help bug?
- Cells.Range
- linked formula
- get data from a text file and insert them in datasheet to show a chart in VBA
- Two simple macro commands
- Bat file
- Images in Userform?
- table & chart
- reference non blank cell
- Sheet Names Array
- Create a subtotal
- Data Filter Operation
- Can we make a cell behave like a list box and populate it with values for selection.
- Thisworkbook.SaveCopyAs - Does it work on Excel on IE?
- Comment
- try to use a worksheet object
- Iterating through cells problem
- compile error: block if without end if
- Displayalerts and Screenupdating
- Excel Formula in XP and NT
- sheet name VBA
- Worksheet_SelectionChange clears clipboard - can I stop this?
- Looping through a range of cells
- Comparison between 2 columns ?
- Comparison between 2 columns ?
- Batch in excel
- Creating a Macro
- RE: MACROS & COMMAND BUTTONS
- Unassigning / Removing Macro from Shape
- newbie needs help again, function returns 0 ONLY
- hide sheet
- Dlookup?
- Macro Library
- Delete rows that don't contain '+' or '++'
- Macro & Command Key to change data from Colums to rows
- Iterating through cells problem
- password prompt to unhide sheet
- Two validation cells populated third validation
- Range description
- Counting cells thru VBA
- Find specific text in a string
- Excel Save pops up when unloading Addin file
- Literally - every other time
- input date as date in formula
- input date as date in formula
- User Prompt to Confirm Values
- ControlTipText style
- Put one of the Regional Settings in a variable
- On Open/On Close
- Can I create a FORM (that I can modify etc) from an existing spreadsheet?
- adodb.recordset with excel
- Beginner seeking Excel VB String answer
- Creating a Macro that loads the most current dBase file.
- tracking changes to cells
- Saving Individual Worksheets
- Pivot Table Macro
- Verifying all data in each row is filled in
- Copy & Paste Macro optimize
- Using macro to find file
- How to compare only a PART of strings?
- Get external data - how to stop table list from being displayed on connect?
- Q210684 - Need more info on suggested work around section
- Closing excel and saving workbooks
- NewComment
- Select Case
- Function in VBA
- re table & chart
- Opening a single workbook
- Macro help
- Tracking Workbook Usage
- Recalculation on cell changes fails when using VBA function
- What is wrong with my array?
- How to skip empty cells while running a macro?
- Show Form, Hide all Sheets
- easy one!
- weird
- enable macros as default
- Switching Sheets
- PivotTable - PivotTable Field name is not valid - error!
- row numbers missing etc
- Extremely slow run-time
- Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed
- different color if an x esists in range
- Insert Row & copy all formulas - shared workbook
- display all records to filter
- Sorting each row individually
- Saving an unactivated worksheet
- Macro coding help needed
- Application quit without displayalerts
- How to set a new Excel instance as the 'default'
- Copy file without open it???
- Opening files from a variable (todays' date) folder name
- Visual Basic for Applications
- How to activate the button
- Print a List of Keyboard Shortcuts in Excel 2003
- How to read from a SQL Server table into Excel and use the Excel cell format as in the database
- How to read a SQL Table into Excel change the data and write back into SQL
- Worksheet_Change event doesn't work in Excel 97
- Worksheet_Change event doesn't work in Excel 97
- (Name) Property Under VBA Control
- Text box help
- Excel File Name Got Changed Automatically
- Run-time error : method failed
- How select unlocked cells only
- Hiding workbooks on opening
- Toolbars not working
- Real problems automating a mail merge
- Hide prompt to automatically update links on workbook opening
- Macro Running at Spreadsheet Start
- Excel VBA - Keeping a chart stationary in a worksheet while scrolling
- Excel workbook with formulas keep crashing application
- ComboBox
- Corrupted workbook or code?
- Force re-open file
- Check before closing Excel
- How to do the folliowing copying fast?
- size/space problem with module1 in VB even though it is empty
- Hard Code DLL Reference in VBA
- Macro invocation after data enrtry
- Stupid question - Put a value in a cell?
- Alex
- Hard Code DLL Reference in VBA
- deleting rows with zero value
- Can Excel Macro DoubleClick Icon?
- VBA Slow Peformance on Formatting
- Reverse cell value and convert to date
- Pivot Table Source Field Name
- Unwanted Rounding Errors
- Countif in VBA -- evaluate multiple criteria
- shared workbook
- Pivot Field Function Code
- Macro
- test
- tree view control
- Search code won't find partial matches for P.N.s
- Next Sheet
- Code not working
- Hiding a pivotfield using code
- Re: tree view control
- Excel Macro "relationship" grapher ??
- Text box Scroll bar position
- Excel Program Glitch?
- Close Workbook without displaying message to Save
- Relative References for macros
- Delete row if columnA and ColumnB are same
- Delete row if columnA and ColumnB are same
- Printing with much text in a cell
- Printing sheets with large amts of text in some cells
- Excel VBA: Pass value when clicking button
- Print Preview
- Excel lost function pointer in BIG project ?
- Assigning a row to a variable
- send value to a cell instead on MsgBox
- Personal.xls Macros?
- GetObject-question
- Hide calculatedField
- Macro, Module, function, sub and This workbook and sheets ?
- Application Worksheet Function Vlookup error
- Unloading userform in MSComm event
- averaging values according to (very) complex conditions
- New to Error Handleing
- Working with a selected range
- last row
- Behaviour of Save as and Displayalerts
- Problem with adding an item
- macro to use a cell's contents as it's name
- Excel Create Array Variable
- Adding the same content to multiple combo boxes
- Repeating pattern on my second sheet
- Finding multiple values in excel, then sending as "mail merge"
- Coding for Pivot Table
- Disappearing Tool Bar area--Tough one!
- automatically special paste each week?
- excel dropdown list??
- Re: sql and excel
- Prompt for name when copying sheet
- Pivot table number format
- Formula
- VBA search and compare strings
- multi select listbox
- Error on activating a window a open workbook
- checking the format of a string in a cell
- Trimming text contained in cells
- Multiple arrays in Median function -- VBA
- VBA questions
- Select checkbox with tab key?
- "If Not" with a date
- Fastest way to clear contents
- Lookup as Part of Macro
- Omitting displayalerts set to true Vs. Automatic reset
- Key event
- Setting Workbook Name by VBA
- Arguments as properties
- Excel AddComment editing font
- PrintToFile OutputFilename problems
- COMPARING LISTS
- Re: Editing Excel without starting excel
- Macro - set calc off
- Looking for a VBA book
- Custom cell formatting
- Add value to array based on if...then output in VBA
- Losing data when converting
- Conflicting VB Code
- Importing Text File Based on Query
- Questions of Great Import
- run macro auto
- Need to create report in Poerpoing from Excel data
- Need to create report in Powerpoing from Excel data
- Converting Excel 97 VBA to Excel 2002 VBA?
- Form Positioning with Freeze Panes
- outlook post form thru excel
- Getting info from the clipboard
- excel open outlook postform
- Excel open Outlook Postform
- Error Handling Open Function or query for missing Files
- Excel Vba -userform Table Column
- Timer control for Excel VBA forms???
- Excel Vba -userform Tabular Column
- Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown
- Timer control for Excel VBA
- X-Platform Problem
- Excel Vba problem
- subscript out of range
- Dictionary Functions
- Summarizeing sheets
- Error 1004
- Macro
- problems with dates before 1900
- Validation using VBA
- Macro doesn't work in Excel 2003 (Con't)
- Picking up values from other tables
- Automatic file opening procedure seeming to hold cache
- VBA - AfterSave event
- Analysis ToolPak Not Working in Browser mode
- How to calculate Total for different Group from user entries
- Run-time error -2147319784
- String Function 'Like' and Special Characters
- Exel VBA - Clearing clipboard, area names
- Macro won't run properly
- On_change , Upper case, file SaveAs
- Setting autofilter criteria
- Controls Moving
- File Recovery
- Excel Automation speed (version + OS)
- How to solve: y=1/x, x>0
- Registry key for "Trust access to Visual Basic project"
- Deleting a textbox control at runtime
- Creating menu items without using VBA way?
- Find Function
- Weekend dates
- Variable Not in the cell
- Create an undoable 'paste formula' macro
- InputBox
- Problem assigning macro to button?
- "document not saved"
- Export Excel data to XML
- function recognizing that there is no inout in a cell
- Is there any API to know that ocx files are registerd in the machine or not
- How to find the range of a web query on a Excel worksheet
- =Right Function
- =Right Function
- Working with a combobox
- Checkbox Macro
- How to export a range to a picture ?
- Formula Syntax
- Spurious ComboBox change event
- how do you break the link with MS Query - Database via code
- DT Picker Control
- Enclosing values in Quotation marks
- Referencing A Formula As Text
- Toggle Macro
- problem while opening VBA template through intranet
- Problem in opening template through intranet.
- Setting Print Size for varying Printer use
- Excel Vba Userform Tabular Column
- Macro to move information to different cell
- Set variable to a function
- excel vba program
- Set Print Area Macro
- Use Array to Goto Certain Rows
- Slow Add-in Load Time
- If/Then statements
- Copy & Paste Macro optimize
- xlNone incorrectly valued?
- Automated userform inputs to the spreadsheet
- Automated userform inputs to the spreadsheet
- Automatic userform to input data to spreadsheet
- Automatic userform data input into spreadsheet
- Substring to replace string
- Substring to replace string