Refer to worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Arne,
Set rapportWorksheet =
ThisWorkbook/Activeworkbook/Workbooks("Whatever").Worksheets("Rapport")

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell reference 3
setting one worksheet cell range reference to another worksheet 1
How to force macros refer to ActiveWorkbook 2
Please help! Cannot open pivotTable source file.... 2
Making worksheets 3
Possible to refer to a sheet's object name ? 10
set/get value of checkbox (controltoolbox) 1
copying a template sheet and inputting a formula into another sheetthat references the new sheet 1

Back
Top