Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to apply only to even number rows and NonBlank cells
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to apply only to even number rows and NonBlank cells
On Apr 22, 9:05*am, Dave Peterson 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate number of rows and apply formula | Excel Discussion (Misc queries) | |||
Macro that sums cells in rows of varible number and.... | Excel Programming | |||
count the number of nonblank cells within a range | Excel Programming | |||
How do I count nonblank cells in rows within Excel? | New Users to Excel | |||
Apply Excel Program to a Number of Rows | Excel Programming |