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

On Fri, 14 Sep 2007 12:48:05 -0700, rk0909 <(E-Mail Removed)>
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

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


"Gord Dibben" wrote:

> 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 <(E-Mail Removed)>
> 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
>
>

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

On Fri, 14 Sep 2007 16:54:00 -0700, rk0909 <(E-Mail Removed)>
wrote:

>thanks yes thats the problem when I try to record the macro it doesn't
>capture the F2 key stroke. Anyway around it?
>
>
>"Gord Dibben" wrote:
>
>> 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 <(E-Mail Removed)>
>> 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
>>
>>

Can you post your code please?

"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