To: Harald Staff with Rgds to Your Code
 

Hi Harald

First, I have to tell you that I'm amazed by your code because you hav
created an Excel camera!

I don't know whether you have seen my previous post but it's regardin
how I can select a range of cells without actually activating th
sheet.

The reason why I'm doing this is because I want to "pre-specify" th
cells that I want to capture as a gif... In your code, a dialog bo
will appear to ask for the range...

I have managed to modify your code to suit what I have in mind but th
problem is that I would need to activate the concerned sheet which
don't want it to happen...

Would you be so kind to show me how I can specify the range for th
dialog box using code and that the dialog box will not appear...???

Looking forward to a favourable reply from you soon...

Cheer

--
hc
-----------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351
View this thread: http://www.excelforum.com/showthread.php?threadid=26497