| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AUTOMATICALLY CHANGING DATA FROM CELLS ON DIFF SHEETS | Excel Worksheet Functions | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| How do I drag a formula keeping cells the same but changing sheets | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Changing Selection for the "Center Across Selection" alignment | Excel Discussion (Misc queries) | |||
![Simon Lloyd[_477_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
