- Using the VLOOKUP function
- Passing a string aray as an argument to a function ?....Help!
- check to see if sheet exists
- If Then to Add Row
- Need a Special Sort Routine
- aligning a form on the screen
- Import and run Macro
- protect add-in after workbook closes
- change Company property
- email shortcut to active workbook as an outlook attachment
- no puedo
- Data Consolidation
- how to remove double quotes?
- Value translation
- Worksheet_Change procedure question
- Listbox Properties totally blank
- web query data post to ASP
- unique values
- Adding a table to an excel form
- HELP, dont know how to describe this in a subject line
- get cell's print sheet number
- Beginner programmer problem
- conditional formatting
- pastespecial
- Run Macro
- Combo Boxes and Tick Boxes
- sugestions
- Preserve Formatting crashing excel
- Calendar Control
- Comment Font Size
- Sheet Formatting
- Paste Problem
- Windows message text font
- Re: OptionButton
- File created with VB is hidden
- textbox not updating when controlsource cell changes
- MDX Query
- Find, Copy, Paste Into Different Workbooks
- Copying files in VB
- Delete row macro/VB
- Autofilling from one sheet to another
- Union across multible worksheets
- Finding an underlined character among several characters in a cell
- placing formula in cells
- Re: OptionButton
- reference to a cell within a string
- How to Rewrite these Code?
- Prevent control & break
- XP activesheet.paste error on VMware servers
- Error# 11004, Unable to set the property error
- Using rng.Value & RefersToRange to pass data between worksheets - SLOW!
- Use variable across workbooks
- Combine .textorproperty and select case
- Edit Excel TextBox using C#
- Query Automatic Refresh
- How to Rewrite these Code?
- Open all files question
- Defined Name
- how can i retieve stock data in an excel worksheet?
- Excell FileOPenDialog from another App, and listbox multiselect problems
- VB Programming, trying to save as lower version
- Access to Excel Automation ADODB Problem
- How to Rewrite these Code?
- Search and Replace With Formatted Text
- Date
- How to cycle through a series of similar objects with a for-next loop?
- Add-In
- Query on the Use of Absolute References
- password protecting macros
- Copying Worksheets
- html markup to add comments to excel cell
- ComboBox, referring to content
- Copying Worksheets
- Worksheet_change Target Address is Reference Cell
- VB vs VBA ??
- Hox to control Comment Shape Sizes?
- Using the sum function with a blank total
- Problem in setting Cell Interior Color filling.
- Random Sorting
- Worksheet_change Target Address is Reference Cell
- change colour on value, 4+ colors
- Searching a range and copying values into a new range.... **Please help** :(
- Check File Name before Save Event
- Active printer
- Worksheet code if-color-statement
- How to Rewrite these Code?
- Word from Excel
- Worksheet_change Target Address is Reference Cell
- Convert no. to time
- problem Excel VB Macros
- saveCopyAs
- Dynamic controls
- Work sheet function -average
- VBA Array Formulae
- Function to display a cell containing an underlined number
- Determining path to document template
- screen updating
- On entry
- "unexpected error" when running solver from a macro
- How to use macro?
- Macro Toolbar Button
- Convert no. to time
- Changing colors
- strange behavoir
- Excel2003 and xlListSeparator...
- Autofilter Multiple Criteria
- textbox formatting
- Auto fill
- Union Method with multiple worksheets
- auto pivot tables and charts ?
- How to use macro to run excel, word, powerpoint, outlook, IE, etc?
- Search and Replace With Formatted Text
- Time-interval protection
- How to check if cell contents overflow.
- Detect which UDF params was chnaged
- VBA Functions acrosss multiple version
- Click-event question
- Pass Version of Excel to a variable
- as that was so easy...
- Help Please with Error 91message
- Use macro to check a range of cells within a row and copy wanted data to new sheet
- Starting a macro based on cell value
- Defined Names revisited
- Is Workbook read-only because of file permission or because file is already opened?
- Macros
- Autofilter Multiple Criteria
- Excel automation in VB.net
- Code to change the color of "Rectangle21_Click"
- Use macro to check a range of cells within a row and copy wanted data to new sheet
- Use macro to check a range of cells within a row and copy wanted data to new sheet
- Disable/Protect Cells based on If
- Pass Version of Excel to a variable
- change colour on value, 4+ colors
- Using formula to extract info
- Method to pause VBA?
- I need a simple excel formula
- IFBlank Formula
- How to modify excel setting using VB.Net
- .NET component won't show up in toolbar or menu
- VBA and F2 programming question
- URGENT! check if cell has only ALPHA chars
- empty cell?
- blank cell
- Extract char from multicells to build new in another
- Prevent user disabling events
- Excel Macro/Assembly i created in C# wont load on End user compute
- deleting worksheet code in generated workbooks
- VBA and F2 programming question
- Reference to sheet name in addIn
- Transpose Range
- camera tool causes drastic slow down of macros
- Range("A1") Question
- User initiated break/actions during macro execution
- Need help with empty cell in Macro
- Problem with formula in cell
- Executing code based on changes made to a form ?
- Paste Command
- Query results to message box
- HELP! cell validate
- Re: pesty "Compile Error!"
- Method to pause VBA?
- Drag and Drop between ListBoxes and Excel cells
- Extract Number with zero
- Drag and Drop with Charts
- Query Results to UserForm
- Creating list of sheet names
- C++ and Excel : Need Simple Charting Example (I can populate sheet with Data)
- how to get a macro to run when the file opens
- Re: pesty "Compile Error!"
- Disable Message Prompt in VBA
- Problem Recording Macros in Excel
- subtotals in a protected worksheet
- Creating list of sheet names
- How do I create minimize and restore buttons on a user form
- to: Tom Ogilvy (Find and transfere values)
- Delete Empty Rows @ End of Template
- GETPIVOTDATA
- Filling cells
- Reference to Office 11.0 Object Library
- copying entire column
- Unable to read file
- Trying to delete macro -- 'reference is not valid'
- excel macro
- Trying to delete macro -- 'reference is not valid'
- Re: pesty "Compile Error!"
- Trying to delete macro -- 'reference is not valid'
- Open current database method
- formulas after insert row
- xOut
- vba checkbox
- Disable Control in Tools Menu
- Default path
- Why ask for a password?
- Using Add ins for files downloadable through web
- Combo Boxes and Tick Boxes
- Make a Change to Code
- Filename Function
- How can I have a macros automatically run when I open up the file.
- accessing custom document properties without loading file
- E Mail from Excel using a command botton
- Anyone know of a Solver tutorial?
- Pasting formula with defined name
- Print some Sheets
- InputBox Function & Cancel
- syntax help
- Max of integer vals
- Extract Cell Comments?
- Change named range value
- recvery msg and excel shut down
- Activate/Select Problems
- Moving between a cell that is selected to include a range of cells in that row
- Just Curious
- Testing for Cell Validation
- Cell Manipulation
- Average
- Toggle datafield in Pivottable
- Add 2 more criteria's
- Performing codes on different worksheets
- variable in excel
- Cell Manipulation
- UDF, Array function, vertical output
- Text to columns -- reset delimiters, etc
- Excel compiler and Excel password
- strange prob: file not getting closed after vlookup
- Can you help with the correct translation of this code?
- Click event to run only once
- To: Harald Staff with Rgds to Your Code
- Issue in Cell Value Alignment
- Validating data in a spreadsheet control
- Validating data in a spreadsheet control
- Need func to display a cell + formatting in another cell
- Open Helpfile from Excel VBA or hyperlink
- Excel 2002 - 2 problems
- how clear up this problem
- Copying from excel to txt + formatting.
- VBA in Excel: How to keep relevant rows only?
- Error 1004 when pasting - Hair pulling time
- Change Cell Colour
- Workbook
- formatting the view of a worksheet
- reading data from com port into 2 different cell locations.
- Problem with Looping and Output
- Highlight row
- solver constrains in macro
- If Condition
- .Find method not working???
- Array selection stopped working???
- First text box in form not working right
- using For each loop to populate a range
- Get cell's print sheet #
- VBA to select multiple columns
- vlookup with VBA
- Error only without references
- How do I override a deletion box?
- Semicolon problem
- Protection
- OLAP Reports
- cell protection
- Cell Reference
- Data validation question
- Print Userform?
- Print Userform???
- Max of integer vals
- Semicolon problem
- Inserting column headers
- Deleting a row based on the value in column A
- coding worksheets for undesired selections
- dynamic chart
- statement to Exit Do if empty row
- Web Query Changes Format to Scientific in Excel
- Saving an Embedded Excel Sheet in OLE Control
- Macro , Unprotect-Protect -- Atten: Tom Ogilvy
- VB Code to Delete Unused Rows
- Bolding
- Printing a Word document from an excel macro
- Printing a Word document from an excel macro
- VB.Net to Execll
- How to unload a form in excel vba?
- Error 1004 Application Defined or Object Defined Error
- Alternative to send mail
- Progress Bar
- positioning a comment
- sequential number based another cell
- how is the syntax to replace a date, recorded within a macro with a cell value ?
- Semicolon problem
- Equlivelent to .NewIndex Property in VBA Excel ?
- Download
- Report Headings
- Column listed as "Number Stored as Text" - Exported from Access
- Exporting to Navision
- Application.Dialogs(xlDialogFormulaFind).....HELP!!!!!!
- Marco Run on File Close
- How to disable autoopen() programmatically
- password protect vba code
- how to place formula to cell
- "Status" indicators
- Check variance code not working
- Adding to Dates
- Converting 9/30/04 16:30 to minutes only
- Extract Number without quotation marks
- Printing same page twice with a subtle change
- Need help with printing macro
- Macros to run on a timer
- MsgBox formatting
- disable conditional formatting
- Can this work???
- Little help with merged cells
- Minimal Excel UI
- Trim spaces on both sides
- Excel Macro
- webb visitor list - any methods to convert search engines query strings?
- How do I test for the first character
- Anyone know of a Solver tutorial?
- Forcing Save As: dialog box
- Copy a file into multiple dub-folders
- Printing Word Document using Excel Programming hangs Word
- Converting Text files to Excel sheets with specific formatting
- Creating VB OCX that uses MS Excel, but not always
- Delete all files within a folder (incl subfolders)
- Linking Combo Boxes
- Check variance code not working
- Close Workbook After 10 Minutes
- Printing same page twice with a subtle change
- How do I test for the first character
- can I call a worksheet function from within vba?
- unique values
- Using a Custom Function - determining the row that called it
- Switch to worksheet view
- Printing same page twice with a subtle change
- Help with Form function macro
- problem with beforeclose event
- How do I automatically import CSV data on startup
- Which rows contain certain text?
- Help with a macro.
- How do I test for the first character
- MakeTable of Contents with VBA
- how may I copy color of a other cell
- Problems with ADODB
- need code to insert cell value
- problem with vlookup
- What is exel formula for future value of savings using constant i.
- how do I get the current cursor position in a spreedsheet
- Need code to insert cell value
- Input Box - UPPERCASE lowercase
- How do I test for the first character
- Worksheet_Change procedure question
- Click event to run only once
- VBA new function doesn't execute
- Excel VBA - open text file, replace text, save file?
- Close without "Do you want to save changes" prompt
- how to return the value of a cell based on two criterias in two columns
- macro to filter sheets
- unique entries code
- Filter/copy based on criteria
- how to return the value of a cell based on two criterias in two columns
- Moce rows with N in Col A to a new sheet
- Comparing two workbooks
- Guru Help Needed
- How to find speicial cell using macro
- Need help killing a remote Excel
- Conditional Formatting Forumla
- 2003 Excel VBA on XP runs very slow vs Win/Office 2000 - why?
- ADO Recordset to Text File
- stop code execution with button
- Using an array to select data
- List all comments in a workbook, by sheet and cell
- printer selection
- filter on pivot table grand total
- How to obtain sum of odd numbered column
- Combobox & Display
- Printing several worksheets as _one_ print job
- about more controls of a form
- Excel doesn't allow comments to be copied
- scroll bars in userforms
- PivotTable programming help
- Error in Copying and pasting data
- Values from bold cells to combobox?
- format caption
- Running cade on new file from template
- PivotTable
- Excel macro
- Open File Variables
- Search
- assign variable
- Accessing Mutiple TextBoxes
- Summing
- Sorting regardless of whether a value is positive or negative
- how is the syntax to replace a date, recorded within a macro with a cell value ?
- Remove letters from a cell
- 0x800A03EC, asp and excel export
- Inline Carriage Return?
- How do I keep a running total of time?
- PDF FILE CONVERSION
- User Input to open multiple files
- Custom View - TEASER
- MSForm 1 - Initial placement of form
- Anyone see the prob in this code?
- IMMEDIATE window
- End of previous month
- MSForm 2 - Creating labels and text boxes at run time
- Is a sheet a worksheet?
- Link Formulas
- Accessing Mutiple TextBoxes
- Anyone see the prob in this code?
- Four digit numbers need to be split up
- Deleting Rows
- program control
- Clean up code.
- RT Error 1004, Select method of worksheet class failed
- Deleting Rows
- Auto Close Grouped columns
- Number to Time
- Newbie, msgbox
- Object error on an Option Button
- Excel 2003 - 'CopyFromRecordset' Error
- Pivot Table Error 1004
- Reformat Borders of Cells in Selection - an example
- Run Auto Close when Excel Closes
- Sheet Name Character String
- Help creating a shortcut key.
- Coverting dates
- Four digit numbers need to be split up
- How to add images to a Combobox.
- Accessing Mutiple TextBoxes
- RangeExclude function
- How do I test for the first character
- VBA new function doesn't execute
- VBA and F2 programming question
- Import Picture from disk...
- Macro to bypass password pop up alert
- Excel 2003 won't fire Excel 2000 Macro
- Macro for comparing two spreadsheets
- Run time error 13
- A question about textboxes
- run time error 13
- renaming worksheets with a macro
- Add contents of A1 in all workbooks within a folder
- Remove part of string
- A question about textboxes
- Subtracting Dates in TextBoxes
- sockets in vba
- Search and replace
- skipping pop up box for saving changes when closing a file
- VBA new function doesn't execute
- Date spilt into four cells
- Ending Sub
- Making macro functions invisible?
- Auto Close Grouped columns
- Pasting records into Excel with QueryTables
- Send a String to a Web-Browser Window Using Macros
- How do I automatically import CSV data on startup
- copy multiple unkowns
- select all arrows or lines on active worksheet - an example
- chart in userform
- Serial port interface
- Zero Decimal Places
- How do I automatically import CSV data on startup
- Macro to open other applications
- changing cell format from number to percentage
- Sub, module??
- Autorun a code when any cell is changed in a range
- New Range containing Unique names only
- Using IF in a macro
- Automatically close a userform
- stop execution
- Office Object Libraries
- Unable Export Data to Excel on Win 2000 Server
- Automatically close a userform
- Finding A Desciption In Another Book
- Macro or addin for changing Number to words
- Automatically close a userform
- Help with IF
- Automation error -2147417848 on windows 98 while using excel in VB ( works fine in XP)
- How Do I Detect An Entry In A Range Of Cells
- Learning VBA Which Book?
- (new to the group) importing data into excel and printing
- Help with a Form function please
- difference between comm control on win 98 versus windows xp
- DAO Recordset in Excel
- Daily Analysis Report, Charts do not update Automatically.
- Using Ranges to input variables to UDF
- On Close Macro - stop warning message
- Help with a macro
- Macro that stops at a mid point occasionally
- format cells with ### as number, then convert to string showing date.
- Edit this macro
- Query Hungs up Excel
- validation
- fmMousePointerHourGlass not working
- AppActivate & Internet Explorer file download
- not getting the "assign macro" shortcut
- Chart Title as a Cell in a worksheet
- Can excel remove the duplicate rows in a spread sheet?
- date cell from lotus is not working
- Simple userform help
- retrieve and update data from a dbf file
- input data from 3 workbooks into a fourth
- Edit this macro
- Advanced Filter Range Selection in VB
- Advanced Filter Range Selection in VB
- Define Name Truncates Formula?
- Solution for ComboBox Code
- Function/Procedure dependence & order of execution
- Problem copying checkbox values
- Using a Macro to Sum a Variable-Length Range (a Column)
- Allow formula access to the row/column information in the Name Box
- different workbooks
- Provide increment and decrement buttons on toolbar line
- Re: Naming of MsgBox Buttons
- is there a hotel management excel app.?
- Modified VB Code for Converting Number to Text
- Copying from one SHEET to onother with the condition...
- HOW I CAN CONVERT NUMERICAL INTO WORDS IN CELL
- Find the largest number
- ActiveX Controls loose left position after printing/preview
- Vba and excel, userform help
- Strange looping behaviour and Error 400
- How to check if cell value is displayed as hashes?
- Printing A Chart
- Updating records in another workbook
- variable scoping - constants going out of scope - circular references
- retrieve data
- referring to columns/cells using numbers
- Help with Code
- Function Help
- Function Help
- Calculating the difference between hours
- looking at a cell before reffering to a table
- Calculating the difference between hours
- Application defined or Object defined error
- Splash screen and various screen resolutions
- looking at a cell before reffering to a table
- Wish to apply "Save Preview Picture" in 300 files.
- Hide all menubars even 'Worksheet Menu Bar'
- Modified VB Code for Converting Number to Text
- Using a Macro to Sum a Variable-Length Range (a Column)
- Continuing Difficulties W/ Sum For Variable-length Column
- How Do I program Excel to Source a Database
- How do I create a logfile
- Automated sheet copying and naming
- Continuing Difficulties W/ Sum For Variable-length Column
- Focus sheet
- Sending Personal.xls Files To Multiple Users
- Naming of MsgBox Buttons
- VBA Macro Assistance (I am desperate)
- Continuing Difficulties W/ Sum For Variable-length Column
- Unprotecting a Sheet
- Application.OperatingSystem Unix
- highlighting cells if value is repeated
- Re: Learn French in the Alps.
- highlighting cells if value is repeated
- Many spreadsheets to one with many tabsheets
- Find Extents of Data
- converting fractions less than 1
- comparing data in different workbooks
- EXCEL HEL URGENT
- Path
- Worksheet events
- Path
- Change Cell from Validated List Not Firing Worksheet Change Event
- Help with a macro
- VLOOKUP into a closed xls using VBA
- Close a MsgBox
- Excel - how can i reference a table using vlookup?
- Close Dialog Box with SendKeys
- Continuing Difficulties W/ Sum For Variable-length Column
- Defined name range
- Average For Variable-length Column (w N/A value inside)
- Unprotect worksheet error
- Average For Variable-length Column (w N/A value inside)
- Defined name range
- Urgent Help needed - On Formating a page
- Using a Macro to Sum a Variable-Length Range (a Column)
- >> Updating Links
- Printing part of userform
- Protected Shared Workbook
- Option Button->Format Control->Cell Link...
- VBA Macro Assistance (I am desperate)
- Converting cells to data file
- macro with checkbox(i)
- Removing all Toolbars in one line
- Accessing Mutiple TextBoxes
- Get a value from a table in an HTML document
- Tausendertrennzeichen
- Not a valid Add-in - Error Message
- Locked VBAproject due to macro fault????
- Locked VBAproject due to macro fault????
- splitting names & email add.
- Disabling Macro-Virus check
- Create an EXE file.
- Disabling Macro-Virus check
- macro names not consistent?
- dropdown list in an excel web page
- Sorter macro
- Limit working area of a sheet
- Locked VBAproject due to macro fault????
- Remove missing reference programmatically
- VBA Sub procedures
- textbox in a macro
- for each loops
- range value with variable not working?
- Disabling Macro-Virus check
- Mouse scroll in user form list
- Get data for only last three months
- Macro Help
- Calculating the difference between hours
- Date problem
- Get data for only last three months
- savecopyas question
- Getting dw20.exe error while openning excel formatted xml file
- Calculating the difference between hours
- Conditional Formatting in a Loop
- Get data for only last three months
- Assigning the Help 4, *.HLP file for a project programmatically in a protected Project
- copy multiple unkowns
- Check variance code not working
- Linking Button to a cell
- Calculating the difference between hours
- Looking for network-username with Excel macro
- Delimiters recognized by ADO for Text Files
- Formatting Questions
- Error while oppening xml(excel compatible) using workbooks.open me
- Error following Microsoft Article
- Re: Concatenate Textbx(s) Content HELP
- How to referance a GroupName
- Pivot linked to large Access DB...help!
- Calculating the difference between hours
- Drawing on userforms
- Newbie VBA questions
- Insert rows in depending on criteria in variable columns
- run macro in VBA code
- Calculating the difference between hours
- identify currency and do sum
- Grouping Cells
- Hide Tab in TabSheet on UserForm
- Linking Button to a cell
- Comment for ComboBox & Command Button
- Macro execution from Excel IF function
- Code Livelinks - Please help!
- "save changes pop up"
- selecting a file automatically
- Filling command button with image
- Adding a command button
- Open only existing Excel Files in a given Range
- VBA - MS VB Compile Error
- Re: Concatenate Textbx(s) Content HELP
- Moving to another cell
- help with Pivot table
- Moving to another cell
- creating database from excel spreadsheet
- moving table to next page
- VBA - MS VB Compile Error
- Date Comparison in Code
- Autofit
- Copy Excel Spreadsheet formula to a range via VB6
- Rounding Entries From Range to Array
- RP - Add contents of cell A1 in all workbooks within a folder
- VBA - MS VB Compile Error
- Directory Browse/Search information
- creating database from excel spreadsheet
- Use variabel as reference
- File Reference
- list box
- VBA - MS VB Compile Error
- Excel VBA printing to MS Word cause MS Word to crash, why?
- Events, Class, Time Editing
- Saving to Text problems
- Manuals
- Looping thru a range - storing IF not blank?
- can it be done without notice?
- Identifying Pivot Table's Field
- Worksheet events
- How do I modify a SQL connection string in an xlt file from a VB6 app?
- Date Comparison in Code
- Re: Excel Window Zoom Problems
- GetObject function
- system error when inserting UserForms
- Excel Filesize
- multiple versions of Office references
- Open only existing Excel Files in a given Range
- Automatically Parsing Fixed-width Text Import
- Code to change interior colour only if current interior colour is
- How do I publish a Excel chart using vba macro?
- Click event to run only once
- Drop Down List in Inputbox
- Filter/copy based on criteria
- Hi,
- auto save on exit while at the same time rename workbook...
- Getting values from a variable sized range into an array
- Drop Down List in Inputbox
- Help With Autofill
- Must be better way...Using Listbox Selection to Query Data
- can it be done without notice
- Using a Macro to Sum a Variable-Length Range (a Column)
- Ungroup Sheets
- Continuing Difficulties W/ Sum For Variable-length Column
- How do I link a .xls invoice to an access database?
- How Do I assign a numeric value to a text entry?
- Problem with Excel plug-in
- First Aid For Macros
- Chart links for copied sheets
- Continuing Difficulties W/ Sum For Variable-length Column
- Hide rows when quantity is zero
- Accessing a non-active sheet from a userform
- First Aid For Macros
- Using a Macro to Sum a Variable-Length Range (a Column)
- Concatenate
- more than just conditional formatting
- Get data for only last three months
- update a txt file if dta is new
- Inter-program communication using SendKeys
- How to make a list of all shortcut keys
- Scrollbar Change event
- Scrollbar Change event
- Add scrollbar control
- Using a range with SUMIF
- If statement and Macros
- Sorting a column regardless of whether a value if + or -
- Sorting a value based upon the values that appear in row A
- Insert code by code
- How to record a sheet change showing row column sheet name and date?
- Sorting by date
- inputbox function
- Catching NewSheet-Event in another WorkBook
- Make code more economical
- Excel Library
- Re: Sorting by date
- Any quicker ideas?
- Random Draw
- Sorting by date
- How to record a sheet change showing row column sheet name and date?
- Sorter macro
- Excel Cell Select
- Sorting based on a cell
- Excel Cell Select
- Excel Cell Select
- Moving to another cell
- inputbox function
- Sorting based on a cell
- Usage of Find function in excel
- automatically insert rows
- On close and before save events.
- MoveAfterReturn is tricking me.
- Closing file and excel
- Get data for only last three months
- Macro Design Help
- Auto ReCalc
- excel vba
- MATCH values on a subtotalled worksheet