- Sorting data with colored cells
- publishing active x controls
- Code Help
- Recovering autosaved versions
- Integrate Access macro within Excel
- Match 3 Criteria and Pull Value
- Find cell.value in range
- customize buttons
- Macros on a shared and protected worksheet
- Macro to make list of data from entries in columns
- Pivot Table formating
- Subtotal VB - hom to move result to another column
- Download Add-ins???
- Populating Combo Box on WorkBook Open
- How to stop workbook from calculating on every input???
- Cell contain default value of cell above it
- Cond'l formulas and counting cells with text-based entries
- Passing a public variable
- Excel Group button
- SUMIF and working with dates
- Page Number of Cell
- What is Public Const
- What is Public Const
- Con. Formatting and Formula problem
- Pulling information from another file
- Removing Modules in a Password Protected Excel Sheet
- Converting to XLA file format??
- Basic Macro Code Help
- Vlookup #N/A Error
- Edit embedded file with outside application
- Switching between tabs
- VLOOKUP in VB/excel for calculation tool
- VLOOKUP in VB/excel for calculation tool
- Changing binary values using solver in range defined by user
- adding comments to chart
- Text on both axis
- Workbook Groups
- Help with selecting an entire row
- Buttons on a spreadsheet
- Macro or Vlook up?
- sum values in a column if criteria is met in another column
- Edit formula problem: #REF
- macro help
- What is PAND?!!!?!
- Serial to day, date, time etc.
- VLOOKUP for partial cell
- Updating spreadsheet
- Set print area...
- Detremine rows and columns selected
- Quick, Easy Question
- If with vlookup???
- text formated number auto change to number format
- Command Button Caption
- Multiple Sort
- Listbox question
- Sending PDF file to printer using Macro
- Converting 12:00 AM
- Sorting/Filtering a data Base
- Reference
- Tracking visible cells from an autofiltered list
- Summarize Data
- Using CountIf from within VBA
- splitting text and data in one cell into two cells
- Problem getting file from unix server.
- Locking the functions
- Loading Macro
- Sorting Worksheet Tabs
- vlookup and clickbox in vba
- Application.ScreenUpdating
- How to refer multiple sheet under single formula
- Sumproduct with irregular arrays
- Addresses in Excel printed onto lablels for mailing
- Argument Not Optional error when calling a macro
- IF statement
- Need to exclude one sheet from this routine
- Defining a date
- Find Duplicate Rows
- more than one record meets the answer
- Tabstop
- Delete Rows w/ Auto Filter
- Conditional & nested functions...
- how to switch to another worksheet with VBA
- how to add items to a list box
- find first entry and last entry for a group of cells
- Progress bars
- Pop up box
- Find cell.value in Range within a loop
- deletion method
- SUMIF loop macro
- Create Named Range similar to DB results
- Referencing data from lists
- Restricting data entry choices
- SUMIF loop
- a macro to create copies of a sheet, with hyperlinks
- Fill Down to "Next" full cell?
- Increasing all cell values at once
- Error MsgBox on invalid entry
- general question
- Looking for Wookbook_BeforeCalculation Event procedure
- Printing all sheets in a folder with VBA
- Selecting a range (column) whose starting cell is known ...
- Change this code so that it works with userform(textbox)?
- Need help with a find formula
- Ranking Non-contiguous Cells
- IF, msgbox ERROR
- Chartspace1 - Any Guru's out there that know this one?
- iF STATEMENT
- Adding 1 number to an existing
- How to get a column to remain in position while scrolling
- Autorunning macros in a closed application
- updating a cell with formula?
- Category Or. Runtime error
- Problem with Date Formula
- retrieving cell information from multiple files
- [VBA] - Data format changes during copy on Excel 2002
- Put Excel data into Word
- Data Validation and VLookup
- Please help count lines
- Formula for change the colour of a cell
- increment invoice number with some intelligence
- SUMIF
- Password a worksheet
- Problem in Dependent Lists
- testing my find function
- Backup open workbook
- Summary graph sheet with variable & multiple ranges
- Dragging Formulae
- <today()
- Simple question
- Publishing with a smaller percentage
- Excel thinks I am trying to copy a picture rather than data.
- Using an If AND statement with a range?
- Help with matching
- [b]Checking a list of values for uniqueness[/b]
- deleting rows from worksheet
- Run macro when a formula result is changed
- COUNTIF
- EnableEvents = False but change_event still triggered
- Simple, if function correction
- Sumif visible cells only
- Opening Powerpoint(.ppt) from Word VBA Code
- Pulling in Control Data with VBA
- Rounding down to the Nearest Thursday
- Current Row Copying
- Last Data in a column (semi-resolved)
- Delete Negative Numbers in Worksheet
- sum column B values based on a range in column A
- Cutting and pasting a row between spreadsheets?
- position function?
- .PDF to .XLS
- [b]Date and Datedif problems[/b]
- hiding a column
- column
- stop a macro based on an error message in a cell
- Sum from Last Color Cell
- Sorting Data
- Stacked bar chart and 'normal' chart combined
- user form input to create new file name
- Sum over a date range but must reference different columns
- Time and Date help...
- Question about conditional formatting.....................
- calculate time between two dates excluding weekdays
- Calculating across worksheets
- Row Hider based on a board search...
- Sumproduct query
- ComboBox Challenge
- I cannot have been the only one to ask this
- Pulling from a list of names by date
- adding cells together from different sheets
- Pulling the bottom value off a colum of data
- Copying a range
- weighted average formula
- Work sheet references
- Looping through data to pull into a printable template.
- Sumproduct and named range
- In VBA selected range
- Selected MS Access data to Excel
- Delete #N/A values forom cells using a Macro
- Slow calculation-how to speed it up?continued from 6-27-05
- Protecting and preserving the format of cells.
- autoshapes to not hide comments behind
- Drop Down List
- Cell in a range starts worksheet_change event
- Value added as a percent of total
- Pivot groups
- Day-Date formatting
- Getting to First Blank Row
- Please Help With CSV Code Problem
- UserForm
- Date Placement
- Saving
- Keeping track of the Number of Business days for aging repor
- Protected Sheet
- Auto fill handle....
- SUMPRODUCT - #Value error.
- Please help me fix this formula.......
- Coding Suggestion/Help....Is this possible?
- For-Next statement is crashing Excel
- VBA icon file
- ListBox Controls
- Tabbing Between ActiveX Controls
- Inserting blank row and page break
- Filesearch is stupid and I hate it.
- Locating Old Excel Files
- How to write to an existing file
- Link List Box on a multipage form ?
- Want title in cell A1 to equal the name of worksheet
- VBA - NextBlankRow
- Adding a warning sound when a number is exceeded in a cell
- I have an odd dilemma
- Can you mail merge in word with 2 different excel files?
- Macro protection
- Three chart types possible?
- Printing to last page break
- convert numbers to text
- Complex Array Function IF? AND?
- Show first zero
- Chapter 19 VBA/Access example
- Merging workbooks based on condition All most there
- object variable in macro
- Need help. I forgot how to do this...
- How to Hide & Protect Module
- Delete row on one sheet if value is found on another sheet
- Row number to variable
- Hiding rows with two criterias
- loading an image in vba
- Copy and Paste data
- when do I need parentheses for functions
- HELP! DROP DOWN LIST (SELECTING 3 CRITERIA) FREE GIFT
- adding date and time to excel printouts
- Msgbox when rank increases
- Two stage lookup
- 2 sided printing
- Tabbing in protected sheet, array.. where will it start?
- Move or Copy
- Sums conditional on two criteria
- subtraction in excel, precision
- Count Data
- Formula not copying new reference
- Inserting Rows
- 2x excel
- DSUM using rows and columns
- Minutes rounding formula
- Removing Automatic Drop-Down Menu
- Advanced filtering criteria and a dynamic source sheet
- How to embed excel file in html
- First Timer - Disable Userform Button
- #Ref in formulas
- Always show arrow
- Pop up to enable Macros when opening workbook