How do I refer to a non-empty row range in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I refer a row range, say C1:Cx where x is the last non-empty row in
the C column, but x may change from time to time.
Thanks.
Please reply to (e-mail address removed).

Henry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Copy Conditional Formatting? 1
Help on Macro to hide empty rows 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Why doesn't excel count function update automatically? 1
Go to last non-empty cell in column 8
Next to last non-empty cell in row 8
absolute cell references 1

Back
Top