Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy question
Hi there,
Can you tell when one has to reference a cell by the spreadsheet name it belongs to and when it is not required? Calling this sub from Sheet1 Sub Button1 Worksheets("Sheet2").Activate Range("A3").Select End Return Range("A3") from Sheet1 #1: Is the solution to use Worksheets("Sheet2").Range("A3")? #2: Is the solution to use use named range (unique for the workbook) for Worksheets("Sheet2").Range("A3") and then reference this name directly Thanks Ben |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy question
You have to reference the sheet as well when the sheet that you want is not
the active sheet, or that you don't know it is the active sheet. It is probably good practice to always use a sheet reference. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "londono001" wrote in message ... Hi there, Can you tell when one has to reference a cell by the spreadsheet name it belongs to and when it is not required? Calling this sub from Sheet1 Sub Button1 Worksheets("Sheet2").Activate Range("A3").Select End Return Range("A3") from Sheet1 #1: Is the solution to use Worksheets("Sheet2").Range("A3")? #2: Is the solution to use use named range (unique for the workbook) for Worksheets("Sheet2").Range("A3") and then reference this name directly Thanks Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy Question - Please help | Excel Discussion (Misc queries) | |||
Easy Question | Excel Worksheet Functions | |||
If - easy question | Excel Discussion (Misc queries) | |||
Easy Question | Excel Programming | |||
new user with easy question? not easy for me | New Users to Excel |