MrExcel Message Board Archive

  • Dynamic print range problem
  • count if certain font colour
  • message box
  • Pivot Table Percent of Total
  • Autofill worksheet numbers
  • Data Validation
  • Slow Load in xl2000
  • VBA Formatting Help Needed Urgently!!!!!!!
  • Help with a macro
  • protecting clipboard contents
  • Displaying Excel spreadsheets in MS Word
  • Control break report
  • Excel NOW() problem
  • how many time does it appear
  • does anyone see what is wrong with this code
  • Pivot Table
  • Tranposing with a macro of much painful data
  • Tracking high point in a number sequence
  • Corupt File Code Recovery
  • moving around in a cell
  • Assigning object names to charts
  • Text.
  • Comments for addins in the AddIns list???
  • User Defined Functions in DIFFERENT CATEGORIES
  • Can I disable custom toolbar building?
  • TomTS/Dave - bit more help on permanent highlighting, plz
  • Select range
  • Image in a Header
  • Creating a running total sheet + Pivot Tables
  • Pie of Pie
  • Cancel Button on Msgbox / Inputbox
  • VBA to add a new column to 200+ workbooks
  • relative copying
  • Week numbers
  • General help please.
  • column always visible when scrolling
  • Userform
  • Cannot open document - help!
  • Excel date/time computing
  • Find - Replace...for worksheets
  • Text Problem.
  • userform.print
  • Activate a drop down list
  • Clicking a cell or button takes you to a certain sheet
  • Deleting all rows that don't contain a word
  • Assign macro to whole page
  • userform password
  • concatenate
  • Automatic Sorting - Alphabetically
  • GETPIVOTDATA, a few short queries
  • Rounding dates in Excel 2000
  • Dates and %'s
  • Help with some Macros
  • Subtotals, Totals and GrandTotals
  • Protecting a macro.
  • Condensing Excel file size
  • Andy's Coach Business Scheduler
  • using cell values as reference points for formulas
  • Spreadsheet won't open
  • Insert Hyphens in Column of Text-Formatted Numbers
  • Delete/Add Sheet
  • How to speed up sluggish worksheet???
  • Be gone with "Do you want to save changes made to *.xls?" me
  • Conditional Formatting leaves "TRUE" in the cells
  • Using macro to divide across cells
  • Can't find Project or library
  • Compressing Excel Workbook
  • Engineering Notation
  • Can't name the sheet with the chart!!!
  • vlookup duplicate data?
  • Pie Labels
  • formula
  • using countif without a range
  • Can Pivot Table be used when there are no numbers?
  • Routing mail
  • Sorting issue
  • Need a slick answer please to a simple query
  • How to declare function that returns array of dynamic size
  • Web Query - Unwanted Scientific Formatting
  • Vlookup Question
  • Formulas
  • Changing the position of the cursor after data entry.
  • macro - Select All Sheets
  • Copy Sheets
  • Exporting an Excel list to Word database
  • Conditional formating
  • Formatting rows when using Subtotals
  • After using Drawing Tools. now can't click macro buttons? HE
  • Quattro Pro
  • Label on a chart question
  • Macro halts on 2nd Paste command
  • PLEASE HELP--Sorting one column to match entries in another
  • EMERGENCY!! HELP!! Excel won't let me save my file!!!
  • Why won't this work? (see attached code)
  • Excel 2000...Send To feature
  • Table of Contents based on worksheet names???
  • Sum only positive numbers in column
  • macro or conditional issue
  • Look for blank cell
  • Select next empty row