View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Macro relative cell reference

It would have helped if you had posted the macro...
Anyway first line would be something like this
Range("C23").Select
change it to ActiveCell.Select

Rest of the steps should be relative to the first cell... if so the above
change will solve your problem.

"decimal" wrote:

When I record a macro whether I use the relative reference button or not. If
I place the cursor somewhere else in the spreadsheet to perform the macro. It
always goes back tot he original cell I first recorded it in. Perhaps the
relative ref button has nothing to do with that. Is there a way to tell it
just to run the macro wherever I place the cursor and tell it to run? The
instructions imply in my opiniion that it would always run wherever I chose.
No matter what I try it always goes back ot the original cell it was first
recorded in.