View Full Version : [SLEEPER:] Inserting Rows during Worksheet_Change Event
jammer6_9
06-16-2007, 07:53 AM
How can I insert rows when target range visible = true
Scenario is:
If range "B12" is visible then
Insert 3 rows after B12
Else
Do Nothing
lucas
06-16-2007, 07:56 AM
That would have the result of adding 3 rows...every time Range B12 is made visable. So you could wind up with a lot of added rows.....
lucas
06-16-2007, 07:58 AM
If range B12 is hidden then surely row 12 or column B is hidden...true?
If it is row 12 why not just have 3 blank rows below it and hide/show them at the same time?
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.