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

It's for use in a cell formula.

"WSI" wrote in message
...
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!