Macro use in different location

[Guest]

I create a macro (excel 2003)-security low or medium- in one location and
then when I try to run the macro in another location it just goes back and
repeats itself in the original location.

How do I get the macro to be independent of the originial creation location?

 

[Frank Kabel]

Hi
post your code

--
Regards
Frank Kabel
Frankfurt, Germany

I create a macro (excel 2003)-security low or medium- in one location and
then when I try to run the macro in another location it just goes back and
repeats itself in the original location.

How do I get the macro to be independent of the originial creation

location?

 

[Guest]

This is the code.
Thank you,

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 8/13/2004 by Steve
'
' Keyboard Shortcut: Ctrl+z
'
Range("B2495:H2495").Select
Selection.Copy
Range("B2496:H2496").Select
ActiveSheet.Paste
Range("B2496:H2496").Select
Selection.Font.Bold = True
Range("B2498").Select
End Sub

 

[Frank Kabel]

Hi
this is because the ranges are hardcoded within the code. You may
describe what you're trying to do. Do you want to paste always the
current selection to a specific range?

 

[Guest]

Hi,
I want to copy from a specific range on one line then
past that information in the same range on the next line below

Thank you,
Dersu