absolute cell reference macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
thanks yes thats the problem when I try to record the macro it doesn't
capture the F2 key stroke. Anyway around it?
 
You can probably code to make the changes you need without going into edit mode.

Without an idea of what you are trying to do and in the absence of any posted
code, very difficult to answer "any way around it?"


Gord
 
Back
Top