Run a macro in the active cell.
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! |
Run a macro in the active cell.
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! |
All times are GMT +1. The time now is 12:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com