A basic VB script--help the newbie?
Hi,
I think I got the wrong books for learning how to program in VBA...
I need to do the following:
if cell below current cell has the same value
and the three cells to the right of the cell below current cell have
no value
delete entire row of the cell below the current cell
repeat until different value in next cell down found
EX:
11FF07 54.90 58.90 64.23
11FF07 (blank) (blank) (blank)
11FF07 (blank) (blank) (blank)
11C 56.98 123.34 57.78
So this macro/script would see that the next 11FF07 down has no prices
(blank values) in the three cells next to it, and delete that row, and
continue down, see that the next 11FF07 down has no value either,
delete that row, continue down, and notice the next cell contains a
different value and stop.
Can anyone help with this? This isn't something I can figure out how
to "tell" the macro recorder to do with actions.
Thanks,
Gabe
|