- Data table on different worksheet
- Formating TextBox problem
- Userform and ESC button
- vb 6.0 board?
- Save a Macro so it is ALWAYS avaliable
- Using SUMIF over multiple ranges
- Updating Data in Listbox
- Linking cells and copying color if color is yellow
- Return 1 if a range contains any text
- While on Edit Mode,Excel's Events are temporarly Disabled.
- Formula
- Pie Chart - How to tell the chart not to pick up zero values
- Regarding Frontpage.............Sorry to post here!!
- manipulating data using macros!?!
- Alive Excel spreadsheet - Help
- Screen updating
- On TAB key event
- Making a workbook online ?
- Summing up rows
- keep a link to a cell even if it moves?
- Selecting and renaming a worksheet
- Data Validation
- Code to update a cell.
- Return Date
- Opening Delimited Text Files
- vba email
- Detecting Close button on Excel Application
- building an imbedded find function
- adding totals
- Excel Formula- What is wrong?
- Linking Formulae in workbooks
- Verifying Number Match Between Two Workbooks
- Thumbnail pictures
- How to return row number from another spreadsheet
- AdvancedFilter on cell values only
- Combo Box Printing Small
- Sum of different currencies partly
- Form properties
- disable command bars only in active workbook
- Sum Offset() Array Question
- Running Saved Queries: Interesting Problem
- default value for blank cell
- Web Browser Not Acting Properly
- Help please
- ActiveCell to bring up Messagebox?
- If statement
- Multiple worksheets
- Drop Down Filter
- Troublesome (for me anyway) Lookup Question
- Reference codes with numbers & letter "E"
- Format text
- How do you run Data Analysis Add-in using VBA?
- Code:Copy values to empty cells below filled cell NotWorking
- Formatting Negative Values
- Protecting Cells
- sumif
- Finding value between parentheses
- A Formula that Automatically Highlights Active Cells
- Help Converting to Word doc
- Automation Error
- Changing the colour of text within a cell using a formula
- How to update files from master-VBA Code
- Searching for cell with word
- Is This Possible in a Macro?
- Importing .dbf files over 65,536 rows long
- Change from Worksheet Macro to Command Button
- Sorting more than 3 columns
- Automatic links Update? [Yes] Excel97
- How can 12012003 be converted into 12/01/2003?
- Deleting Defined Names
- Activating a cell on another sheet
- Help with command button code.
- Hyperlink to Word document is causing Run-time error '91'
- Index and lookup
- Extracting previous text in a string
- Reconcile 2 Tables
- Find cells with formulas, procesing intensive formulas
- Hiding Rows in a Range
- Auto changing charts that are based on queried info
- nested countif if array formula
- Filter #N/A value
- how to calcualte number of months
- Mimic Color Settings
- Multipage control doubt
- We Querey refreshes all wrong, but not ALWAYS. HELP!
- connecting button to scroll bar
- AFTER HITTING ENTER IN A CELL, STAY IN THE CELL
- Graphs with 3 axes
- Datedif Function
- non-contigous cells in visual basic
- adding days
- Simple formula but confused
- A1+1
- Auto Fit Button
- Pivot tables memory
- SUM, SUMPRODUCT plus help!!
- Please help me get my files back....
- visual Basic HELP!!!
- Data Validation in a cell linked to a textbox (?)
- FORMULA QUESTION...
- Please Help!!!
- Internet Data
- Restrict Cell Change
- chart help
- Stop rounding down
- deleting a row older than 6 months automaticaly
- Make a multi choice option button with scoring?
- Lookup unsorted data?
- Excel 2000 vs Excel 97
- Data Merge
- Looking up value once and then not having it change
- Nested If Newbie
- skipping blanks when filling down a formula
- Separating Columns
- Parsing and syntax question
- Cell format changes when filling it using VBA Code
- "Inflated" Excel file...
- Referencing a column and not specific values
- Button Crunch
- Help!
- correlation function in macro
- Newbie question - Using arrays to minimise columns
- formulae don't appear on the formula bar
- Pivot tables - add VAT..
- VbNullChar !
- Offset reference
- Cell Formula or Custom FUNCTION!??
- Combo Populate
- Lookup over multiple sheets
- How to tell Excel to cut a word of a text after blank space
- delete all the named ranges in a workbook
- Intersection of data.
- Help!
- Import Large .txt files
- Macro approach to inserting formatted rows at chosen cell
- Excel Column Alphanumeric Identification Problem
- How to filter error messages in Excel
- Auto Hide Columns
- Data Validation Function and Allow List
- Ignore 0 (zero) in chart
- Filtering and VB
- Help with an Excel Formula
- Repeating title columns on selected pages
- email attachments in vba
- virtual memory error
- help! msenv.dll
- Link Vlookup
- Modifying some John Walkenbach code
- error message in pivot table
- Multipage control - runtime
- number formats in graphs
- seaching the value within a range
- Combobox automatic value
- Help with code please
- Referencing Pivot Table Data in separate worksheet
- Events after printing??
- Spreadsheet control
- Data Validation or select case
- Summing Values in Textboxes
- easy one (or so it seems) RIGHT(A2,4) in Macro?!?1
- One or the other
- Skipping Cells
- Formula does not work but it does
- String manipulations
- a very weird one: Combo Box Controls!
- Vlookup and #N/A I need it blank
- Workbook Sharing Question
- E-MAIL MACRO
- Link Challenges
- refresh data
- Conditional Formating Question
- Password protect multiple sheets
- Multi-variable regression
- SELECT CASE (NEVER ENDING LOOP?)
- USF Problem
- Cell Value to Row Number
- Change delete dups macro to keep top row rather than bottom
- Creating POINTS from Rank
- Find / Findnext not finding all occurrences
- rename worksheet in a project
- Can’t Find the Date
- Not fully sorting
- excel to webpage
- Fit to one page not firing...
- Totals in Data Table
- Pick Best combination
- Entering Arrays
- Lookups to externally linked files using multi-columns?
- Print setup with shared workbook
- (VBA) Selecting ranges using variables
- (VBA) selecting a range between two variables
- Formula automation
- macro if statement?
- Grouping
- Prevent changing of Specific columns columnwidth
- what wrong with this picture?
- Spreadsheet viewable range help
- ComboBox Cross Verification
- QueryTable Modification
- Saveas function problems
- Meeting several conditions in a data array
- Clearing a Form With a Macro
- A COUNTIF Formula with more than one argument.
- Sort function not working and [group] has appeared
- Quick One
- Code for Minimizing a form
- Curser Color
- Adding rows
- Loop is very slow - Suggestions?
- printing suggestions
- To obtain the name of the column using a lookup...
- Progressbar doubt
- Excel opens XLS file as a template
- What is Excel?
- possible to display a form and NOT LOCK Excel ??
- Protecting the author
- Event Before Save
- Why Excel over Access???
- Comparing values of two workbooks
- Find/Raplace formula macro
- Having Difficulty Pasting to a different Workbook
- How to make WorkBook Open VBA only run the first time opened
- clip art and cell reference
- Password Problem
- Combo box links with tabs?
- FUNCTION COUNT(A)...FORMULAS, TEXT, AND ?
- Intuitive hyperlink........or similar....
- Make Text Proper/Sentence Case In VBA Module
- Updating a cell only once
- Detailed working spreasdsheet
- Format and sorting problems
- Help with Sendkeys
- If statement- I want if false to go to next sub
- Code to recalculate a worksheet?
- If VLOOKUP = #N/A keep original cell value
- How can inputed information be guided to a specific group ?
- automatic sort function
- Surface chart fit equation
- Extracting Data
- Finding the last entry in a range
- Filenames in Excel
- Duplicate Records
- If then statements in Excel
- Coding a Patch File
- sub within a sub...
- macro to chart data
- attachment for email
- Move worksheet to other workbooks
- Pivot table not valid
- occurence counter