macro to apply only to even number rows and NonBlank cells
if activecell.row mod 2 = 0 then
'it's an even row
if isempty(activecell.value) then
'it's empty
Billy wrote:
I want a macro to be useable only on even number rows, AND
NonBlankcells. I need something like an If Then statement? Like If
ActiveCell.Row _______ Then Exit Sub? Thank you for your help.
Tonso
--
Dave Peterson
|