I managed to record a macro. It is about 5 lines long.
I would like to run it whereever I need it. However I can only run it in
the same cell each time. How would I change this? Thank you.

You'll have to edit your recorded macro.

I can help!


--
AP

"ED" a écrit dans le message de
...
I managed to record a macro. It is about 5 lines long.
I would like to run it whereever I need it. However I can only run it in
the same cell each time. How would I change this? Thank you.

How do I edit a macro?

"Ardus Petus" wrote:

You'll have to edit your recorded macro.

I can help!


--
AP

"ED" a écrit dans le message de
...
I managed to record a macro. It is about 5 lines long.
I would like to run it whereever I need it. However I can only run it in
the same cell each time. How would I change this? Thank you.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

You may want to post your code here to get a little help. And include what the
macro is supposed to do.



ED wrote:

How do I edit a macro?

"Ardus Petus" wrote:

You'll have to edit your recorded macro.

I can help!


--
AP

"ED" a écrit dans le message de
...
I managed to record a macro. It is about 5 lines long.
I would like to run it whereever I need it. However I can only run it in
the same cell each time. How would I change this? Thank you.




--

Dave Peterson

You can create a Drawing Object, such as a rectangle, or circle, etc using
the Drawing Toolbar....then Right-click on the object and select "Assign
macro" from the dropdown, and then select your macro from the window and
click OK.......next time you can run the macro just by clicking on the
object........

hth
Vaya con Dios,
Chuck, CABGx3



"ED" wrote:

I managed to record a macro. It is about 5 lines long.
I would like to run it whereever I need it. However I can only run it in
the same cell each time. How would I change this? Thank you.

Post the code.

You probably have a line before the change like

Range("B2").Select

which should be deleted.

Or you have a piece of code like

Range("B2").FormulaR1C1 = "abc"

which needs to be changed to

ActiveCell.FormulaR1C1 = "abc"

If it's not these, then post your code.

"ED" wrote:

I managed to record a macro. It is about 5 lines long.
I would like to run it whereever I need it. However I can only run it in
the same cell each time. How would I change this? Thank you.