| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through all worksheets
It IS widely accepted coding practice that selections/activations should be
avoided where ever possible. It is not merely a matter of style as it slows down the code, etc. -- Don Guillett SalesAid Software "davidm" wrote in message ... Don, There is need to activate if the respective sheets are not referenced. It's all a matter of style to use For each sht in Worksheets sht.Range("E28").Value = sht.Range("G28") Next or For each sht in Worksheets sht.activate Range("E28").Value = Range("G28") Next David -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=495959 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut key to cycle through worksheets in the same workbook | Excel Discussion (Misc queries) | |||
| How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
| How do I cycle through all of the worksheets | Excel Discussion (Misc queries) | |||
| How do I cycle through all of the open worksheets? | Excel Discussion (Misc queries) | |||
| Cycle thru worksheets in a workbook | Excel Programming | |||
![Don Guillett[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
