- Please help..urgent !
- activeworkbook.saveas - saving format changes
- decimal & percent format
- VBA Script to detect user input
- Re: Populating blank cells with the data in the cell above.
- Multiple Column Cell Compare looping through Rows
- Mail Merge Error
- Mail Merge Error
- Simple table query
- Re: Creating pick box with unique input values from a worksheet in the
- Buttons
- Re: range class problem
- general validation question
- How to make Excel the Top-Most application programmatically?
- Re: Grpahical selection of points on Excel charts
- A Turing Machine in Excel
- combo box
- Directory List - Ron de Bruin
- Named range
- Msg Box
- Msg Box
- Msg Box
- How to change Text
- Unprotecting Worksheets in VB Script
- IF THEN STATEMENTS
- Excel VBA-Creating Menus
- Opening & setting data from Excel to webpage
- New to ComboBox
- Using LinEst function within VBA macro
- Macro Expert Help needed...
- Does OnTime slow macro down?
- code to delete a defined name
- Create an .xla
- Q. Consolidating a long list, in single workbook.
- Using Variable in Rows(x:y) function
- Is it possible to load an .xls file
- Re: Excel if & hyperlink formula
- Running Macro in Minimized Excel Window
- What if AutoFilter is NOT on?
- Add a multiselection list box to a spreadsheet
- Q. Why do my dates appear as 30/12/1899 ?
- Re: Incorrect msgPrompt
- How do I use VBA to add a formula?
- Macro or VBA help
- specific name for saving.
- Spreadsheet Dropdown ?
- Event for a file being changed?
- CheckBox on UserForm
- match problems
- auto-populating columns
- Add page breaks from VB
- Error with Form
- Excel Date/Time problem
- Date as worksheet name
- Need help passing an array as an argument
- .NET remove .net code from Excel spreadsheet
- "Out of Context" Message?
- Help! Excel Macro Delete function!!
- deleting blank rows
- Update custom outlook form from within Excel
- Out of memory error
- Error in loading DLL
- Excel 97 printing error.
- how to get Procedure..
- Print form
- Classes, and the For Each construct in Excel?
- clean up selection optinons in pivot tables
- Importing email from outlook
- How to trap KeyDown Events For Worksheets ?
- Linking To An Autofilter Arrow
- Excel marcos firing on file save as but not file save
- Transparent Text Label
- Step back
- Declaring variables - Option Explicit
- Adding text to a cell
- userform syntax
- Help on printing only selected hyperlinked documents in Excel using VBA
- Error document already opened
- Inserting a formula into a cell
- Mail a row to each person in a range (HTML) Index?
- Change the name of an unsaved workbook?
- Excell VBA - Class Modules problems
- VBA routine to assign first name only to a variable
- how to merge two databases
- how to merge two databases
- Find That Date
- Re: How to change Text
- Sharing Workbooks With Macros
- Copy Conditional Formats
- How to retrieve and write data to a webpage
- multiple chart indexes
- How to create a Excel Workbook natively
- VBA version problem
- Deleting a module
- First Column Value Changes Row
- Keep format in Pivot Table
- finding duplicates?...
- Updatelinks
- Sorting Sheet1 from Sheet2
- optimizing a macro
- IeTimer events not working in modeless Userform?
- ComboBox Problem
- Re: Returning a text value
- Problems with IF's
- Transform MS Excel Workbooks to Web-based Application
- Transform MS Excel Workbooks to Web-based Application
- Transform MS Excel Workbooks to Web-based Application
- Transform MS Excel Workbooks to Web-based Application
- Re: Permission Denied Error 70
- Re: Email addresses
- Replace text with numbers.
- macro security issue
- Hyperlink
- dynamic reference for chart
- Re: Why doesn't Selection.End(xlDown).Select always work?
- Re: Why doesn't Selection.End(xlDown).Select always work?
- C++ instead of VB for excel macros
- ComboBox
- Userform resizing
- SEARCH & REPLACE MACRO
- Macro to copy only certain text
- Error when runing macro to create pivot table
- Password Entry
- Delete rows
- Sending cell data in E-mails
- VBA Word
- To exceute a Macro when worksheet is deactivted and data is changed
- Variable Ranges for Print Areas
- multiple nonlinear regression
- Unable to get the Vlookup Property of the WorkSheetFunction Class
- Combo into calender?
- Worksheet_change - Murdering syntax
- Create a New Menu
- user friendly filter
- Add Search Box to Spreadsheet
- Help with combo box
- Sti / path?
- Counting string length
- Bypass "DISable Macros"
- OFFSET Syntax
- Macro for Synchronizing time from the internet?
- ComboBox Controls
- What's wrong with this code, please?
- Save Excel without macros
- Populating worksheet with data from Access
- Text Data Series
- OnTime events
- Freeze Table
- byref errors
- Combo Box Help
- To display message in 2 different lines
- Calculating Averages in VBA...
- Run
- "Find" Macro not working for some
- Run-time error '5'
- Pasting data and dates
- loop in a textbox
- Shared Workbook in Excel XP or greater
- Copy and paste data to a new sheet
- Page numbering in a report comprising of a number of views
- export Chinese correctly to text
- Opening WORD from Excel
- reformatting data
- Event Macro
- Pivot Table
- Expand column to copy
- Sumproduct wont work
- automation object type library reference
- Email FIle Using Lotus Notes
- ActiveWorkbook.SaveAs Problem
- Running .bat and .exe in Excel
- Unhide part of Full Screen button
- detecting row or col insertion & deletion
- Excel Versions and defineing word.application
- Column sort
- Dependent combobox
- VBA Authorization in Win2k
- GeFormat function in Office 97
- Application.WorksheetFunction.Index syntax
- a question about cell text wrap
- #value
- Re: Grpahical selection of points on Excel charts
- How to get data validation list
- macro to select sheets
- Problem mapping procedure using OnKey Method
- Storing additonal information for a cell
- open power point foils via excel button (link)
- calendar control
- change
- Type mismatch problem?
- Copy
- Automatic Cell population
- Automation Error when deleting command bar button
- Independantly running code
- formula for ranking participants of a contest
- Display Many Excel files into one UI with Tabs
- Re-using Web Query Data
- Fit to page in macro
- PowerPoint Graph Size Changing
- Reversing the order of the bars in a PowerPoint Bar Chart
- Date Formatting Problem
- Worksheets("name") vs Sheets("name")
- look up and ISNA in vba
- Opening files...
- Open files...
- hiden sheet
- FileDialog Help
- Checking a cell
- UserForms and workbook manipulation
- Shell "mkdir"
- Copying files
- Cell Search Calculations
- Re: Find Next in a selection, how to stop it when it returns to the fi
- Automatic creation of Hyperlinks
- Graphic Thermometer, Linked to Data Cell
- VBA cannot see data in Range("G1").select - but its there!!
- Control content of text boxes on a userform
- GetopenFilename & Files with special characteristics
- Keypress Event
- File Dialog
- E12 conversion
- cal number of days
- Self Cert Transfer?
- Re: using vba code to find the square root of a number
- Re: using vba code to find the square root of a number
- Re: using vba code to find the square root of a number
- function names multilingual
- search function
- How To Iterate a range of cells?
- VBA Problem going from Excel 2003 to Excel 97
- excel 2003 browser control??
- mathcing and comparing
- Search function in Vb
- Vying for the focus - Worksheet Vs Forms
- Lookup problems
- Test fileOpen
- hi i reall need help with autofill
- Re: hex to decimal
- Macro Help...Copy form txt file
- Macro to automaticaly save a book under an specific name
- Event macro
- Userform Question
- urgently required..
- Excel designing a simple game
- Re: Macro to replace and updating sheets in workbooks
- Circular Reference
- Get file Author from FilePath without opening document
- where to find all excel constants?
- what cells add to a value
- Links between VBcomponents and Sheets
- Extracting data
- Focus
- Re: Selecting a Cell inside a range
- Re: Selecting a Cell inside a range
- Re: Selecting a Cell inside a range
- Re: Selecting a Cell inside a range
- Re: Weighted Avg - Complicated
- Compiling an Excel Spreadsheet
- Textbox & Save file problem
- Links between VBComponents and Sheets 2
- Goto Sheet based on Cell Value
- Compare to columns
- cut and paste variabe ranges in one sheet to different sheets in workbook
- Compare columns of value
- Compiling values based on selection criteria
- user form-on open event? keydown event?
- Macro to remove empty rows
- Sort in Subtotals
- Excel 2000 VBA - Removing leading zeroes from negatives
- Help: Impot Text File to existing worksheet
- Delete Rows & Capture Range
- Named Ranges
- Drop Down List in Every Cell of a column
- Getting a number from the end of a string
- switch excel/reflection for windows
- Event Macro?
- Find cell of equal value of a range and give result of ajoining co
- Improve ADO code, Export Excel to Access
- VBA command to say "yes"/"no" to popup window
- Analyze Excel files structure
- Request ..
- Dynamic charting
- Ref:Previous post
- Macro to Unprotect Sheet
- Re: Dropdownbox
- Re: Dropdownbox
- Large size posts in Newsgroups yield lesser responses ?
- Repeated - Page numbering in a report comprising of a number of views
- Dropdownbox
- Macro to Unprotect Sheet
- Worksheet help please
- Dynamic range selection
- Concantenate and align info??
- Help: Comparing two values
- Analyze Excel files structure
- change default file path in Save As dialog box
- Tricky Sort Issues
- Ftp From Excel
- Microsoft Calendar Control 10.0
- Msgbox text hard return
- Finding a formatted cell
- Excel Formulas - COUNTING PROBLEMS
- Message when workbook is opened
- Setting pivot table field (current page) to a chosen value
- RE: Formula Referencing Worksheet Name by Variable
- VBA commands to open email
- Named Range Question
- Practical use of Window Hide
- Radio Button
- Message Box
- Subscript out of range
- Use Procedure Instead of Macro
- Opening Size of Spreadsheet
- multi-page control questions...
- HPageBreak count problem unless in page break view
- Type Mismatch in Vlookup?
- Re: Formula Referencing Worksheet Name by Variable
- Reading Super Large Ranges from Worksheet into Array
- Problems Using DSL to Post to This Forum
- Adding items to a ComboBox in Excel VBA
- Help with inputbox (Distinguish OK from Cancel)
- Extracting text to the right of the caret
- RE: Dropdownbox
- creating an exe file with visual basic (installation file for Macros and Userforms)
- Bizarre Project Explorer in VBE
- Lookup problem
- Problem with xlTextPrinter?
- is this possible
- Spelling check
- Write command including unwanted quotaton marks
- Event for changing color
- Nesting information
- combobox
- VBA problem - prevent event to occur when certain button is clicked
- Create a pivot table in VBA
- properties of excel button/checkbox
- Conditional protection
- Tricky user form question
- to find values between two values?
- ?Conditional protection
- Question.
- If field in column is blank, delete if....
- Define Certain Exact Range
- Which windows are open?
- Clearing cells of numbers, but not cell references.
- API GetTickCount and API for sound
- How to keep showing full menu?
- Bar Chart in Excel
- Viewing Multi dimensional array
- Viewing Multi dimensional array
- formatting issue
- Comparing Lists to Partial Lists
- SendKeys Method ignore parenthesis?
- How to create a VB macro in Excel from Automation...
- Protect sheets from editing but allowing macro to do so?
- Compare ranges n copy at bottom of first range
- Macro Magic Wand
- Code to set NamedRange for all application-Languages
- Userform Maximum?
- Cutting off numbers to two decimal places using a SCRIPT
- FAO Chip - re: open windows
- Delete macro to stop importing data
- Hyperlinks and the Display field
- Links between VBComponents and Sheets 3
- Need to import multiple files with a macro
- exit sub
- Q. Autofill question: Can I autofill alpha characters like I can numbers?
- Create simple commandbutton for manual recalculation
- buttons for pause,forward,rev,run
- Close excel
- need a function for numbers to characters
- Softline break in cell
- sort problem
- Formulas
- Create button to open a file
- Re: button to open a file
- Parameters for Find method
- How To: Macro Command To Reference Populated Cells Only
- Show / Hide CustomToolbar
- Open File with Spaces in Path
- Automation error
- Function or method
- compare ranges in different workbooks and copy "not matching values" at bottom of range 1
- File dosn't always close?
- Calendar Control
- Copy from Multiple Sheets
- Re: Excel's draw tool to create a Macro Button
- macro to add alpha character to cell contents
- Re: Copy sheet from one workbook to another workbook problem
- Excel data match
- Help with updatelinks:=3 etc PLEASE
- File Names
- Fast reading/writing of CSV files
- Calling a macro in another worksheet
- Add a number based on list of criteria ???
- When using an Option Button can I...
- VB code to sum up all the figures in a column
- Find Intersection
- Run macro in active cell
- Ftp from within excel
- Controlling Powerpoint through Excel
- Urgent Help Request...
- Formula in Cell with VBA
- Multi-conditional user defined function
- Re: I can import Access Tables. But, I can't import Access queries
- RE: What a Paste
- Can this formula be placed in CELL AT3 and insert the "x" into CELL B29?
- Save without changes
- Re: Adding Calendar Control 10.0 to an Excel worksheet?
- Excel 2000 Macro failing in Excel 2002
- Shared drive
- rounding down
- Re: Excel Workbook automatically (by design) runs a macro
- dynamic formatting of cells
- Lookup possibly?
- Create PDF from Excel File
- excel vba browse file
- Convert Text Formated Numbers into Numbers all in VBA
- how to extract from this column
- number of days between dates
- Using the Sort Method
- Subtotal problem with Excel 2003
- Sheets with VBA controls won't print.
- Excel 2000 VBA Code not working in Excel 2002
- Re: 'Saved' Property not working
- Errors Detected Error Message
- Re: Oversættelse engelsk/dansk
- excel vba browse file
- lookup problem in excel
- Storing appostrophe's in SQL
- Dollars in a text box
- extracting from "show pages" pivot tables
- Help with Posting Login to webpage from VBA
- RE: Excel Workbook automatically (by design) runs a macro
- CommandButton caption title
- Re: Disabled Macros
- VBA Acting "Funny"
- Transferring data between 2 workbooks automatically
- Clearing Contents of all "unprotected" Cells.
- Re: Group Sorting
- Macro running at certain times
- Unique ID
- Lookup and Count I think
- another look-up problem(three variables)
- Consolidating tab-delimited text files
- Vlookup - column index number - create as variable
- Error: Unable to get the OLEObjects property of the worksheet class
- Saving Workbook
- Static variables
- Static variables
- Custom Header
- Running Win Macros on Mac
- Closing VB triggers closing Excel
- Re: sort (on part of) string - originally posted under Tricky Sort
- Q. Can I save 2 copies at the once?
- Xpath For Xml Map
- Capture changing cell contents from DDE links
- filter inactive records
- Duplicate Row Removal Solution
- Excel VBA - Need help with a _calculate event
- Looping through charts in a worksheet
- Capture Current Selection in a Combo Box
- Close dialog box
- entering data and updating the list
- Using query from Access
- Inexplicable crash in VBA
- Migrating Lotus 123 (*.123) to Excel 2000
- Tweaking Code - Experts Only!
- Using a MAcro to generate new sheet & Calculation
- VBA to change chart colours
- overwriting a file
- vba crashing
- Declaring a constant to the Workbook Name?
- DDEInitiate hangs
- Cannot Set the Orientation Property of a Pivot Field
- Worksheet Names
- Converting XLA to COM
- Back Up
- reporting directory info into a spreadsheet
- Getting There...Almost!!!
- Find a worksheet
- How to know whether sheet1 contains any data in it?
- Excel to Outlook Small Question
- How to add Tooltip text to Treeview
- Remove transition between sheets
- Hide Code
- Find and export
- Function tests OK but doen't work when called
- Find cells question ?
- Hiding a range prints blank space
- How to delete duplicate entries
- Associating data for auto fill in from dropdown list
- Edit message of a file search to a Cell
- How to use OLEDB and Reserved Chars
- Excel 2000 VBA Help File
- change attributes of numberous textboxes
- Check who's using a file
- Text box physical string length
- Re: Bob Phillips
- VBA Matrix class
- Help to Indentify a drive letter
- Searching for double quote in a string
- Edit Links
- Re: Printing Text from Excel Automation
- Re: Create and Send e-mail using macro
- Re: Printing Text from Excel
- Re: This one has really got me stumped..
- Command bar woe
- [vba] ActiveCell in Online xls document
- Re: Novice debugging a macro error
- Multi Sheet Macro
- Re: Converting Lotus 123 Release 9 to Excel 2002
- Delete Columns based on a condition
- Using a variable as a Row number
- Re: How to change Text
- Re: Sheet Name
- Re: Sheet Name
- Re: Sheet Name
- Re: Converting Lotus 123 Release 9 to Excel 2002
- coding for external download
- Download for external data
- Randon Number Generation - HELP!
- automate regularly recurring entries
- How to create a bar chart from a text file? Help needed please
- Protect and unprotect Pivot table
- Last column?
- file location, defaults
- easy question : textbox
- What data type for Variable?
- Problem with MS Query criteria
- autofill column data
- Performing a second order polynomial linear regression in VBA
- Compare.xla
- Custom Footers
- Refresh Pivot Tables
- relative reference button
- Calendar Control help
- Dynamic Copy/Paste Special Formulas/Paste Special Values
- VBA Code Assistance
- testing file availablity
- check Isnumeric, doesnot work well
- Force code to compile
- Advance Filter critera range
- SQL.REQUEST linking Excel to Oracle - file dsn vs system dsn?
- Disable Combo Box On_Change Macro
- Delete Spreadsheet without Error
- New Line in MsgBox
- how to roll/scroll/log (??) real-time data ?
- Urgent, help needed on range selection!
- Pasting a worksheet function in VBA.
- A question about Counting in VBA
- programming checkbox properties
- Auto selecting the number of rows!
- How to Increment columns
- Help with vb Find
- Appending Text
- Excel to pdf to email
- Excel to pdf to email
- Replacing formula
- How to run a macro many times simpler?
- Replace function with array formula
- how do i move from one column to the next?
- Activecell address
- Command Button
- Color Index
- Populate the sheet with date
- Programming Question
- Close a the current workbook and load another specified workbook
- Did anyone know about "Shell" function?
- DotMatrix printing from Excel
- Macro won't work on other PCs - HELP!
- Inderect.Ext or copy -- Combobox
- How to find out the residing directory of the opened workbook using VBA code ?
- Need help on With statement
- Mail a row to each person in a range?
- need help with With statement
- Auto-generate controls on form
- More than 65,000 rows
- Changing code
- How do I move between sheets in a workbook?
- Thank u Tom Ogilvy
- Excel VBA - How can I extract the hyperlink from a cell
- Help on "With"
- Application.OnTIme
- Send Keys query
- Example: Generating a Range String from numbers.
- picking data
- Help with referencing a .dll
- Currency Formatting to 3 decimal Places
- change a table to 3 columns only (Rows instead of Table)
- Macro to Paste to a Variable Range - HELP
- copy sheet again again
- Running Macro on every sheet in Workbook !!!
- Confused with variable
- Array multiplication?
- refer cell using c
- How To Make a Locked list Automattically Expand
- How do I get the total to show up in dollars?
- excel customised function with help
- Deselect two objects after all selected
- Dynamic variable Reference
- Get Folder Path
- how to access programatically added controls
- Need help trying to open a file and stream data into a sheet...
- UserForm: force to update controlsources
- RE:Listing of one cell controlling the listing of another cell.
- File Search
- checkboxes
- repost: error 'document already opened'
- IF.. Then.. Post to specific cell
- referring by index to adjacent cells
- VBA : get a period - fill cells in calendar?
- Auto macro
- Excel VBA Problem
- Fit to page
- TO DEFINE AMBIGUOUS RANGE !
- How to update a subroutine in another excelsheet with a Macro
- The existing filenames are too long.
- Reset Used Range, Debra Dalgliesh's code
- Excel VBA - Courses in Toronto
- display callout on click
- copyright symbol
- Re: Calendar conrtol issue
- (A repost) Automatic transfer of data between 2 workbooks
- custom function for the day of the week
- Macro autorunning
- Commandbars
- word scrambles
- random text
- random text
- Jump to cell in other worksheet
- #value! when cell is blank
- Macro Button
- Static Variables
- --- Problem, How to do DOCKING WINDOW IN EXCEL !!! ---
- Dynamic range not resized for RowSource usage
- GetOpenFileName bug
- Re: Calendar conrtol issue
- Canceling a print job
- Cell formatting not updating
- Put a CommandBar on the left up corner of a cell
- excel vba loop performance
- Need a method or function
- Code not going to next unused row
- Help! with edit boxes!
- SaveAs Errors
- More SaveAs trouble
- OLEObject on worksheet. Trying to get value from it.
- Using Excel To Dial and Hang Up a phone call
- Sheet code module question
- Text alignment in out look message
- Run other files from Excel
- urgent question: how to calculate value with a string formula
- Managing User Changes
- CREATING GRAPHS
- MSGBOX can be formatted?
- Grand Totals in Pivottables with details
- Combobox in userform
- Userform.show '1004 Error'
- Can i disable the warning when i open the my VBA application
- registry subkeycode
- UserForm Problem
- Append form data to worksheet?
- 2 combobox change vlue
- Simple Question: Hiding a CommandButton
- Launching file in excel not internet explorer
- using decimal numbers in for-next statement
- Control array - does it exist in VBA as in VB?
- Column Autofit Problem
- vba - using multipage
- Sorting
- Delete characters
- empty cells - best way of testing for them
- macro printing question
- Evaluate conditional formatting in code
- Extract data after comparison
- Excel Icon
- Matching Column Entries
- create dialog box within macro and use value chosen
- Set custom ToolBar Position on Excel Loads default to zero value
- Assigning User Names
- Replacing Formula
- FileCopy problem
- Problem with copying chart using VBA
- unload userform from within one of that form's beforeupdate events?
- Splash Screen
- Excel Data Format
- VBA - Loading a certain page when firing up a form
- Can' find error
- Undo not working with macro
- Move to next cell using VBA
- Text font for comments
- Data match using VB script
- visual basic
- Do while empty colomn
- Looping to create Variable Names?
- Shortcut way for indicating comments in block of code.
- Workbook_sheetChange event
- Excluding week-end days/hours
- RE: SendKey Question
- stocks/funds
- Problems calling a procedure in another application
- toolbar buttons
- importing files with a macro
- Writing Range to Array
- printing to a PDF file from xl
- Type mismatch in VBA LinEst function if range too large
- Starting userform
- Calling Excel from C++
- Simple macro - show all data
- recovered_sheet1
- If active cell found in another sheet
- Code Speed Up
- exporting a worksheet for backup
- Menu???
- Excel workbook creation from ASP
- Popup when saving or closing
- Excel/Access connection via ADO
- Excel/Access connection via ADO
- need help with IF statement
- Instancing on Classmodule on Excel 2002
- Selecting all cells
- Increment outer loops
- Find and Delete full row macro (with exceptions)
- Listing ActivePrinters
- Column not copying
- Worksheet name in Macro
- Calendar conrtol issue
- Re: Dynamic validation lists
- Re: save as text
- Import Data from Access via DAO
- Arrays to replace very slow loops ?
- Xml Export Question
- Copy Code From a one excel to other through Macro
- vba doesn't trap errors?
- Select Visible Cells only copy & Paste
- Finding Names associated with a cell
- Is column selected
- Autoshape coding
- Look up problem
- Error while downloading Excel File with macros.
- Writing data back via a userform
- Previewing a form combo box
- Versioning/tracking changes
- Print signature lines as footer
- Fill a listbox with data from variable range
- textbox question
- Fin the most frequently Cell in a Row
- Save changes on Excel Web Pages