macro to apply only to even number rows and NonBlank cells

  • Thread starter Thread starter Billy
  • Start date Start date
B

Billy

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
 
if activecell.row mod 2 = 0 then
'it's an even row


if isempty(activecell.value) then
'it's empty
 
if activecell.row mod 2 = 0 then
  'it's an even row

if isempty(activecell.value) then
  'it's empty
Click to expand...

Thanks so very much Dave. Works perfect! You MVPs [and of course some
non-MPVs also) sure add value to Excel!

Thanks again,

Tonso
 
Back
Top