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
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
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
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.....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
