View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default absolute cell reference macro

Post the code you have but one caveat...........the macro recorder will not
record anything while you are in Edit mode so that may be your problem.

Also, macros won't run when in Edit mode.


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 12:48:05 -0700, rk0909
wrote:

All,

I tried recording a macro that edits a cell and copied the formula from in
that cell and pasts it elsewhere.

When I record the macro - it doesnt recognize what Im trying to do. Any
ideas ?

I don't want to use absolute reference but want a macro or excel shortcut
for copying the contents of a cell to any other cell.

Thanks,

RK