Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro-active cell | Excel Discussion (Misc queries) | |||
move from active cell offset in macro | Excel Discussion (Misc queries) | |||
Active cell position for macro | Excel Worksheet Functions | |||
how to create a macro that references the currently active cell | Excel Worksheet Functions | |||
copy name from active sheet to cell - using macro or function | Excel Worksheet Functions |