VB Column Width and Sheet Name
Closed
hsolo30k
Posts
2
Registration date
Wednesday June 5, 2013
Status
Member
Last seen
June 5, 2013
-
Jun 5, 2013 at 01:19 PM
hsolo30k Posts 2 Registration date Wednesday June 5, 2013 Status Member Last seen June 5, 2013 - Jun 5, 2013 at 05:13 PM
hsolo30k Posts 2 Registration date Wednesday June 5, 2013 Status Member Last seen June 5, 2013 - Jun 5, 2013 at 05:13 PM
Related:
- VB Column Width and Sheet Name
- Google sheet right to left - Guide
- Little alchemy cheat sheet - Guide
- Mark sheet in excel - Guide
- Windows network commands cheat sheet - Guide
- How to screenshot excel sheet - Guide
2 responses
Good Afternoon.
I hope this is what you were looking for...this is the first problem.
This is the VBA code and not a formula.
=Columns("B:B").EntireColumn.AutoFit
The second Answer....
is something like .....
Sheets(1).Name = "thenewname"
Once again , through VBA and not a formua.
I hope this is what you were looking for...this is the first problem.
This is the VBA code and not a formula.
=Columns("B:B").EntireColumn.AutoFit
The second Answer....
is something like .....
Sheets(1).Name = "thenewname"
Once again , through VBA and not a formua.
hsolo30k
Posts
2
Registration date
Wednesday June 5, 2013
Status
Member
Last seen
June 5, 2013
Jun 5, 2013 at 05:13 PM
Jun 5, 2013 at 05:13 PM
Thanks, this helped get me sorted out!