Selecting hidden sheet

[AMAS]

Hi,

Is it possible to select a hidden sheet to do temporary calculations or do I have to unhide it and then hide it again everytime the macro runs.

Example:

Sheets("Temp").Visible = True
 
    Sheets("Temp").Select
    Range("A1").Select
 
    'more code
 
Sheets("Temp").Visible = False

Also is it possible to select the sheet and the range in one line? The following doesn't work:

Sheets("Temp").Range("A1").Select

Thanks.

AMAS

 

[AMAS]

Part of my work relates to checking the most up-to-date information from an online database. Each webpage I retrieve the date of last update and other information. Since the webpages are identical with the exception of the data, I have been able to identify which cells correspond to the data I need updated. So the code opens each webpage in the temp sheet then copies that information into the master database one webpage at a time. Sometimes the list is small (a couple of hundred) and others are massive (several thousands).

AMAS