I need help writing a code

[TLS49]

NFL SCHEDULE.xlsb
	A	B	C	D	E	F	G	H	I	J	K	L
1	1		NFL GAMES PICK THEM					2020			HOME
2	GAMES	ROAD TEAM PICK	ROAD TEAMS	ROAD SCORES	VS	HOME TEAM PICK	HOME TEAMS	HOME TEAM SCORES
3	1		TEXANS	0	VS		CHIEFS	0			GOT RIGHT	0
4	2		SEAHAWKS	0	VS		FALCONS	0			GOT RIGHT %
5	3		JETS	0	VS		BILLS	0
6	4		RAIDERS	0	VS		PANTHERS	0			GOT WRONG	0
7	5		BEARS	0	VS		LIONS	0			GOT WRONG%
8	6		COLTS	0	VS		JAGUARS	0
9	7		PACKERS	0	VS		VIKINGS	0			BYE WEEKS	TEAMS
10	8		DOLPHINS	0	VS		PATRIOTS	0			1
11	9		BROWNS	0	VS		RAVENS	0			2
12	10		EAGLES	0	VS		REDSKINS	0			3
13	11		CHARGERS	0	VS		BENGALS	0			4
14	12		BUCCANEERS	0	VS		SAINTS	0			5
15	13		CARDINALS	0	VS		49ERS	0			6
16	14		COWBOYS	0	VS		RAMS	0
17	15		STEELERS	0	VS		GIANTS	0
18	16		TITANS	0	VS		BRONCOS	0
PICK THEM WEEK 1

it is highlight L10:L15 I want select B3 without select worksheet

Sheets("PICK THEM WEEK 1") Range("B3").Select

Thanks You

Thomas

 

[mikerickson]

To select a cell the sheet its on must be the ActiveSheet.

 

[Michael M]

You can't select a cell on another sheet without activating that sheet.
But, in most cases you don't need to Select a cell. You could use a with statement instead.....but we would need more infor mation.

 

[alvisonhunter]

Hello there, TLS49

There are a pair of factors that we need in order to assist you since your statement is not clear enough. However, for the little I happened to catch it seems that you would like cell B3 to get selected when you open this workbook. If that is the case and you only have this sheet on the book, let us go ahead and try the code below:

Private Sub Workbook_Open()
'This will select cell B3 in the worksheet you have opened
ActiveSheet.Range("B3").Select
End Sub

If you have more than one sheet, then we will have to change this code to adapt it to the sheet activate event that you want this code to be implemented on. I certainly hope this helps and mostly this is the help you were looking for. Please forgive me if I did not get your idea that clear, but it was way to concise and details are also important to understand the problem. Cheers mate!

Private Sub Worksheet_Activate()
'This will select cell B3 in the worksheet you have opened
Me.Range("B3").Select
End Sub