I Filter range A9:AG300 using listbox(userform) hide all from range blank cells

[HaroonSid]

hello
I m using filter range A9:AG300 using listbox.

when i click filter any one item from listbox, in range A9:AG300 blank cells are not hiding

i want to hide all blank cells
i mean show only filtered result in range A9:A300 hide all blank and other cell

[:) Sixthsense :)]

Replace your current code with the below one

Please Login or Register  to view this content.