Run a macro in the active cell.

[Jasmine]

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!

 

[Tom Ogilvy]

make all your references relative to the active cell

set rng = activecell.offset(10,30)

as an example.