MrExcel Message Board Archive

  • COLUMNS HELP ME!!!
  • Automate deletion of macros
  • Pivot Table - Arbitrary Sort
  • setting print area from within a function
  • Detecting which toolbar button was pressed
  • Linking Worksheets
  • Increment Letters (A+1 = B)
  • text in formulas
  • Adding columns using VBA
  • update source data for plot
  • User Form
  • Pivot Table where field shows bad values
  • Error Handler disabled & Complete Range not in Memory
  • Simple question about Charts
  • Call subroutine from different file
  • Removing duplicate entries?
  • Advanced find and replace
  • Pivot Table
  • "Enable Macros" pop-up box on open of workbook
  • Hypelinks
  • Print Macro
  • Macro for Replace with user input
  • "Paste formula" macro
  • Copying a FORMUALE a set no of times down a colum
  • text and formulas in one cell
  • Explaining prob with formulae fill better!
  • Dynamically add optionboxes on userform
  • vlookup on multiple columns
  • Help with this code
  • Excel Macro with parameter
  • User defined function output
  • drag and fill nightmares
  • Numbers as text-changing in cells
  • Lookups-changing the column ref when dragging formula
  • Disable Excel Macros in read only workbook?
  • masking password characters
  • MsgBox for unmet conditions (?)
  • How do I change my code to offset to the....
  • XY (Scatter) chart issues.
  • Suppressing Duplicates #2
  • Expressing a number as a string of text
  • Writing on an inserted image
  • Call a Subroutine from Different File
  • Is there a way to get rid of "Page1" in print preview?
  • Changing cell colors based on day of the week
  • excell just hangs..... and hangs..... and hangs.....
  • Rows to repeat
  • Lost "Undo" Function
  • Creating a .pdf file From and Excel File Containing Hyperlin
  • VB Code question...
  • Advanced Excel techniques
  • Password Protection - Work-Around
  • Show values of Array Elements in a MsgBox
  • linking check box to a formula
  • Formatting cells after importing from Access
  • Pivot Table-automatic column resizing
  • Formatting - conditional on errors
  • Insert row on button position
  • Problem Calling Current Date in Macro
  • Vba application.displayalerts=false very Slow
  • WorkBook Naming
  • sending workbooks with Lotus Notes
  • Cell Variables
  • Excel v4 spreadsheet not working on new versions.
  • Removing all data for a new month and save
  • Average a row of data without zeros
  • Colour a cell based on the colour of another cell
  • Can anyone configure this code to work with office xp
  • seperating text and numbers
  • Does VBA have the sendkey function??
  • Pivot Table won't sort months logically
  • Text in cells
  • Showing a picture of problems in excel sheets- how
  • #DIV/0!
  • Dynamic Auto Filter in macro
  • Simple question
  • Conditional formatting w/color
  • Conditional font size
  • Cell padding/widths for back-of-book index
  • How can i access to XValue & YValue for selected point?
  • Keeping value of variables
  • Mail Merge Topics
  • Double printing
  • Formatting in VBA
  • Convert input data
  • error 800a01a8
  • Directory
  • Protect/Hide the Macro or VB Script function
  • sum values on even row numbers
  • Help for Word
  • Column width Units
  • Removing the Spreadsheet Solutions tab
  • Adding columns to make a specified value.
  • How do I insert a picture into a header?Is there a way?
  • Public?!
  • Message Box for wrong date entered
  • Database problem
  • Transpose Macro Help...really need help!
  • Charts
  • Read PDF files with Excel