- Connecting to databse
- How many sheets in a workbook
- xls file exists in my web
- got error message "unable to set the ColorIndex..."
- Deleting Dates
- Custom Report Manager Tip 249
- Editing a formula to make references absolute
- Linking a form button to a worksheet with a condition statement
- Controlling focus on speperate form
- Perform various actions before exiting
- Code to Open internet link
- autofilter in VBA
- Resuming after Error
- Can you stop the Trim function translating hyphenated cells into date format?
- digital signature
- Macro to replace shorthand fields with data from another table?
- Opening a new workbook and ...
- Tagging Changed Values in Linked Cells
- formula code
- Taking values from a cell to use in a macro
- Data Criteria
- Hide UserForm when Successful
- Drop Down "GOTO"
- Copy color palette with macro
- Macro Buttons
- Progressive filtering
- VB Question - Cell value from multi worksheets
- Variables in Formula
- running macros
- Detect if cell is in 'editing' mode
- Schedule Macro
- Calling macro of the others worksheet
- macro to work for variable number of rows
- Sorting
- Copying columns from one workbook to another
- Store array contents in single cell
- macro to delete specific rows
- Protect Sheet is Protecting Workbook
- Runtime Error '9'
- scheduling
- Autoclose Timing Issues
- Looking for a way to increase data input efficiency
- macro question: pasting to a row, then the next, etc
- Adding a payment based on 2 values
- Replacing Text
- Need to autofill down to the last row
- COUNTA Function in VBA
- Macro Printing Question
- timezone calculation
- create separate files from master
- "Grey out" Combobox
- Run time error '53'
- Do not create separate emails - concatenate in one
- Compare Rows in 2 columns and count those that differ
- How ro remove text from a cell
- lookup cell reference
- Range Selection
- Answer on another Forum - Web Query Event
- Rename picture object
- Unknown files Names
- Macro
- VBA code
- Count the cells by color
- Extracting data from database
- How to Recover Complex Excel/VBA File
- Opening a text file into Excel
- assigning range to a range via VBA
- Is VBA on the out?
- Button Caption
- Checking for pics & deleting pics in Excel worksheet
- How to reset all controls (Drop Down list on a sheet)
- Hide sheet VBA code
- Macro to save file in a specified directory and name
- Eliminate Text-To-Columns Prompt
- Formula gives error but is accepted after clicking on it and pressing enter
- Hide Check Box and Row
- Showing 2 Userfroms at same time
- why does the macro crushing
- Run Macro Automatically on Open
- Delete Macro
- vlookup and then adding result
- macro validation
- Save one sheet, no macros
- To detect the last row of used area
- 1004 Select Method Of Range Class Failed
- Disappeared Thread ?
- Macro to auto-email separate worksheets of same workbook to separate recipients?
- command button to send email
- How to set the position of a active cell and clear the contents of the cells
- Running a macro on activation
- Shelling to email
- matching data - vba required?
- Showing pivot table selection criteria for printing?
- 2 Related Questions: Finding Value Recalling Other values based on that
- Formating a Range
- Cell Holders
- Populate dates by selected month
- Find, Copy & Paste two Columns at once
- Disabling "Save as"
- Averaging formula
- ListBox or ComboBox - which to use??
- Before close event
- Moving to next Row
- Move sheet and save as cell value
- Deleting A Workbook
- Suppress automatic save ?
- Suppressing / displaying multiple charts
- Locking / Protecting Excel Options (Menu Bar)
- Datafields disappear in PIVOT table
- Copying worksheets with macros
- Comment Box Shape.
- Find the Last number in a column
- automated code for handling events in a dynamically created sheet -- possible?
- Using VBA to move rows to another sheet, faster way?
- Copy Data
- Drop Down Menu IN a Pop-Up Box
- Constant Monitoring
- Why is my UserForm Pausing Procedure?
- Copy selected cells to multiple worhsheets
- Scaling charts using a VBA variable
- Prevent save prompt
- Macros crash after 1st use
- For type loop verse Do type loop
- Unprotecting VBA editor
- creating a proposal page
- Importing Text File - How to Use Specific Filter
- How to stop SaveAs command triggering Change_Events?
- Listbox - multiselectmulti properties
- If x=x then do Y, if not, do Z.
- Date Part
- Display the data of Sqlserver200 according to column
- Cell Reference of GetPivotData
- Populate form from dropdown list
- finding largest value
- msgbox displaying time passed since last save
- Find in range
- Relative path name
- Does Worksheet Have To Be Opened To Use Set
- copying to new sheet if on same team
- Esc to clear Sheet
- Macro for Comparing two spreadsheets
- Auto Unhide Worksheet
- Print Macro
- Combobox linked cell format problem
- A dialog stops my macro
- Return focus to a text box.
- Check the row location
- Very Big size for EXCEL file
- Can you use the Replace function to remove carriage returns?
- Get username
- Excel/Access automation question
- Avoid #!REF
- Make Called Macro End the First Macro
- looking up working days
- formating cell
- XlcalculationManual
- lastrow.offset from specific cells
- Stop all macro's
- Loop command until blank row
- Sort Problem
- Drop Down Chart to Run a Graph Macro
- how to force end an excel application
- How to allow multiple entries from a Password InputBox
- Reference a formula from code
- Adding Control to a Dynamic Listbox
- Insert a listbox in a sheet
- Search UserForm After Enter, not click.
- unicode "\u" needs to be replaced and ";" added
- Auto increase # based on other cell
- Give the same name to cells in different works sheets
- add-in dependent library path lookup
- Date Variable - Clearing the Value
- Counting outputting Unique Values
- Posted on another forum >> Disable "Select Sheet" Dialog box
- Text to columns - First Instance of =
- Using Cell contents as Path
- Date Format in UserForm
- Factorials
- Programming so text isn't allowed
- AutoFill Method of Range Class Failed
- Working with Hidden Rows
- values in userform text box.
- Coding for Input Box Search ...
- USe of wildcards in macros
- 14 Most Current Dates
- This formula is a thorn in my side
- Macro
- Debugging Date in Code
- Display a message when worksheet is active
- Vlookup and data transfer
- Optimizing a large data web query
- Worksheets to new workbook in VBA
- Resource Available Error Message
- getting the latest transaction
- Can you modify one macro with another
- Can you rename a Module
- Match and Organize
- Capturing Row Number
- Run-time error '1004'
- Using an InputBox to populate a cell
- How to Call Selection_Change Event?
- Detect Hidding Event ?
- Open Userform when you close a spreadsheet
- Deleting standard toolbbar button for EXCEL 2007 Add-in
- Set Variable = Cell From Another Workbook
- Macro magic trick
- ComboBox
- How to create a command button and assign code to it using VBA?
- colorindex make a color a number
- Order numbers
- Header = Cell Date
- Matching cells
- Closing workbooks
- userforms
- Printing multiply workbooks.
- Creating a Catalog from a list
- Opening a Sheet Based on a Cell's Value
- TextBox
- format variable
- Clean Up My Coding
- Paste in a TextBox using a macro
- Unexpected Results with CurrentRegion
- VBA code for Formatting
- conditional formating
- Detect Negative numbers
- Remove Toolbars
- macro with dynamic web query running slow
- Time Zones
- How to execute a macro everytime ENTER key is pressed
- Insert formula in cell
- Creating Macro to work with outlook??
- Prevent alert messages with webqueries
- Need a find and delete macro
- Customer Listing
- Using Inputbox data in a macro
- Delete macro after running
- sorting issue
- User form retrieve data
- Form closing Excel program?
- Sheet name
- Data Validation code
- Microsoft will no longer support VBA in next Office
- macro mistake
- formatting in a macro
- paste from workbook to workbook
- Function and Personal.xls
- Importing cellreference into VBA
- Macro Distribution
- Run Time Error 1004, Pivot table
- Updating cell references...