- macro to delete 2 columns IF
- Converting crosstab to relational-compatible format
- Regression analysis
- Charting high low ranges
- Change order of text in cell
- Date format?
- Hide zero cell macro
- Still Need Help Selecting a file to run a macro on..........
- How to specify format cells in a formula
- data filtering using macros
- Problem with: LEFT(A1;LENGTH(A1)-SEARCH("-";A1))
- Summing every other cell
- Problems with paste special in macro
- Bank Account Number
- Hypertext in a messagebox
- Help on a MAX formula
- How to add custom icon packages to Macro
- using or statement with if statement
- Hide workbook while a macro is running
- charting data (suggestions, answers, tips, .....anything) pl
- Finding duplicates across two sheets
- listbox and file names
- Auto Run Macro
- Event handler for a specific character typed but not entered
- Multipage
- Identifying duplicates in a set
- SQL.Request (retrieving info from access database from excel
- macro help
- Have Customer Fall Within A $$$ Range
- Formula
- Concatenation with VBA
- Importing code for the Worksheet Change event?
- VB Code affecting other spreadsheets
- Count IF
- Chart Labels Centering
- How to change format of date in footer
- Calculate Current Sheet Only
- Function to Specify the Range of last 30 points in data?
- Get File Name
- TOTAL SUM +/-
- simple vba Q about saving
- Using SendMail with a Submit Button
- Simple VBA function
- Office XP template question
- Miscaclulation
- Error Handling
- userform to disappear
- cell ranges
- Conditional cell entry
- Counting with multiple criteria
- Overwrite Write Reserved File
- format cell as checkbox
- Inserting rows changing size of textbox
- Output directory file names
- Copy Paste Special
- Set Property of Column using a Formula?
- #DIV/0 - getting rid of
- Copy all files
- Two Questions for the Macro Masters
- Determining how long NT username has been logged in?
- Avoid VBA Error Message?
- Removing worksheet with commandbutton unloads forms!
- Index Match Formula with Multiple Arrays
- Truncating/seperating text in cells
- Sorting Data - Skip it, found answer
- Format of cell data in an outlook e-mail
- finding and moving data
- Hide workbook
- Sheet references.
- sum using row & column headings
- Complex conditional format question
- Comparing two datasets in Excel (i.e pre-run and post run)
- does a macro have the ability to unlock a pasword
- For next count
- Displaying text AND variables in a MsgBox
- Row Number
- Need help comparing contents of one cell to another sheet
- Printing to the extreme
- Best way to store variables after code stops
- Slow Loop
- Find a record match in a data table using a single cell key
- Opening Windows Explorer with VBA?
- conditional formatting problem
- Automatically copy data from different workbook
- Files in Directory
- Force no save on close & decimal point problem
- how to sort by color ?
- running a macro button from another worksheet
- Defining and auto summing a range of cells in a colum
- Selecting across different start dates, columns
- vba to ensure 20 column spacing
- Hiding worksheet menus
- is this possible?
- Create a folder in a root directory C:\xxxx\
- Create a desktop shortcut
- Change File Name
- "System Files Update" comes by ExcelXP
- find the next cell available in a range of four cells
- formatting fractional/decimal digit
- Can I get System Info via Excel VBA?
- repeating patterns in formulas without dragging?
- how can I get the macro to run when the workbook opens
- Using Find to locate column
- VBA formatting, create/append file problem
- Protecting formulas
- VB - Fullscreen
- Need a formula (should be easy_
- Can't find my PERSONAL.XLS workbook
- Can Excel Solve This....
- selecting range from input message box
- Excel - Office XP
- Interactive autofilter form
- Conditional Formatting
- Adding intelligence to a survey form
- If data in A1 then print
- Simple question regarding COUNT...
- we all know the problem of rounding numbers
- error counting by color
- Duplicate data
- Formatting Text in Cells
- Hopping cells
- Growing worksheets as Excel Objects in my Project Explorer
- Formating text inside the formula
- Help needed
- Excel Chart type
- Can a Macro (VB) and Cell Formula Use the same Cell ?
- formula to format cell
- Addapting pie chart
- Navigate sheets Via Drop Menu/Combo Box
- Question re XL Software and PC Problem
- Hiding a zero...
- SUMIF QUESTION: More than one criateria
- Compiling not as informative as it used to be
- Excel Time Sheet.....Help!!!!!!
- Excel: Due date
- First Spreadsheet
- Inserting periods
- excel program for the "critical line algorithm"?
- msgbox as indicator
- Drop down list
- Exit code problem
- Paste Special ColumnWidths
- CTRL+SHIFT+ENTR style of commands (Part 1)
- Creating a new sheet for input data..
- Help! conditional format problem
- VBA Books
- Search Macro cell reference
- macro to filter, make changes to a database Sheet
- Problem with LOOKUP...
- HELP...problem with LookUp Formula!!!
- overflow problem...
- [b]Using Excel An Error Message Appears[/b]
- Formatting outlook data from data sent from excel
- New KeyWord !
- Weighted Average Calculation using 1 cell?
- font size in formula bar
- Recursive ranges in Excel 97
- Customise data for chart from pivot table
- Why do I loose the font when referencing a cell ?
- Error Msg Help
- Macro to change multiple instances of password in a project?
- help with the IF statement
- complier error can"t find project or library
- Inserting images
- Blocking the cells
- Trendline
- Opinions and help on some VBA code
- Block a single cell
- Closing a different application
- Conditional Formatting Formula
- Page Break problem
- Keeping verticle lines when a filter is placed on
- Named Formulas
- Autofilter Indicator
- Getpivotdata sheet reference...
- Calculating Sale price from cost and Margin
- Macro help
- Auto Filter on Cell Comment
- Cannot run macros
- axis format question
- Macro on a Pivottable with already created range....
- Looping controls
- Post to public folder
- Frustrating Lookup problem
- If Formula
- ADO speed up
- Problem with Personal workbook
- Printing specific rows in an excel worksheet
- copy paste
- match email address
- Matching Problem...
- macro and date
- Populating List Box from Range
- Inactive a macro after execution
- Add a warning message to a macro
- match
- Display info in modeless dialog? XL97
- Count of PivotTable Columns
- No one seems to be able to help on this one :(
- Duplicate Numbers
- Basic conditional formatting question
- LIne Break for Input Box???
- filter
- Help with entering data
- IF Function Problem
- Smooth Line Curves
- DELETE IF DATA DOES NOT = mm/dd/yy
- Macro to change font size depending on what number...
- HELP!! Please Read
- Passwords
- Creating a user defined function
- Searching for Text Withing a String
- Access or Excel?
- deleting rows
- Delete third row after "----------------"
- find and replace
- Keystrokes for highlighting and deleting a whole row
- copying text from one worksheet to another
- Lots of Code
- Why can't I open my workbook in full view
- Email Problems with linked worksheet
- Entering time into worksheet
- custom macro needed
- Number of Rows In Worksheet
- How to find out which columns are selected under Auto Filter
- 0ing out cells
- Help - Sorting limit for values of a column?
- How to determine if data is found
- one last question:
- worksheet help.
- using VBA to name a seleted range
- row/collumn flip
- set a file as read-only or prohibit saving the file
- Looping Problem
- gathering data from multiple files
- Custom Drop Down Box
- Popup Message
- 3D sum of Workbooks
- Cell = Clock
- Help with combobox
- Referencing ActiveX Objects on Worksheets
- rng.end(xlUp) instruction out of range
- Convert Hours/Minutes to Decimalized Hours
- protecting macros
- Response to JP Gonzalez
- text to columns (from a PDF file)
- How can I detect Internet Explorer in VBA?
- Changing the "ThisWorkbook" code in a macro
- Linking to a file with a changing path
- file lookups