MrExcel Message Board Archive

  • IF function
  • Extracting data from dos program.
  • VBA to copy file from one folder to current folder
  • week numbers
  • How to put a picture on my charts
  • Change target cell automatically
  • Possible zinger, can it be done without VB?
  • countif using multiple criteria
  • Variable losing its value
  • Is IF an efficient way to solve problem.
  • analysis toolpack
  • Maximum number of constraints with Solver?
  • macros 97 vs 2000
  • Word vs Excel
  • Non printing cell?
  • IF statement with multiple criteria - I think.
  • select multiple rows and EdgeBottom of each
  • Explanation of why this one liner works
  • Cell selection
  • Anyone have code to properly insert a column when some of th
  • Colourful Language
  • a little Help in VBA.
  • Copying specific lines of data from one sheet to another
  • date formula
  • Anyone know of a good microsoft Acess forum
  • Check another sheet for full name, return telephone #
  • Optimisation Function
  • Sum, Average or Count a higlighted range
  • Combo box values
  • Update record by itself
  • Absolute references not wanted
  • Need help with Investment Spreadsheet
  • count rows
  • Removing Combobox Entries
  • Dropdown lists with source list on seperate page?
  • Links Between Workbooks
  • Apending a file VB code problem
  • User Form Names with numbers & Looping through them
  • Is this possible in VBA?
  • Excel as a database?
  • Phantom XLM macros?
  • Undo a macro?
  • Checkbox conditions
  • Find and display....
  • Excel and E-mail
  • excel pivot tables
  • Repeat rows at bottom of page
  • help with shrinking a formula
  • Declaring Variables
  • last row of a column
  • Filling in Cells with zeros
  • Is there a way to do this........
  • VBA - Using an Add-In menu that does not have VBA link
  • What means "####" ?
  • disable buttons on a form based on an active sheet
  • Formatting headers and footers
  • IF statement to color a cell
  • Macro for "Paste Special – Values"
  • Matching two peices of data in the same row
  • AVG lap time calc
  • match/index question - Aladin? Help?
  • Limiting the number of Characters in a cell
  • Excel
  • Formatting cells to have default settings
  • autoupdate for autofilter ?
  • Probably Easy "Left Function"
  • match/index AGAIN - same formula, no longer working
  • limited options from options
  • quoting quotes
  • User form to query
  • How to have Excel auto highlight a cell if it contains a cer
  • Combo box on a worksheet font change
  • Need Help "Removing Automatic Links"
  • SHEETTAB IS BUTTON
  • references
  • CSV File Dropping Leading Zeros!
  • Always enable macros and never update links when opening
  • Simple stuff
  • ActiveCell
  • Macro with wait for enter key
  • SUMIF's with Shading or Fill
  • Using macros to subset master database
  • Hyperlinks
  • Named range into string
  • User Forms
  • Major Help Needed! Newbie seeking help!
  • Populating ranges following user input
  • displaying a tree structure in excel
  • Copying a Worksheet
  • checkbox
  • excel problem
  • Close Acrobat "on the fly"
  • find next blank cell
  • file format not valid
  • Using Option Explicit
  • Conditional Color Formatting for more than 3 conditions
  • Link/Copy Workbooks
  • this is a tough one
  • Underline
  • Pulldowns From Pulldowns