PDA

View Full Version : 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?