View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AUCP03 AUCP03 is offline
external usenet poster
 
Posts: 20
Default Define range by last cell in column?

I have a userform listbox. This list box is currently populated by range
A4,F173 Column F is the only one with an entry in every used row. All rows
from A4 to F(last row) will have data in them, but not in all columns except
for column F. How can I define this range to capture the range from
A4,F(last used)?