Hiding Cells dependent on value being =""

[Jim McEwan]

Hi all,

I have a report that generates onto a spreadsheet using various functions. All the functions return ("") when the cells are empty. Because the report can vary from 10-20 rows of information, up to thousands of rows - I cannot figure out how I can print (or save as PDF) the report so it just select the Cells that don't return ("").

The good news is that the report collates all the information to the top of the list, so that the ("") only show after the information I want. So I feel that the best way to approach this is for some VBA that hides and unhides the information needed to print.

It needs to be quick though, so I will hide cells at first. Then the VBA will look for cells that contain information and unhide them. Then it will look for any unhidden cells that contain ("") and hide them, thus bypassing the need to hide the entire spreadhseet rows.

I only need to use column range (W20:W) to look for the ("").

I really hope I have explained myself well enough. Hope to hear a solution soon.

Thanks,

Jim

[Solus Rankin]

Maybe this? I didn't follow your reasoning for needing to hide them all first.

Sub HideThese()
Dim rng As Range

For Each rng In Range("W20:W" & Range("W" & Rows.Count).End(xlUp).Row)
    If rng.Value = """""" Then
        rng.EntireRow.Hidden = True
    End If
Next rng
    
End Sub