make all your references relative to the active cell

set rng = activecell.offset(10,30)

as an example.

--
Regards,
Tom Ogilvy

"Jasmine" wrote in message
...
I have created a macro that sums up amounts in for columns
and then performs a calculation in the last column. This
macro was saved in the personal workbook and will be used
on several different worksheets. I want it to start in the
active cell, which will be different dpending on which
worksheet is open. How do I do this? Thanks!