View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_477_] Simon Lloyd[_477_] is offline
external usenet poster
 
Posts: 1
Default cells not changing selection after sheets array

Hi Guys!

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

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