- Edit Data Query Programmically?
- Run Time Issue
- Security Issue
- Custom made dialog box
- Format dates and not Zeros
- Protect/Unprotect Sheets
- formula - table - cells
- Merge Cells
- Help creating part of a macro (find Empty column)
- format border by group
- Selection code
- Creating an private Excel.Application
- Last used cell
- Running code from ~? Don't want to use <Ctrl><key>
- sequential cell numbers??
- Return value for Cancel?
- Calling Worksheet SubProcs From Module
- Insert multiple rows
- Shadows with forms
- Extracting Url from a hyperlink
- Using VC++, ODBC Excel Driver: Access specific worksheet?
- Re: Max Memory in a Excel Com DLL
- Select Sheet then Select Range
- Using VBA: Trying to write new solutions ONLY
- assign result of ExecuteExcel4Macro to an array
- optimizing a lookup
- Please recommend a good book for Excel VBA programming.
- Focus problem
- Data/Form
- Quick 'report' - how do I get started ?
- Run Time Issues
- Using VBA to set Headers and Footers with Font and Fontsize parameters
- Click events on charts
- LinEst function
- test
- Conditional Formatting using two formula conditions
- Selecting All AutoShapes on a Worksheet
- PageSetup
- if cell contains formula change background colour to pale yellow
- Macro to Copy/Paste then Paste to Next Line
- Need Macro Modification
- Delete row when zero
- Calculation
- Reversing the order of a chart
- Excel XP won't run XLA properly
- Directing Users?
- Error Handling and For-Next Loops
- program new worksheet
- highlighting rows
- Question about references
- Delete row when zero in column b thru e
- Excel Pivot Table from SQL Server
- VBA codes to determine program installed on PC.
- application defined error
- Form trouble
- Search & Replace
- allowing user to format a protected cell
- Beginner Variable Problem
- XLB File missing
- ComboBox Not "Tappable"
- How do I access XLA functions?
- ActiveCell.PasteSpecial (xlPasteValues) hangs program
- Rowwsourceproblem
- Interrogating format
- Making certain cells editable after protecting the sheet
- Container property
- Restricting save ability of an excel file
- User Name / Computer Name
- Prevent users from running macros
- Set Groups for Custom Grid
- shell to behave in synchronous manner
- Find last col with data
- Variable Name
- Need help creating a case statement
- Excel VBA Progress bar on a userform
- Looping
- MUST BE POSSIBLE !! ..........
- assigning worksheet variable
- What is the {} symbol used for???????
- Deleting Range using VB
- Excel Status Progress Bar
- How to use Listview control
- Looping with logic
- Iteration loop
- Cursor cell selector is displayed again
- activesheet: chart or worksheet?
- Iteration loop
- function on a range
- "Restore" excel functions when error or leaving?
- Last cell
- DELETING FILES FROM A FOLDER WITH SPECIFIC EXTENSION
- Re: Code to Insert a picture using VC++
- Excel displays picture of Britney Spears in a bikini every time I start the application
- BUG????
- Saving Absolute Hyperlinks
- Re: suppressing error message
- Re: suppressing error message
- Pivottables from external sources
- Variable names in SQL
- Thanks
- Stringing Subs
- Run Time Issues
- More Help
- filtered data
- Re: Sort Macro
- Toggle Button
- Passing Strings from UserForm to Module
- Memory Leak
- Questionnaire ?
- Formula needed
- Re: Navigate by macro
- Re: Navigate by macro
- Re: Pause Macro to enter data in cell
- VBA problem importing and auditing Unix reports
- Re: Pause Macro to enter data in cell
- Setting SeriesCollection values in Excel 2000
- Import/Export Excel spreadshee data without MS Excel install
- tic tac toe
- Simple Exit-the-program
- Closing Excel From VB
- Error arising in Windows XP having Excel 2002, was fine in WindowsNT having Excel2000
- Code not working on another comp
- Macro to Paste to specific line, and continue to Paste each time on next row not over
- Worsheet Name Change Based on cell's value
- Web Query in Excel
- Re: Creating COM add-in
- format ='s another cell
- Emailing using VB
- Set Groups for Custom Grid
- Tips on searching and comparing multiple columns on separate sheets.
- Creating a macro to let a user use a keystroke for repeatative information
- On time Event
- format move
- VBA - Formatting issue....
- limit the number of operations of worksheet
- Editing several hyperlinks at once
- Adding a worksheet
- Re: macros
- Drop-Down List to Choose File to Open
- **HELP** VBA code to insert subtotals
- Drop-Down List to Choose File to Open
- Re: macros
- setting address in "mail as attachment" macro
- Save File to Another Directory, but not change Users File Save location
- Auto-run macro after a save-as event
- Reference Row Address
- randomize
- Glolbal Variables Reset when using OleObjects
- macro to select next and rename
- Printing Grouped Sheets
- MsComm32.ocx not registered
- Selection Change Event...
- Array of 100X250 as return of a user defined function?
- automatically advance to next cell without hitting enter or tab
- Row lookup based on a given value in the same row
- run an excelfile/macro automatically
- Prevent "standard" key event in userform
- How do you open a specific worksheet using an Excel Driver?
- Multiple Sorts
- Sorting of values within a list box
- Re: Prevent "standard" key event in userform
- Personal.xls won't open or record any more
- Skip a cell
- Excel to powerpoint
- Re: Help
- How to create a URL and when user clicks it to open a Excel workbook
- capturing mouse positions at any moment
- vba- excel- "for each" what row/col (cell) is it looking at?
- Scrollbar Thumb
- Paste contents of windows clipboard into a vba 2d array?
- Printing Used Range--Method Print Out Failed
- I don't think this is an easy one
- Worksheet copy problem
- Automation Error, Unknown Error. Error value - 440
- Getting list of directories
- Sum Total in a worksheet
- How to acknowledge a message box from VB program?
- Date
- Code not executing
- access to cell values
- multiple looping criteria
- deleting values from a column
- MCSEs
- Vlookup?
- Creating/programming an Excel dynamic graph
- Workbook and Standard Module
- How to get rid..."automatic links"
- Syntax problem with" intersect"
- Calculating Time
- Problem closing Excel
- Joining Columns
- Problem with Macros in VB (2 Parts)
- help needed with macro
- Calculate Time
- Excel 97 and MSWindows XP Home Ed.
- Contents of a cell refer to sheet name
- How to Add an Object to the New Object List in windows 2000
- lookup
- print range based on cell input
- Excel VBA - Varible number rows
- Excel macro to open word mail merge
- David McRitchie/Thanks
- VBA Editor won't run
- Determining chart points at mouse position
- Excel VBA - Best way to indent one column based on another
- VBA
- Search & Replace
- Re: How to detect if a cell is formula
- VB6.0 vs VB6.3
- Formula Help
- Type mismatch
- Macro to enable or visible on specific worksheet only
- Find function very slow, when XLS window is not active
- Is it possible?
- Computer identification using Excel VB
- Calculate hours from 10:00-21:00 format
- get external data
- Scroll to Current Month on Combo box using Data Validation
- another loop question
- Deleteing Duplicate Rows???
- ThisWorkbook.Save not working under Workbook_BeforeSave, Help!
- Doing something wrong - xlVeryHidden
- trying to put a check box in each shell with vba
- Help Needed to Set-Up Changeable Groups for Custom Grid
- Thanks Otto.......Unprotect and re-Protect
- Combining IF statements
- Before "Before Close" help needed!
- How to put the value form cell into the msgbox
- Multiple Condition syntax needed
- Multiple users of file
- Names.Add method
- Named range questions
- Named range questions
- Internet connection?
- Naming a range
- how to read excel spreadsheet into database (DB2)
- Command and pass value to Acces from Excel
- Excel 2000 or 2002, Differences?
- Workbook renaming
- Delete sheet without warning messages
- Enter data depending on Col A
- Welcome Sheet???
- vba code for Pivot Table
- macro for shifting/combining and arranging data
- selection.pastespecial problem
- who can help me???
- simple problem with values in cells
- Does a worksheet exist
- How to create LOG file for commands executed in VB..?
- Urgent...insert values
- Excel VBA -Creating a new file
- Excel macro - Save as with override...
- Get Cell Value while typing
- Tough One: displayalerts = false while OUTSIDE VBA
- Solver and Excel 2003
- Excel in VB
- How do I create a Drop Down List in a cell?
- ThisWorkbook.Path & "\" & .... not WAVFile, but AVI file...
- How to print current data and time to text file
- Encourage users to enable macros
- Sorting of data
- E-Mail File Q
- excel: activitaing a macro upon selection of a cell
- Excel VBA - Insert Word Table problem
- Find the xlstart folder
- Pictrues in Excel
- how to read past news?
- color function
- How to use an array
- Visually check Protection code
- From CheckBox to Cell
- Changing cell color based on its value
- "Find" question
- Excel VBA : Sheet selection
- Entire form is protected - Need help to understand
- Linking Comboboxes
- Need Help Connecting To DB
- New exciting : Infra-Red reader
- logistics of application and procedures
- Goes to A1 on all Worksheets when Opening Q
- general ledger
- Format Function stopped working...
- A question regarding Macros
- Bad Data Somewhere?
- Trying to edit data in other cells from a formula
- find date on other sheet
- Sort Numerically Worksheets via VB when creating a new worksheets
- Updating Header Information via VBA
- right function
- Worksheet_Change does not work
- How can I call a macro in another workbook?
- personal macro workbook
- Code Refinement involving blank cell(s)
- pivottable + chart
- That gives me an error... (it indicates that my else has no If ...)
- Create an Undo
- Editting textbox value that is grouped with a shape
- Execution on opening the workbook.
- EXCEL.exe Error
- Compare first characters in two cells
- Problem with user name and password
- Save as and file exists.
- Seperate column
- Shortcuttext
- Paradox then paste into excel
- Algorithm based on time and date ( =Now() )
- sending email winthin a macro via Excell 2000 under win98
- Calling WinZip from Excel
- Validation from a list
- broken hyperlink when I send email uuing outlook2000
- VBA: copying and inserting a dynamic range
- Excel VBA - Printing filtered records
- save as error message
- IF formula to display a product of a calculation
- Excel 2000 calling functions in C++
- Excel VBA - use of ActiveCell.FormulaR1C1
- Transpose Problem
- Code was working all the time, now sometimes it does and sometimes...
- changing footer before save
- Problem with Pivot Table
- User defined function not recognized
- Problem with clearing cells
- toolbar
- Ubound & Lbound
- Create Global Variables in a module
- Macro Shortcut
- how to delete excel cells that are color-filled?
- Working with line OLE objects
- Get the list of applications which are running
- Issue in date formats
- extract string
- Drag and Drop
- Clean big arrays of data.... HELP !!
- Sort of excel calendar
- Open workbook that is protected with password
- Changing a PivotChart Removes Series Formatting
- Move to a cell referenced from the current cell.
- Macro
- How to subtract many cell areas (between sheets)
- Need Formula Listing Code Modification
- macro cut and paste
- cut and paste
- Combo Boxes
- Macro
- problem with Application.ScreenUpdating
- Goto end of data & select all rows below
- Add one more condition
- Format cell if contains a value
- Date Format Issue
- Macro for updating memberssubscription list annually
- ROBBYN - RE -Code Refinement involving blank cell(s) COULD NOT POST FOLLOWUP
- macro needed for flagging dates due
- cut and paste macros along with lookup
- Setting LinkedCell of individual OptionButton
- Scanning cells to get their value
- ID numbers
- optionbutton in userform
- Re: optionbutton in userform
- SmartTable program
- Saving Procdb.xla on exit from Excel
- Trouble with variable type
- on Calculation event
- chart point value
- Importing data from a Text File, Not enough lines?
- Consolidate Range
- getting values without using "select"
- excel, vba, command button
- Help!! Instead of Conditional Formatting, pull interior color from lookup
- Range Notation for Excel Functions in VBA
- Disable Worksheet Tab Menu
- Automatic Saving
- Re: Execute VB Form from Excel
- List Search Results in a UserForm
- Dynamic Variable Name
- Code to colour Unlocked cells
- excel solver addin
- Say 'YES' to overwrite file
- Close a workbook
- text box percent field
- Enable/Disable Macro
- Printing to PDF using VBA
- Sort macro by same columns
- Subtract 1 from Each Number in Column
- Variant Array
- vba, excel, commandbutton1_click() x,y?
- Setting the value of a cell from a combo box
- Macro problems with range and naming issues
- Importing data from another workbook
- macro to track profit when long
- Average If Macro
- Inventory Workbook - automated entry worksheet???
- Excel automation help...Involves multiple Excel files
- which odbc excel driver is the best?
- Re: Unprotect,refresh then protect again
- Registering an even handler
- Complex numbers
- Doing a calculation, then looping for several of the same calc
- Questions upon opening workbooks
- Use ADO Parameters in loop
- Removing menu bar customization from old XL95 files
- Help with Multiple Excel Sheets
- How to get a macro to start in the right spot!
- Re: Print macro for multiple ranges/sheets
- Multiple rows to one column
- xlVeryHidden Resolution
- What does CTRL-ALT-SHIFT-F4 do?
- Slow Load Help
- Re: Print macro for multiple ranges/sheets
- Moving 1 Data Cell into A second Sheet?
- Create folders on a shared drive with a macro
- Print to Adobe Acrobat (2 ws to one file)
- AutoFilter and Freezing Panes using C# for Excel
- internet data through marco into excel
- Creating ustom toolbar
- Range.Find returns cell outside of range when range set to single cell
- Re: Trying to protect output file with Macro
- Run a macro batch process
- Pause
- To put an automatic " End total " on column Currtotal
- call excel 2003 macro from command line
- Web Query VBA help
- Triggering Verification Function
- Notes on Chart?
- calendar date limits
- Named Range is a formula
- Iterate through the values in a named range?
- how to skip Update Values dialog when links change tonon-existent spreadsheets?
- Run Minimized
- Using multiple conditions
- BeforeSave sub won't save another workbook when triggered by another event sub
- Do this function for each row in worksheet
- Track a Memory Leak
- macro to change repeat row/column print setting
- Dynamic Array
- How to add icons in the Listview control
- Re: SQL fails without breakpoint
- ComErrors
- Urgent - Ctrl-V between sheets, not allow Drag and drop
- Process excel files, suppress alerts
- Array Values
- VBA passing vector from spreadsheet to array
- Message Boxes
- Problem with VBA compatibility - Excel 2003
- Problems opening Access database from Excel VBA
- Variant as matrix
- Textbox focus lost
- macro help needed
- help needed with VB
- Problem with opening an Excel 2000 workbook in Excel 2003
- Screen updating
- ComboBox Exit
- How can I break down text in letters using VBA
- Function
- Unwanted date conversion when opening a workbook
- Case Statement Help
- List Boxes
- copy cells with more then 255 chars...
- Excel 2002 - Slow macros
- How to register an event handler when excel opens
- Enumeration
- Incorrect results of Weekdayname(Weekday... function???
- Re: Problem with VBA compatibility - Excel 2003
- peculiar problem in cell references while merging excel sheets
- test
- Help req Payment via Paypal
- Required fields
- Scheduled Procedures
- Paste Values via VB Q
- Parsing Word document into Excel
- Pivot Table, Consolidating Columns
- Error bar
- Re: SQL fails without breakpoint
- Assigning name to button
- LIstbox Question
- state of option button
- Textbox
- Summing Fields
- Run Time Error 13 in Excel Chart (XP)
- range of cells
- Data Update Form
- Userform
- fill in hour in excel sheet
- Inserting Rows Above Other Rows.
- vb button
- Setting range value to a variable
- Sendkeys will change the status of Numlock
- vb command button
- Cancel button to bypass MsgBox
- Adding Descriptions to Function Parameters
- macro keeps shoving cells aside
- passing variable to file...
- get row and column numbers
- Workbook Open method
- Detecting Save vs SaveAs in BeforeSave
- Deleting rows by name in cell
- VBA-Add Column Totals
- Alternative to Vlookups?
- Re: Finding the Blank Cell
- shapes
- Hiding Part of the VBA Code
- HELP:old format or invalid type library
- listboxs and combo boxes
- PLEASE, PLEASE, PLEASE HELLLLP!!! Excel macro destroying Word toolbars !
- Automatic unlocking and locking worksheet on opening excel
- macro to spellcheck entire workbook
- VBA - Colored Tabs Excel 2000
- Application.goto
- Excel VBA not recognised
- UserForm
- merging ranges
- Excel Macro exporting to MS-Project 2002
- Database Funtions for pulling data
- Re: Preset Display Setting in Auto Open
- Selected cells become deselected?
- Copying Cell Contents throughout spreadsheet
- Import template
- Range doesn't fill
- Re: Preset Display Setting in Auto Open
- Re: Macro Execution Stopped
- In Reverse...
- Code Query
- Strange behaviour in VBA Help
- Excel templates on web
- Memory expanding spreadsheet
- Add Workbook with specific number of worksheets
- Automating Add-In Steps
- Clock how long it takes code to run?
- Combination Determination?
- HELP! Please!
- How do I turn protection on/off with Combo boxes
- Combobox Population
- Re: Optimize RAM Utilization
- Customizing the autofilter dropdown
- print seperatly
- loop through a cell.
- Append Spreadsheets
- Trim path from full filename
- Write a Shortcut to Open Excel Workbook at a Specific Sheet
- Calculations in different countries
- Entering 1 line of data values that will show up in a second Sheet?
- copy and paste
- Re: VBA code to add hyperlinks
- CommandButton Margins
- sending data to com1 port from excel
- Excel VBA formula call in VBA
- Change Event and Calculated cells
- Help Req e mail to sheets
- Getting Data from Web Servers and Application Servers
- Conditional alternating loop
- Chart being trashed after 5th build
- Next without For error
- Sorting a table
- Not receiving all posts
- copy & paste (To: choice)
- Excel Macro Filtered Data in-place: cannot calculate Frequency of Visible Cells
- Re: Program workbook title as the filename
- simple formula to count cells
- Workbook_BeforeClose problem
- Problem with a personnalized function
- Pivot Table Automation Questions
- About PageField
- VBA: saving as with the name of the worksheet
- Re: !!!! A chance of a lifetime !!!
- Re: !!!! A chance of a lifetime !!!
- Select Range using R1C1
- Highlighting a row in grey
- How to undo changes made to Excel sheet programatically
- Advanced sorting in a spreadsheet
- Problem with opening an Excel 2000 workbook in Excel 2003
- vb and excel as datasource
- Re: Update Combobox with New Data
- Pivot Table Page Field Question
- How do I select a whole range and delete the contents of the cells?
- Slow macros cont.....
- Excel 2003 hangs with dates in user forms
- saving workbook with specified filename on the romote server
- openning word
- Error on advanced filter vba excel - 1004
- Editing text file
- Selection the previously selected cell
- how do i incrememnt a cell?
- Toolbar & dynamic filename
- Having a status bar (%completion) displayed while my macro runs
- Date query
- Data,Text to Columns Clean up
- The userform X button
- Excel VBA programmatic validation problem
- Sorting 2 sets of information
- Pivot Tables
- Excel/macro Formula Problem!
- Problem with opening an Excel 2000 workbook in Excel 2003
- How to stop screen blinking when running macro
- How construct a formula from cells with formulas as text?
- Excel VBA to save .xls file as UTF-8 text file
- Change range multiple times
- Help with shortening/cleaning some code please
- Button
- Shell command
- need help with a formule
- Stopping the Update Links Message
- Date looping
- Sharing Files
- Issue with Toolbar Menu
- Yes No Auto-answer?
- Re: Using find range
- Can someone tell me what's wrong with this code please?
- Macro that will always hide / unhide next column
- Exporting Data from Excel to Access Problems
- Increment Alpha Character
- Excel 2002 SP2 VBA 6.3 'RefersTo' Method fails
- Active File name
- Re: TextBox focus
- Excel VBA - UsedRange problem
- Read the contents of the column
- Deleting empty rows
- Script to make my life easier??
- Sheet Protection Identifier
- Macro to merge cells
- Countif with 2 conditions
- "Object variable not set"??
- Slow Excel 2002 VBA on WinXP
- Re: Newbie VBA: How to test second position in a cell?
- Print Dialog Cancel Button
- Worksheet_change event
- Manipulating bits
- Re: TextBox Focus
- Finding an Average based on a Condition
- Decode from URL of hyperlink
- Comparing data based on two columns
- Summing Columns Based On Value
- Re: TextBox Focus
- Creating Ranges
- Excel Macro Weekday / Today Function
- Custom form on opening - I think it's an easy one for the experts
- Password on an E-Mail File via VB
- closing an excel application
- "3" TO MARCH OR "11" TO NOVEMBER
- extract text from a comment
- VBA Action on excel #Reference! error 4?
- macros dont work
- multiple workbooks opening
- using VBA to emulate "validation" drop-down list
- Using "Cells" to write "Range("A:A,H:H").Select"
- Deleting Blank Rows
- Borders question, please
- Macro Help Please
- Easy one- Comman button close
- formula remains as text rather than formula
- Office 2003 v Office 2000 - VBA
- Auto merge files
- Re: How do I set up a macro to repeat automatically in Excel?
- End of Page
- number
- Delete sheet without prompt
- VBA code for Deleting rows by verification
- Combo Boxes Not Changing Independently
- Footer character limit
- Unhiding the worksheet
- Rename active sheet
- Generic Workbook Select
- VBA that recognises the end of a sequence
- Macro - File Save As
- Multiple Userform Hold Data to edit
- Re: How can you turn off screen Redraw
- VBA Array Transfer
- Re: How can you turn off screen Redraw
- Re: Form wont hide
- GetOpenFilename Dialog default path
- Code to hide columns problem
- Using VBA to send email based on form response
- VLookup
- Sending text
- Tracking workbook usage
- VBA and charts
- Using Offset and Match
- using named ranges
- Creating carriage returns in msg or input boxes
- Entering Data in 1 Worksheet to appear in a specific format in Sheet 2
- Highlight found text string in cell?
- Please explain syntax needed
- Excel to Access
- Application level events no longer execute
- run vba automatically
- Passing listindex to worksheet names
- Run quietly
- Dated Fields
- Getting hWnd for API call or Color choosing dialog
- Building a secure add-in
- send email msg
- Save Excel worksheet as Crystal Report
- How do you reset 'change was made in workbook' switch?
- macro for shifting/combining and arranging data
- About PageField (cont't)
- "file available for read/write" message
- Excel Macro Help
- String manipulation from one cell broken up into multiple columns
- Is there a way to create a program in excel to compare files?
- SSTab problems
- ComboBox Scrolling
- Delete a row in an array
- exporting data from a form to a spread sheet
- Finding and replacing characters in Excel
- OLE action error thru automation
- Help writing a macro
- Search Wooksheet
- Arrays
- Out of Memory
- Syntax for WorksheetFunction Match
- Use data from an external sheet.
- Combo Box Query
- substitute strings with variables
- TextBoxes on a Form
- Weeknum-function
- MS Excel: Please help with toolbars/buttons...
- MS Excel: Please help with toolbars/buttons...
- Changing the Name of an Addin and loading worksheets off a network drive
- Link between files with vba
- Printing 2 sided from different worksheets
- please help!!
- Excel VBA - Conditional formatting
- run time error 1004
- Bypassing Worksheet SAVE
- Calling a macro from an IF statement
- how to hide .CSV file extension ?
- mac problem
- Inserting a row after every seven lines
- List box from another sheet with Criterias
- IS THIS A BUG?
- Resume Next doesn't work in IsOpen function
- multiple calcualtion
- Deleting Macros from a Worksheet
- Web query with parameters does not work in Excel 2000 - Please help
- Select a sheet to copy from one workbook to another
- Showing Multiple Sheet Info
- Changing a made up password
- Can't Move Menu with Macros to Another Folder
- Reading a Range
- clipboard
- NEED TO REPEAT ROWS AT THE BOTTOM OF EXCEL SPREAD SHEET
- UDF needs to update cells.
- If this is impossible, just tell me.
- Any ideas why this simple proc. won't work?
- Excel ComboBox mouse scroll
- How would I get every third row to be a specific background color?
- "If" VB Syntaxe
- Run a Database Query within VB
- Multipage control tab font
- Re: Importing data
- Command Button
- RE Any ideas why this simple proc. won't work?