i am using excel 2000.

i am very new to making macros. the macro im trying to make would
probably take most people five minutes, but im unable to pull it off.

let me be more descriptive, ive made the macro but it is relative; i
want it to be absolute. what i mean it only works from the one cell i
created it in. i need it to work all over the spreadsheet on multiple
worksheets.

if i seem unclear, please reply and i will be more descriptive.

thx.


---
Message posted from http://www.ExcelForum.com/

You have it reversed. Your macro is absolute and you want it relative.

When you start recording, the stop recording toolbar has a stop recording
button and a button next to it. This second button toggles between absolute
and relative recording.

After you start recording, click the absolute/relative toggle to start
recording in relative mode.

--
Regards,
Tom Ogilvy

t00thless wrote in message
...
i am using excel 2000.

i am very new to making macros. the macro im trying to make would
probably take most people five minutes, but im unable to pull it off.

let me be more descriptive, ive made the macro but it is relative; i
want it to be absolute. what i mean it only works from the one cell i
created it in. i need it to work all over the spreadsheet on multiple
worksheets.

if i seem unclear, please reply and i will be more descriptive.

thx.


---
Message posted from http://www.ExcelForum.com/

t00thless,

if i seem unclear, please reply and i will be more descriptive.
Could use a littlte bit more info

ive made the macro
Post the code that you have (so far)

John


"t00thless " wrote in message
...
i am using excel 2000.

i am very new to making macros. the macro im trying to make would
probably take most people five minutes, but im unable to pull it off.

let me be more descriptive, ive made the macro but it is relative; i
want it to be absolute. what i mean it only works from the one cell i
created it in. i need it to work all over the spreadsheet on multiple
worksheets.

if i seem unclear, please reply and i will be more descriptive.

thx.


---
Message posted from http://www.ExcelForum.com/