- Password list from file?
- Totals at the bottom of each page?
- formula1
- Preventing insertion and deletion of rows/columns
- passing array to excel
- Tracking Changes
- Basic VBA
- Compile Error
- Macro and filtering
- stem leaf plot
- formula2
- Excel Question
- Footers
- please help me!!
- Formulas & Dyanmics ranges
- Calling functions in another workbook or XLA module
- Label Value on a UserForm Thanks for the help(Resolved)
- Date Function
- edit font in drop down list
- Dictionary Object Help Needed
- Excel 97 Bar Charts with percentages and data labels shownB
- “CTRL” “END” keys will not go to end of worksheet
- how to go to next row
- Shared file problem in Timesheet workbook
- merging adjacent columns
- running a macro from a different workbook
- Error whenstarting or exiting Excel 97
- can you drag fill a formula?
- import data in columns?
- Vlookup from a closed workbook?
- VB CODE PASSWORD for Project Locking
- Still looking for Help! Copying cell values from one open wo
- Search in all worksheets
- Message for Juan Pablo G.
- lookup array (not sure what to call it)
- Looping Names in VBA
- Drop Down List
- Macro to number each row
- Counting Dates
- Is there a quick way to calculate age from a D/O/B?
- Macro Button
- How to intercept a command button click in the middle of tex
- Find last cell containing a value in a row
- Canot not set cell Value via VBA
- Finding links to other workbooks
- Getting similar data from 2 spreadsheets
- 1st Drop Down List Controls Options in 2nd Drop List
- Assign a Value to Another Cell
- VLOOKUP
- Need advanced help with "On Error..."
- Highlighting cell
- Print Preview causing error in Excel 2000
- better explanation of timesheet problem
- MACRO PROBLEM
- COUNTING
- entering current time cell by cell
- pop up info in another cell when....
- COLOURING CELLS
- Hidden Data When Using Subtotals
- Sumif using multiple criteria...
- Excel Transfer To Word
- Simple formula
- Comma seperated to comma delimited
- IF function
- Extracting data from dos program.
- VBA to copy file from one folder to current folder
- week numbers
- How to put a picture on my charts
- Change target cell automatically
- Possible zinger, can it be done without VB?
- countif using multiple criteria
- Variable losing its value
- Is IF an efficient way to solve problem.
- analysis toolpack
- Maximum number of constraints with Solver?
- macros 97 vs 2000
- Word vs Excel
- Non printing cell?
- IF statement with multiple criteria - I think.
- select multiple rows and EdgeBottom of each
- Explanation of why this one liner works
- Cell selection
- Department budget
- Anyone have code to properly insert a column when some of th
- Set Format for worksheet
- Colourful Language
- a little Help in VBA.
- Copying specific lines of data from one sheet to another
- Solverf Macro
- date formula
- Anyone know of a good microsoft Acess forum
- Check another sheet for full name, return telephone #
- Optimisation Function
- Sum, Average or Count a higlighted range
- Combo box values
- macros...help!!!
- Update record by itself
- Absolute references not wanted
- Need help with Investment Spreadsheet
- count rows
- Removing Combobox Entries
- Dropdown lists with source list on seperate page?
- Links Between Workbooks
- Apending a file VB code problem
- User Form Names with numbers & Looping through them
- Is this possible in VBA?
- Excel as a database?
- Phantom XLM macros?
- Undo a macro?
- Checkbox conditions
- Find and display....
- Excel and E-mail
- excel pivot tables
- Repeat rows at bottom of page
- help with shrinking a formula
- Declaring Variables
- last row of a column
- Filling in Cells with zeros
- Is there a way to do this........
- VBA - Using an Add-In menu that does not have VBA link
- What means "####" ?
- disable buttons on a form based on an active sheet
- Formatting headers and footers
- IF statement to color a cell
- Scenario's - help
- Macro for "Paste Special – Values"
- Matching two peices of data in the same row
- AVG lap time calc
- match/index question - Aladin? Help?
- Limiting the number of Characters in a cell
- Excel
- Formatting cells to have default settings
- autoupdate for autofilter ?
- Probably Easy "Left Function"
- match/index AGAIN - same formula, no longer working
- limited options from options
- quoting quotes
- User form to query
- How to have Excel auto highlight a cell if it contains a cer
- Combo box on a worksheet font change
- Need Help "Removing Automatic Links"
- File Size
- SHEETTAB IS BUTTON
- references
- CSV File Dropping Leading Zeros!
- Always enable macros and never update links when opening
- Simple stuff
- ActiveCell
- Personal.xls worksheet wont load with Qbooks Excel feature.
- Macro with wait for enter key
- SUMIF's with Shading or Fill
- Using macros to subset master database
- Hyperlinks
- Re-Saving a Template
- excel on web
- Named range into string
- User Forms
- Major Help Needed! Newbie seeking help!
- Populating ranges following user input
- displaying a tree structure in excel
- checkbox
- Copying a Worksheet
- excel problem
- find next blank cell
- Close Acrobat "on the fly"
- file format not valid
- Using Option Explicit
- Conditional Color Formatting for more than 3 conditions
- Link/Copy Workbooks
- this is a tough one
- Underline
- Pulldowns From Pulldowns
- SaveAsFilename
- sumproduct?
- comparing 2 sheets, removing lines based on result
- experts : how to mapipulate large data in excel
- HELP Needed
- Automatic Insert
- Code to switch Calculation Mode ManualAuto (VBA Ex'97)
- It's Friday & my head hurts - RESOLVED
- need help with lookup()
- how can I create a running list?
- Multiple Files with VBA Macos Using same Shortcut Key
- Charts
- checkbook register
- worksheet size ?
- Check box inside of a combobox
- invoice records
- Locating and displaying data from a rather long column.
- thought I could find it in the archives
- Excel charts
- Check for text, if true, then use this formula
- If cell is blank, fill with text above
- Sharing a workbook in real-time
- extracting data
- Dragging Countif functions
- Remove area codes from phone numbers
- SOLVED: How to determine current autofilter criteria?
- MENU / COMMAND BARS
- Pivot Table grouping (Excel 97)
- VBA Code Slows When Setting 'Page Setup'
- lots of data with n/a
- lost focus ???
- Excel 97 to Excel xp
- Worksheet names
- Cheers folks !!!
- Any Second Wind users???
- vba case text string
- Duplicate Lines in a spreadsheet
- Cancel Button
- MS Excel Limited Rows - 5000 ???
- Financial function PMT
- Macro opens directory, waits for selection.
- code needs a bit of updating
- Find function
- change the color of a line
- another problem - sorting numbers
- Delete VBA
- add a sum dependent upon criteria
- column letters and column topic visible with InPutBox
- Macro code for a refresh button
- Macro to show all on an autofilter?
- help with nesting
- Autofilter and updating data?
- ENTIRE ROW DELETE
- macro problems
- workbook 1 formula workbook 2 information
- select and move contents of columns to rows
- rows........again (resolved - thank God!)
- Passing multiple arguments to a Sub
- Pivot Table Calculations
- xlsheethidden vs. xlsheetveryhidden
- Solver and multiple IRRs
- Vlookup Formula Won't Copy after first row
- Moving ranges without changing formulas in adjacent column
- User input in equations
- Help with formulas
- Full Name to First | Middle | Last
- Conditional Format next question
- Excel AutoStart Message
- selecting rows
- Formula
- Sum?
- Is there a MrVB?
- Dynamic Formats
- Simpson's Rule or General Integration
- how to add a for loop to my code...
- saving multiple files as csv
- visible sheets -
- how can i make a custom command bar availble on opening and