Macro use in different location

D

dersu

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?
 
F

Frank Kabel

Hi
post your code :)

--
Regards
Frank Kabel
Frankfurt, Germany

dersu said:
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
Click to expand...
location?
 
D

dersu

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
 
F

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?
 
D

dersu

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
 
Top