You can only select a cell on the active sheet.

--
Regards,
Tom Ogilvy

"Simon Lloyd " wrote in message
...
Hi Guys!

I have a macro that selects all sheets in an array, and then inputs the
value from a user form in the selected cell, but when i select another
cell on another sheet the activecell reverts to the last one
used.....any ideas on how to cure this?


---
Message posted from http://www.ExcelForum.com/