View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default Web query question.

Charles < wrote:
Beto,
The folling code works with the sheet hidden. At it does on my system.


Hi,

I hadn't even tried it without unhiding and rehiding the very hidden
sheet, because I thought I needed to Select it. Now I tried using
Activate as in your code and it works fine, no need of unhiding and
rehiding. I don't even need to turn off ScreenUpdating. Thanks!

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.