- Subtotals
- worksheet Change event and shortcut keys
- References Installation
- three dimension graph
- Office Persistent
- missing numbers from a list
- FILLING COLUMNS
- Deleting Macros
- deleting cells with a formula
- SaveAs with NO PROMPT!
- Automating "saving a pdf file name"
- text length restriction (not validation) SOLVED
- Thank You
- Ranking groups
- How to switch date formatting OFF!
- Error trapping
- setting an object (workbook) variable
- Macro once a day
- Used to have separate excel windows but now???
- curve with two variables
- Clearing textboxes, listboxes and comboboxes
- Using XL formula in macro - find & format date column
- Upper case to lower case
- Cell duplication
- Verifying User Form Entries
- Selective Row Delete
- ZERO QUERY
- Reverse data in 180 degree angle
- Time Calculations
- Reconciling data on two tabs
- Split function - compile problem
- ANY FORMULA SUGGESTIONS
- Date auto fill
- need macro to email excel spreadsheet
- linking a workbook
- Trouble with one date cell among many (**SOLVED**)
- please i need guide lines!
- i try to do this but is there a shourtcut
- comparing formulas in different cells
- Hyperlink
- Need help searching for words in a cell
- PasteSpecial fails, xlColumnWidths
- Help...Please !!!
- Sorting by date range and alphabetically
- Rerun Initialize Event on User Form That is Open
- Left Select
- Nested IF/OR
- Easy consolidate question.
- Displaying timers
- Expanded Color Selection
- the phantom cell
- text comparison
- Syntax for Selecting Columns in VBA
- Dynamic Ranges & Drop Down Boxes
- Advanced Auditing
- Cell Value in a Text Box
- Toolbar protection
- Compairing two excel sheets
- Summary of multiple sheets
- Countif and leading zeros
- VBA reference advice.
- multi-user at the same time
- Auto filter
- loopy loops part II
- countif...and - array?
- Sending an e-mail based on conditions.
- Any difference between CDate(Now()) and Now()
- Creating "variable" formulas based upon other cell results
- IF & VLOOKUP
- a little prb
- do we have to write it always
- Data selection
- Protecting a range in Excel 97
- entering a number into a cell by just clicking on a cell
- Code problem
- two sided printing
- option button default
- Row/Column Calculations
- anyone know the code?
- matrix
- Changing Font Size and Other Formats
- help, I'm stuck
- printing unrelated ranges on different pages
- Selecting range to delete
- Disable Control D
- selection box
- Help Needed .................Plzz
- Visual Basic
- Adding New Function to Excel's Built in List
- VBA SMOOTHING DATA
- importing from *.txt file by automation!
- Formatting cell
- Date conversion from dd/mm/yy to mm/yy?
- building a macro
- Damaged File
- Excel formula (IF statement) almost there...but missing 1 pi
- AND worksheet function
- Public Variable
- Need help from the wise ones. Is it "IF's that I need.
- Macro Help
- Industry Coding
- isn't there a simple method to hide the formula in the formu
- ok now what should i do
- Hide command button
- Excel-MoreFunc conflict (*SOLVED* - Thanks, all)
- Want to use an InputBox to open a file
- OnKey and the numeric keypad
- Message box with selection
- Can you get user input through an inputbox from a listbox?
- save as code
- parsing variable length text into meaningful data
- Moving information to a "Tabulation Sheet" in a workbook.
- Save as cell comtents
- Custom Format
- list selection from cell
- Application.Calculate in a UserForm
- Portfolio Spreadsheet
- Run-time error '9'
- When and how to use DoEvents (SOLVED)
- UserForm keyboard handler?
- converting text to real time format (and more...)
- 100 getkey a$: if a$="" then 100 bla bla bla
- Goto Last Non-Blank Cell In a Range
- excel
- Does hiding Rows mean they don't get included in loops?
- Cross Matching Two Arrays
- further query
- Userform textbox
- Formula
- adding shape within text within cell
- displaying content of cell based on cell background/font
- How to split alphanumeric data
- location of a named range
- Option Button code
- subtract formula result should never be less than ZERO
- Replace double quotes ("") with single quote (") in VBA
- locked out
- Question about conditional formatting
- RE: @ Count Folumla
- VB and Auto Filter
- Rounding Down to The nearest Whole Number.
- is it neccessary to use Dim also to declare constant?
- Custom views & column width
- code for adding "custom views" toolbar
- poll keyboard
- Ability to capture whether a UserForm was closed with the X
- Public Declare Sub???? (SOLVED)
- COUNTIF across multiple worksheets
- CONCATENATE
- Simple
- allowable cell or range names
- counting titles
- A bit beemuzed
- Excel Macro slows down
- selection contents into a variable
- userform and date formats
- Saving Files To Excel Versus My Documents
- SOLVED!!! Thanks...Opposite of CONCATENATE? Can I
- Saving Excel Files in Excel Versus My Documents
- save as or save function does not work
- count fields on from one sheet to another, but there's a cri
- copy a field from one sheet to another automatically
- WorkSheet Change Event (Solved)
- Need help with VBA
- Screen update after Hidden = False
- Invoice Numbers
- VBA set variable from cell value
- VBA: Text to Date
- sort rows from low val to high val automatically.
- locking cells on a certain date.
- Help on Data Validation
- Simple Question ?
- Cutting a fixed string out of a variable string
- move shape on worksheet VBA
- Vb command for overwriting an existing file
- Disable Copy
- Cell Data Vaildation
- Nested IF statement too long
- Create a new folder in current path
- Count different numbers only
- charts in word file
- Calendar On Userform
- Disable macro's
- Moving to next cell
- worksheet attribute for first visible sheet
- Automatic data refresh!!!
- Using a forward slash in concatenation
- Email Macro
- Shell() Statement problem
- Activate a Macro from a Pivot Table Filter
- input msgbox stuff
- Error when using VBA Sub Procedure to unprotect sheet
- Deleting data using a macro
- Switching data in two cells
- Is this possible?
- Volatile Address (goto using VB) SOLVED
- Subtracting Time
- Check if Shape exists, then delete it
- Worksheet_Change Event
- Hidden Worksheet and Hyperlinks
- Adding certain numbers in a column
- VB / Access problem
- I hope this makes sense!
- Status Bar
- copying a custom view
- copying a custom view
- using excel as a database/form
- help not posting the data?
- Cells
- Question about naming ranges vs. cells
- Export Excel-range to MS Word - Automation - Part I
- Matrix lookup
- Number of Values in a range
- get a running total
- Updating Linked Workbooks
- calc data from mult worksheets based on 1 condition...help
- paragraph breaks
- Grouping (Outlines)
- retrieving data from a form and inserting it into excel
- Workbooks.OpenText
- Drawing using macros
- Is it possible to create a booklet from multiple worksheets?
- Macro for hiding worksheets
- Insert Picture onto Userform from Worksheet
- Betting Odds Calculator / Settler
- Variable/data type mismatch
- If Statement
- Can I create a drop down menu in a cell?
- Select 10 cells with largest value?
- Find & Delete Duplicate Entries ??
- mail merge
- Max # of sheets and entering text
- Macro - Deleting/retaining digits in a cell
- Queries
- CORRECTION ON VBA SMOOTHING??? PLZ! HELP!
- Summary
- Macro to fill cells
- Data Date Validation for a 4 week timesheet
- Paste range on another page with macro
- Unique number generator
- Control Box, List Box, Validation?
- Macro to create summary on new page
- Coloring contents
- keyboard shortcut for paste special...
- It's a longshot but...
- Loading references to an Object Library
- updating formulas that use user-defined functions
- So Close ... Yet so Far Away....... almost like Oakland!!
- removing text
- column charts