- Delay Macro
- Q: Getting average of simulated die rolls?
- Scroll with mouse wheel on userform
- looking up data
- date validation
- Creating a Dynamic Bar Chart in Excel
- Getting external(web page) data from Excel sheet
- Start macro only when a certain cell is changed
- Delete blank sheets
- Reading from Excel Files
- Problems Using VBA recorder to autofill
- Find first empty cell
- Add in on Terminal Server
- How do I lock cells when it has value using macro?
- ComboBox selection activate sub
- User Defined Function (UDF) in a shared workbook
- Very basic macro question (find and append)
- List Box Issues
- SQL statement problem
- Newby to using VB in Excel
- Mod Ron's Code
- TextBox.SetFocus not working
- Regarding setting the age
- Copy rows in a split way
- find next available cell
- Combobox in userform
- Combobox column width
- Help with date
- Calculating Yesterday's Date
- While Loop not compiling
- My Function, Suggestion/Comments?
- Querying an Excel File
- Select Case Repetition
- Inserting on Line, Alphabetically
- VBA Form
- color fill rows?
- formula..If AND statement
- String Format problem
- Conditional Change of Font Size
- Skipping System Messages
- using find in code
- Copy Forms (combo boxes & checkboxes) down many cells & auto. increment cell links
- VBA code compiling problem...
- Detect autofilter status
- Macro/ Access conversion from Excel
- Selectiong rows
- activity complete macro
- Macro to modify embedded charts
- VBA Beginner
- Reformatting Macro
- Prevent Duplicate Entries
- Replace content of cells
- Formula to find most recent column of data
- Conditional dropdown lists
- Automatic Hyperlink
- running macros in shared workbooks
- Filter, then copy
- Count number of cells with different entries
- button to run a macro
- MOD function problem
- Sorting the Data and Saving an Excel file before ftping it to UNIX server
- workbook.open question
- Worksheet Detection
- Fare Share Distribution Algorithm
- Choosing a printer
- Macro to Update a Specific Link
- Openrowset to Excel Problem!!!
- Conditionally Colored US map
- automatically copying data to history...
- Lock Cell Variable so it will only accept integers
- VBA required!?
- Number Macro
- Why does my XLA save as 2.88MB?
- Autorun marco based on date
- Debug problem when highlighting?
- Create a list from a schedule?
- How change information in a cell?
- importing multiple text files into a single excel spreadsheet
- Looping Sum, If cell begins With
- VBA Code to Refresh Pivots on multiple Sheets in a Workbook
- Copying rows which satisfies a filtering condition
- Run macro based on drop down selection
- Circular reference in my code
- macro to count instances in cells
- Summing a Column in VBA
- Copying an unknown number of cells in Sheet1 to Sheet2 starting from "F2"
- ESSBASE Retrieval using VBA
- Nonlinear interpolation?
- Selecting a discontinuous range in VBA
- IF statements
- Excel and Word interface Problem
- Date Problem
- select next row down
- Changing the Pivot Table values
- Change cell color dependand on cell value
- Macros
- Macro per drop down menu
- Can anyone please help me?
- Referring to a userform control
- transferring variables across sub's
- Populating cells from Listbox
- SaveCopyAs - holding onto file handle
- property method listing after dot
- Copying a column in Worksheet A into Worksheet B
- Pivot table result with hyperlinks
- range pivottable
- Delete rows based on specific criteria
- sort
- referring to a column by letter, not number
- need help with auto import
- SheetChange Event
- Clear Cell Contents
- Search Data sheet:
- trap CRTL dbl-click?
- Incomplete Range
- Sorting on a Protected Sheet
- Creating random values in a range using offset
- Macro for counting occurances of a name
- Creating a drop down auto filter
- VBA code to reverse a highlighted list
- dates
- Cell link to Chart Category X Axis
- Adding different value to existing chart
- Copy workssheet
- Save As prompt
- Selecting a range using numbers not letters
- Lookup? Match?
- Ping a host and save the result to a cell
- code for printing worksheets
- Listbox column Headings
- Referencing worsheet names
- Return value of a failed query?
- Selecting Next Column After a Specific Row
- Error Message
- Converting a VBA output String to a Cell Reference
- make the #N/A from Lookups act like Zeros in sum calculations
- Text Box to Cells
- Searching within substring text
- pivottable get data
- Copy information acumulated in another Sheet
- VBA beginner: Code in the Workbook_Open() does not get called
- Complex Chart:Need to have COLORS of BARS stay with designated data when I SORT
- Activex Grid control not present ??
- Counting number of rows (with skips)
- Find and Compare against a diff. wkbk list and replace as found in another Wkbk.
- Excel closes when using VBA to write VBA code
- Copying worksheets & renaming them
- is number between X and Y
- Excel Macro works in 2000 but not 2003
- Auto Total
- Run-time error '1004' with Range and copy
- HTML in Excel
- Automatic Date Entry when Cell Changes Status
- Deleting Files
- Problem with Column on a Userform
- Error 91:“Object Variable or With Block Variable not set”.
- Connect to Oracle database using ODBC when opening worksheet
- Finding a shapes name
- date function in code
- Hide Columns, Filter & Copy Visable to new wrkbk
- Selecting all charts on a worksheet
- Conditional Formatting And Macros
- Change font to red if 2 or more identical cells exist in a column
- insert linenumber
- Locking cells unless needed
- VLookUp in a macro
- Delete hidden rows & columns
- 31/02/2007
- Range("A11:A12,G11:G12")
- How to select different Macros from a dropdown list?
- Can’t find Project or Library
- Command buttons question
- search a pair of of numbers and return a corresponding value
- Error: "Object Variable or With Block variable not set"
- Largest difference from reference value
- Trying to add lines and get "you can not change part of array"
- Password protected macros are broken
- comparing columns
- Combobox Excel
- Hyperlink or Command Button
- Selecting Printers
- Changing Drop Down List Value
- Obtain formula value in VBA
- Cell.Value to 2 decimal places
- Using Loops
- I keep losing my function when I press a clear button macro!
- Macro "Save file"
- filter help
- Dynamic selection of worksheets for copy to new workbook
- Cycling Formula
- How to compare cell data and merge matches into another sheet
- Why Declare Immediatly?
- #NAME error from VBA code
- Strange issue with Excel 2007
- Strange format error
- Reference Issue
- Link question
- Simple Macros Question
- I want to hide cell contents
- how to query an excel sheet
- Range Selection Problem
- Standard Exec Sum, varying reference worksheets
- What events trap insert & edit comments?
- Trouble in Checkboxes Land
- Number formatting and accuracy
- Update a macro's code
- populate list box
- Excel Html - XML Output simple question
- Enter a Formula with Variable Data
- Copy only a few sheets from workbook
- Breaking a Sub with vbOKCancel...
- Accessing cell position within a macro
- checkbox information
- worksheet name
- sort data
- Format "#.##0"
- Multi page
- Capturing info using VB form onto excel
- importing data
- automate process
- Type Mismatch Errors...
- Data clean up for pivot use from data dump
- Macro - Charts - Varying Source Data Rows
- Delete Rows After Rows With Data
- Userforms & Checkboxes & populating rows
- How do I validate a workbook's digital signature?
- How to check for Plus/Minus condition (Macro)
- Excel add-in for SQL Server Analysis Services - Merge and Center problem
- Bringing items over from excel spreadsheet
- Chart using entity ID.
- Macros and Charts
- Auto Filter by Macro
- matching hour in one sheet to same hour in another sheet
- User Defined Functions as AddIn
- Populate cells with listbox selection
- Compile error - DAO-related?
- Macro to insert text into merged cells
- Problem at the creation of a databse with excel
- =COUNTIF problems,
- Multiple results from 'if' statements
- Concatenate Problem
- Save As - triggers ListBox control
- auto-format
- Round
- Count duplicate combinations in 2 columns
- Counting
- Search and replace macro
- Pivot Table Items
- Simple String Parsing from Cell to Cell
- Capitalizing in VB of excel