Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way?
I'm a beginner with macros but am quickly realizing how they can make
everything easier. I'd like to create a macro that Replaces all cells that have $J$2 in the formula with $J$3. I have a cell (we'll call it H1) that sums up hundreds of other cells (sum normally will equal 0). After Find/Replacing $J$2 with $J$3, I want the macro to look at H1. If H1 still equals 0, then I want to replace $J$3 with $J$4. If H1 still equals 0, I want to replace $J$4 with $J$5. I want everything to stop when H1 equals anything other than 0. Then, I would like to run it again - but starting from the next one where I left off (so I don't want to start at $J$2 again). I'm not sure if this is possible --maybe a prompt asking what row to start with? |