Related:
- Finding the last used Column
- Formula for finding position in excel ✓ - Excel Forum
- How to convert row to column in notepad++ ✓ - Excel Forum
- Finding @ on keyboard - Guide
- Formulas for 1st and 2nd position in class - Office Software Forum
- Excel copy column from one sheet to another automatically - Guide
2 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.