ExcelBanter - Go To First Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Go To First Sheet (https://www.excelbanter.com/excel-programming/351829-go-first-sheet.html)

LaraBee[_6_]

Go To First Sheet

Can somebody help me please with VBA coding that activates the firs
sheet in a workbook. The trick is the name of the first sheet wil
vary, so it cannot be just Sheets("Sheet X").Select. Thanks

--
LaraBe
-----------------------------------------------------------------------
LaraBee's Profile: http://www.excelforum.com/member.php...fo&userid=3027
View this thread: http://www.excelforum.com/showthread.php?threadid=50644

Dave Peterson

Go To First Sheet

sheets(1).select

LaraBee wrote:

Can somebody help me please with VBA coding that activates the first
sheet in a workbook. The trick is the name of the first sheet will
vary, so it cannot be just Sheets("Sheet X").Select. Thanks!

--
LaraBee
------------------------------------------------------------------------
LaraBee's Profile: http://www.excelforum.com/member.php...o&userid=30275
View this thread: http://www.excelforum.com/showthread...hreadid=506441

--

Dave Peterson

Kevin B

Go To First Sheet

ActiveWorkbook.Worksheets(1).Activate

--
Kevin Backmann

"LaraBee" wrote:

Can somebody help me please with VBA coding that activates the first
sheet in a workbook. The trick is the name of the first sheet will
vary, so it cannot be just Sheets("Sheet X").Select. Thanks!

--
LaraBee
------------------------------------------------------------------------
LaraBee's Profile: http://www.excelforum.com/member.php...o&userid=30275
View this thread: http://www.excelforum.com/showthread...hreadid=506441

LaraBee[_7_]

Go To First Sheet

so, it is that simple :-)

The 1 in parenthesis represents the sheet position in the workbook

--
LaraBe
-----------------------------------------------------------------------
LaraBee's Profile: http://www.excelforum.com/member.php...fo&userid=3027
View this thread: http://www.excelforum.com/showthread.php?threadid=50644

Dave Peterson

Go To First Sheet

Yep.

LaraBee wrote:

so, it is that simple :-)

The 1 in parenthesis represents the sheet position in the workbook?

--
LaraBee
------------------------------------------------------------------------
LaraBee's Profile: http://www.excelforum.com/member.php...o&userid=30275
View this thread: http://www.excelforum.com/showthread...hreadid=506441

--

Dave Peterson

All times are GMT +1. The time now is 05:34 PM.