VBA Formula for hiding/unhiding rows- Formula tweak

[varmoh]

Hi All,

I am using the below VBA code and its working fine if I want to hide the 2nd row to the 7th row below the target value, but if I want to use it to hide the 6th to the 10th row below that particular value, I am not able to. The code I am using is :

Please Login or Register  to view this content.

When I change the target.row+1 to target.row+5 it is not hiding the 5th, 6th and the 7th row, it hides only the target+5th row:

Please Login or Register  to view this content.

Please help!

[davesexcel]

Line 6 looks like it could be a problem

Please Login or Register  to view this content.

[varmoh]

Hi Davesexcel,

Thank you for you response

When I try using the below code, it does not give me the result I want
for e.g., If I enter the value in row 10 of column C, I want rows 15 to 17 to hide..similarly, when I choose enter the value in any rows I want the 5th to 8th row below it to hide but the below formula is hiding only row 12.

Please help!

Please Login or Register  to view this content.

[davesexcel]

I thought pointing out the line would give you a hint.

You have Rows(Target.Row + 4 & ":" & Target.Row + 2)
if the target.row is 1 then
target row+4 is 5
target.row +2 is 3


Look at your first code and see the difference.

[varmoh]

Sorry to sound stupid, I am using VBA for the first time!!!

That works but only hides one row, if I mention Rows(Target.Row + 4 & ":" & Target.Row + 2) it hides only the target+4 i.e, the 5th row, I want the 6th and the 7th row to be hidden as well... Is that possible! or am I missing something?

Thank you so much for your help and understanding!!

[davesexcel]

varmoh,

Change the 2 to a 7

Please Login or Register  to view this content.

[varmoh]

It is finally working they way I want, Thank you !!!!!... and apologies for not being able to understand the first time!!!