*Resolved* Hide/Show Shapes

[TheRobster]

I'm trying to write a short piece of VBA code which will first of all show a shape (to cover part of the worksheet whilst some calculations are performed) then to hide it again once the calculations are complete.

I thought it would be easy but the code I have doesn't work. The code basically goes like this:

Shapes("BoxOut1, BoxOut2, BoxOut3").Visible = True
Perform the calcuations
Shapes("BoxOut1, BoxOut2, BoxOut3").Visible = False

This just returns an error though.....I don't think the SHAPE function is something that VBA recognises. I also want to be able to hide/show the shapes without having to select them. I thought that Selecting the shapes first and then using WithSelection....to hide and show them again might work, but I'd rather just use a command and not select them.

Anyone have any ideas?

Cheers
-Rob