MrExcel Message Board Archive


  • Conditional Max
  • protection
  • Importing into Outlook Contacts from Excel
  • Custom Format of a Percent
  • switch from userform to worksheet
  • Automatic Date?
  • Multiple matches using the IF function
  • Line Charts - How to cope with missing values
  • Minimum/Maximum value
  • Saving VBA Code And A Counter
  • getting data out of merged cells
  • Array CSE Formula in Macro
  • MS Word field = MS Excel field?
  • excel spreadsheet to a form
  • Enter Text
  • Combo Boxes
  • Print only certain worksheets?--Excel experts pls help
  • NUMBER TO TIME CONVERT
  • object shape size
  • Returning only a portion of a number
  • protect all sheets macro
  • Linking graphs to columns of Data
  • Runtime error after adding a control to a working form
  • Placeholding blank cells
  • Error after importing a macro
  • Help: how to insert 2 blank cells in between the rows until
  • Elasped Time
  • Surveys, anyone?
  • VBA module names
  • program
  • Needing a macro to save in another workbook
  • Match column & row headings to return intersecting cell's va
  • shorter formula
  • Insert 2 blank cells and Fill it down.
  • visual basic Form
  • How can I conditional format cells with more than 3 conditio
  • End line char
  • maybe simple question. special cells (unlocked cells)
  • Formula Trouble
  • chart without "0" and blank
  • Schedule
  • Worksheet names
  • How do I get excel to work with text in the following way
  • I can do the correct function for one column but not two - H
  • Describe a number as text????
  • file format is not valid
  • Do VB macros work with HTML
  • VBA Finding ‘Constant’ name if number & Enumerated data type
  • Close userform with a button.
  • Split screens
  • Change dtes into charts
  • Macro to open files with varying names
  • Deactivate worksheet code during paste
  • dot instead of comma
  • A nice easy one hopefully?
  • Interesting Sumproduct/Counta Behavour??
  • Array formula help needed
  • Cell to cell
  • Splitting part codes
  • Run a macro automatically at a given time
  • Lookup
  • apply vbs form to click button
  • Extracting Quantity
  • Help with graph and data series
  • Check a list and return a value
  • Date
  • Counting unique occurances of text in a column
  • Reverse the close command
  • vlookup
  • Printing problem (multiple sheets)
  • select data
  • macro runs fine in vb editor, but not on worksheet
  • What to do if formulas in cells conflict with results in oth
  • IF SUM easy one!
  • COUNTIF for AutoFiltered data
  • Excel Header Formatting
  • comparing items in two Columns...
  • The use of options button (I'm sure theres a quick solution)
  • Simple Command Button
  • database
  • anyone like to try and condense this code.....
  • Help! I need a formula!
  • Limit on size of matrix functions?
  • Julian Date Conversion
  • linking and splitting a cell's contents
  • Importing multiple text files.
  • Disable Error messages in Excel 97
  • Entering a cells value in a textbox
  • Delete rows w/values; create mult. sheets from data
  • If Function
  • Conditional formatting only 3 allowed ????? :(
  • How to run a excel macro from commandline or thru .bat batch
  • converting text to value
  • Help With Lookup Formula
  • Passing arguments from Excel to a UserForm.
  • Suppressing the save as message box
  • problem with array function
  • Save As: Overwrite exiting file w/out dialog
  • VLOOKUP #N/A
  • concatenating 250 cells