MrExcel Message Board Archive

  • Conditional Formatting
  • Help needed with empty cells.
  • Workbook.add syntax
  • inserting a row every other row
  • Insert Footer into Every New Workbook Automatically
  • compare 2 colums of data and sum value on 3rd
  • Conditional formatting criteria retreivable via VBA ?
  • Sum Work sheets in a work book
  • sumproducts explained (if you have enough memory)
  • Combo box interagation
  • Strings & Such...
  • MS Access question
  • easy macro question
  • Sundry macro-type questions
  • Need help with Excel command
  • Use of PROPER command
  • null terminated string
  • Batch processing all files in a directory
  • Column Name?
  • Date and Time Format?
  • Import to Excel
  • HYPERLINKS converting
  • Text cell and number cell
  • hyperlinks and fillcolor properties
  • Printing Macro Names
  • Custom Commandbar in Template loses its assigned macro...
  • easy question about x-axis scale on a chart
  • Outlines
  • why CSE formulas and basic equivalents treat 0s differently?
  • Copying Range DAta from One Excel Workbook to Another
  • Execl Macro
  • Passing range parameters to VLOOKUP
  • Stop it calculating!
  • Removing cells that are a certain colour.
  • Selecting Graphics
  • borders to cells
  • outlines
  • Excel Automation
  • Multiple comparison test, help sought THIS TOPIC IS NOW CLOS
  • open in new window
  • Protect/Unprotect method of worksheet class failed
  • CSE Formula / SUMIF and Dates Problem
  • Testing Dates
  • Calculation automatique
  • Counting unique entries with two given conditions
  • Pivot Table that just shows entries - no their sums etc.
  • compare numbers
  • Naming workbook based on cell content
  • Connecting to Intranet via Excel
  • Multiple selections from combo-box
  • ButtonFace ID Index= SOLVED
  • Protection & formatting
  • changing pointers
  • VB6
  • Making a field compulsory before mailing sheet
  • Conditional formatting in if statement
  • Special numeric formats
  • Display.
  • How do I RUN A MACRO AT THE POINT OF CELL SELECTION?
  • Autorun a macro
  • Date fuction in Excel 2000
  • Can we delevelop an independent application?
  • comparing columns of names
  • These date and time items are tough.
  • Text box in excel
  • Visual Basic 6
  • Random Number Generator without repeating numbers
  • Launching a Macro based on cell entry
  • low memory
  • Creating a timesheet
  • Conditional Find
  • Excel inverse log function?
  • Conditional Lookups or Dynamic Cell References?
  • macro referencing to a hidden worksheet
  • Have one more Time issue
  • VBA to convert text to values
  • passwords
  • Sum at end of page
  • Trouble refreshing PivotTables w/ VBA
  • SEARCH IN MULTIPLE WORKBOOKS?
  • Time Stamping
  • Macro for file path and worksheet in footer with font size
  • for Newbies only - if you see bright blue (RESOLVED)
  • SaveAs method
  • How do I refresh Path In Footer when saving to another folde
  • Splitting Workbook
  • Printing Trays
  • database not connecting
  • file not found error while compiling
  • Show 2 rows of data, if one cell 0
  • Printing Address Labels
  • Paste Special borders format only, not colours or font
  • Is it possible to find more than one vlookup result and tota
  • Excel Datevalue function-convert 7000 cells
  • msgbox statement- easy one
  • Array of an Array
  • If you can explain this...
  • Formula problem: works sporadically
  • simple time format question
  • May look simple but very important to me