Is there a way?
- From: Kevin W <KevinW@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 26 Sep 2008 08:41:01 -0700
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?
.
- Follow-Ups:
- RE: Is there a way?
- From: Sean Timmons
- RE: Is there a way?
- From: JLatham
- RE: Is there a way?
- Prev by Date: Re: Charts not printing in the location I assign on worksheet
- Next by Date: RE: Suppress worksheet delete verification msgbox
- Previous by thread: Move cursor 5 rows down
- Next by thread: RE: Is there a way?
- Index(es):
Relevant Pages
|
