Difference between Last Row & Last Column VBA

[lsteinbach]

Hello,

I use lrow = Range("a" & Rows.Count).End(xlUp).Row quite often for the last row. Now I'm looking for the last column so I tried lcolumn = Range("6" & Columns.Count).End(xlLeft).Column but that does not work and I would love to know why.

My ultimate goal is to use the lcolumn variable to help my sort. I tried using activeworksheet.usedrange.columns.count, but that returned a number so I think that is why it did not work with Range("a6:" & lcolumn & "23").Select when selecting my sort range.

Thank you for any assistance!

Luke

[extremis]

can you put your entire coding please

[Solus Rankin]

try:

Please Login or Register  to view this content.

Remember this returns the last column as an integer (or long depending on how you have it DIMed) not a column letter.

[extremis]

try that..yuo put a 6 into range which is not suppose to

1 Column = Range("f" & Columns.Count).End(xlUp).Column

[Norie]

Luke

"6" & Columns.Count won't produce a valid address so it can't be use with Range.

Try using Cells instead.

For example to find the last column in row 6.

Please Login or Register  to view this content.

You can also use Cells for Range("a6:" & lcolumn & "23").Select, but in a slightly different way.

Please Login or Register  to view this content.

[extremis]

Please Login or Register  to view this content.

[xladept]

Here's a couple of finders for last column and last row that I copied from Was Wodge a while back:

Please Login or Register  to view this content.

[lsteinbach]

Thank you all for the fast and accurate replies. I was able to figure out how to select my range and go through the sort by using "Cells" instead of "Range". Funny how I always search for an answer for 2 hours, then I post, then I usually figure it out right after I post.
Thank you for your time, I'm sure I'll be posting again soon.

Luke

[extremis]

add reputation to the members that helped you and make the topic solved!