| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the value in multiple sheets without selecting those sheets
I have a workbook with 10 sheets and currently use the formula
sheets("sheet2").select Range ("a1").select Activecell.formularR1c1= "true" and repeat this for sheet3,4,5 and so on Note not all the values are identical some are true and some false Because the VBA sub has to then jump to every sheet and then enter the value it creates a flashing effect that irritates the hell out of me Is there a code where it will make those changes in other sheets without activating those sheets first PLEASE Help Thanks Herman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Header on Multiple Sheets without Changing Other Formatting | Excel Discussion (Misc queries) | |||
| vba for selecting multiple sheets to save as a new book | Excel Worksheet Functions | |||
| Changing dates on multiple sheets | New Users to Excel | |||
| Selecting Multiple Sheets in VBA | Excel Worksheet Functions | |||
| selecting multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
