Last Column and Last Row


G

Guest

I'm trying to select from A2, all the way to the last column down to the last
row of the current data set to do some formatting. This code is not working
because I am unable to find a way to select that range once I have last
column and lastrow set. Could I get some assistance with that? THANKS!!!

Dim LastColumn As Long
LastColumn = Range("A1").End(xlToRight).Column
LastRow = Cells(Rows.Count, "A").End(xlUp).Row

' THIS part is incorrect
Range("A2" & LastColumn & LastRow).Select
 
Ad

Advertisements

Ad

Advertisements

G

Guest

worked perfectly, thanks for that. After some experimenting I came close to
that, but I don't think I would have figured it out anytime soon, that saved
me a ton of time, HA!!! 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


Top