| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer to worksheet
I want to refer to a worksheet that has a certain name. Now I write:
Set rapportWorksheet = "Rapport" That is I want to somehow be able to use this variable later and refer to the worksheet by the variable. That way I only have to change the name of the worksheet once in case I have to do that. Please help me with the syntax. Thanks very much! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refer to worksheet
Arne,
Set rapportWorksheet = ThisWorkbook/Activeworkbook/Workbooks("Whatever").Worksheets("Rapport") NickHK "Arne Hegefors" ... I want to refer to a worksheet that has a certain name. Now I write: Set rapportWorksheet = "Rapport" That is I want to somehow be able to use this variable later and refer to the worksheet by the variable. That way I only have to change the name of the worksheet once in case I have to do that. Please help me with the syntax. Thanks very much! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refer to worksheet
Set rapportWorksheet = Sheets("Rapport")
HTH Charles Arne Hegefors wrote: I want to refer to a worksheet that has a certain name. Now I write: Set rapportWorksheet = "Rapport" That is I want to somehow be able to use this variable later and refer to the worksheet by the variable. That way I only have to change the name of the worksheet once in case I have to do that. Please help me with the syntax. Thanks very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refer to last cell in worksheet? | Excel Worksheet Functions | |||
| Refer to more than one worksheet in a workbook | Excel Worksheet Functions | |||
| variable to refer to "this worksheet"? | Excel Worksheet Functions | |||
| Refer to Excel Worksheet by its name | Excel Worksheet Functions | |||
| Formula to refer to other worksheet... | Excel Worksheet Functions | |||
Linear Mode
