best training excel intermediate - Excel VBA

Hi Florence

Macros need to physically access the sheets that contain the data to be manipulated.

If a sheet is hidden the system cannot access it. To get around this:

In the code you need to unhide the relevant sheet, thenrun the relevant code and then rehide the sheet. The code is:

Sheets("Sheet3").Visible = True 'Unhides Sheet3

<The code to manipulate data>

Sheets("Sheet3").Visible = False 'Hides Sheet3

Hope this helps

Carlos