Copying through last row with data

[cheesiepoof05]

I have this code that I am using within a much larger code. "Rows("11:10000").Select". I'm trying to select row 11 through the last row with data in it. Not all of column A has values so it need to check the entire row. I'm currently going to row 10,000 just to make sure I capture everything, but it creates a lot of extra rows I don't need. I'm looking for code that will select row 11 through my last row with data. Thanks for any help.

 

[Joe4]

Try this instead:

Rows("11:" & Cells(Rows.Count,"A").End(xlUp).Row).Select

 

[MARK858]

Not all of column A has values so it need to check the entire row

Another option...

Rows("11:" & Cells.Find("*", , xlValues, , xlByRows, xlPrevious).Row).Select

 

[cheesiepoof05]

@Joe4 and @MARK858. Thank you both so much for your help. I tested both methods out and ultimately went with "Rows("11:" & Cells.Find("*", , xlValues, , xlByRows, xlPrevious).Row).Select" because it accounts for the possibility of column A being blank for the last few rows, when the other columns still contain data. The other solution would probalby work 99% of the time for me, I just wanted to be absolutely sure I didn't drop data. Again, thank you both!

 

[Joe4]

You are welcome.
Yes, my solution only works if column A is always populated for every row of data. Sorry I missed that part in your original request.
Mark's approach should work better for you.