absolute cell reference macro

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
 
G

Gord Dibben

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
 
G

Guest

thanks yes thats the problem when I try to record the macro it doesn't
capture the F2 key stroke. Anyway around it?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

in cell editing macro 2
Change a cell reference from relative to absolute 2
Absolute and Relative Cell References 1
absolute reference in linked files 3
What is the key shortcut for absolute cell reference? 4
Macro Code 2
Pasting cell contents into a macro 1
How do I record a macro with relative cell addresses? 1

Top