Run a macro in the active cell.

  • Thread starter Thread starter Jasmine
  • Start date Start date
J

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!
 
make all your references relative to the active cell

set rng = activecell.offset(10,30)

as an example.
 
Back
Top