View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
WSI
 
Posts: n/a
Default Range from x to first non-blank cell?

Hi Bill -
Do you simply want to highlight it? If you click on the first cell, then
hold down ctrl+shift, then hit the down arrow it will highlight everything
until the first blank cell. If you just want to find the next blank cell and
not highlight, only use ctrl and hit the down arrow.
Hopefully this helps


"Bill" wrote:

How do I do a column range from a starting cell until the first non-blank cell?

Also, is there a function, etc. that will return the row number of the first non-blank
cell in a column?

Thanks!