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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the value in multiple sheets without selecting those sheets
You can prevent display updating by adding row
Application.Screenupdating=False in the beginning of your code. Ecco -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the value in multiple sheets without selecting those sheets
Hi,
1. You stop the flashing by using Application.Screenupdating=False at the beginning of the code. Do not forget to add Application.Screenupdating=True at the end. 2. There is no need to select things: sheets("sheet2").select Range ("a1").select Activecell.formularR1c1= "true" Can be improved to: sheets("sheet2").Range("a1").formulaR1c1= "true" Regards, Jan Karel Pieterse Excel TA/MVP -----Original Message----- 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the value in multiple sheets without selecting those sheets
Thanks Jan Karel Or shall I say dankie boet You realy gave me a good tip there it works like a charm *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
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 |