View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mika Mika is offline
external usenet poster
 
Posts: 48
Default Select non empty cells

Hi guys/gals

I want to select (VBA) the non empty cells within a given range, like
given a1:c4 only the cells below, that are non empty, will be
selected. I tried combinations of intersect with specialcells but
unsuccessfully.

a1 c1
b2
a3 c3
a4b4

Thanks for your time,
Mika