macro to apply only to even number rows and NonBlank cells
in [Programming]
|
Prev: userform problems with copy/paste and drop-downs
Next: How to change the font size of Data Validation in drop-down me
From: Billy on 22 Apr 2010 08:48 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
From: Dave Peterson on 22 Apr 2010 09:05 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
From: Billy on 22 Apr 2010 11:37
On Apr 22, 9:05 am, Dave Peterson <peter...(a)verizonXSPAM.net> wrote: > 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 Thanks so very much Dave. Works perfect! You MVPs [and of course some non-MPVs also) sure add value to Excel! Thanks again, Tonso |