Macro will not hide all rows

[Nataliec27]

Morning all,

I am using code in my sheet to hide rows:

Please Login or Register  to view this content.

and much the same to unhide (the code is included in the example workbook).

For some reason on this worksheet with this code I cannot figure out a way to hide all the rows where row "J/K" is empty. I have tried adding in another column (I) where I put an if statement produce either a "1" or "0" and then change the code to act on this column instead but I still cannot get all the rows to hide.

The reason I am now seeing this problem (I think) is because I want to be able to enter values in column "B" but not have a price for them, and thus those rows to be hidden. In the example workbook as is rows 68 and 81 will not hide with the macros I currently have.

I am fairly new to VBA and actually got this code from good old google. So any help would be greatly appreciated.

Thankyou!!

[TMS]

Sorry, response not suitable ... thought you were deleting rows.

[mohadin]

Hi
What about

Please Login or Register  to view this content.

[Nataliec27]

Thankyou for your reply.

I have tried this in column "L" (12), where the formula returns "" if one of the other cells is empty however, it did not work and I still could not hide those rows!!

[vcoolio]

Hello Natalie,

I believe that the problem is the merged cells (Columns J:K). Merged cells create havoc within VBA and should be avoided altogether. Try un-merging the cells then run the code.

Cheerio,
vcoolio.

[mohadin]

Please Login or Register  to view this content.

??????

[Nataliec27]

Thankyou vcoolio., I did try this and it did not work.

[Nataliec27]

Thankyou Mohadin - I used this code, but changed it to column 2 and it now works.

[mohadin]

You are welcome
Glad I could help
Thank you for the feedback
be happy & safe

[vcoolio]

Hi Natalie,

I just received notification of your reply.

Thanks for the feed-back and the rep.

I feel that the loop-type code may be a little slow so, if you're interested, you can use AutoFilter to do the same job. The following codes are based on your idea of using Column I with the 1 or 0 criteria:-

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

The end result is the same.

If you're happy with your solution in posts #6 and 8 then just keep the above up your sleeve for future reference.

I hope that this helps.

Cheerio,
vcoolio.