View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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