View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 2
Default Obtaining a value from a cell and using it in a macro

Hi.

I want to create a macro that iterates around several formulas and
spits out a final result. The spreadsheet will have several cells that
need to have values entered into it by the user. I then want the user
to hit a button embbeded into the sheet that starts the calculations.
This will require the macro to get the values entered from the cell,
give them a name, and use it in subsequent calculations. I am sure this
is really, really easy to do