Related:
- Finding the last used Column
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
- Ps3 not finding update on usb - Guide
- Finding @ on keyboard - Guide
- Excel vba find last non empty cell in column - Guide
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Oct 20, 2015 at 05:31 AM
Oct 20, 2015 at 05:31 AM
Hello Al,
See if this is what you are wanting:-
Cheerio,
vcoolio.
See if this is what you are wanting:-
Sub FindLastColumn()
Dim lCol As Long
lCol = Sheet1.Cells(1, Columns.Count).End(xlToLeft).Column
Columns(lCol).Select
MsgBox "The last column used is...." & lCol
End Sub
Cheerio,
vcoolio.
Thanks for the reply, I should of said, I wanted to do it in WB not VBA
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 22, 2015 at 11:38 AM
Oct 22, 2015 at 11:38 AM
then use FIND
Al
>
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
Oct 23, 2015 at 07:05 AM
Oct 23, 2015 at 07:05 AM
Thank you for that. Could you please give a little more info. How do I use 'FIND'?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
>
Al
Nov 2, 2015 at 02:50 PM
Nov 2, 2015 at 02:50 PM
I stand corrected. Find will not easily work for you. A VBA code is needed
Al
>
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
Nov 3, 2015 at 10:24 AM
Nov 3, 2015 at 10:24 AM
Thanks anyway.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 3, 2015 at 12:01 PM
Nov 3, 2015 at 12:01 PM
You can use CONTROL + END. It should stop at the intersection of max row used and max column used.
