Last Empty Row in Range

  • Thread starter Thread starter dunnerca
  • Start date Start date
D

dunnerca

I have checked and seen many examples of how to find the last row in a column
by using

lastcell=.cells(.rows.count,1).end(xlUp)(2).select

However, that appears to look at the ENTIRE column. My data starts, say, in
row 15. How do I use the above code to look only at rows below row 15?

Thanks.
 

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

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
Paste in column B using Last row of either column B, C or D. 10
Return last row no. of column with blanks at top 7
End process at last row of data 3
i = row number of last occurance of duplicate string Column A 4
Copy to a mid column range Row 10 - Row 20 4
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Array with many cells from a row but not in order or together 11

Back
Top