How to Hide a block of blank cells

[Art-tt]

Hello People.

It has been some 20 years since I played with Excel and now suddenly I find myself with a range of data (200 rows) has one column (O, starting O20) with either values or blanks (redundant), where the redundant blank rows need to be hidden.

Sorting will collect the rows of data leaving a block to be easily be hidden - or so I hope.

I have my end cell (O220).

I have my start cell (O20) and using:

Selection.End(xlDown).Select

takes me to the end of the required data.

Unfortunately moving one cell further down does not provide a cell reference with which to select the block to hide.

Any suggestions?

Thanks.

 

[GlennUK]

Why not just filter your data to hide the blank rows?

 

[Art-tt]

Hello Glenn,

Duh! Well, rust has obviously taken a good foothold in the intervening 20 years. I think this suggestion will work well in this instance, so many thanks.

Arthur

 

[GlennUK]

Hello Glenn,

Duh! Well, rust has obviously taken a good foothold in the intervening 20 years. I think this suggestion will work well in this instance, so many thanks.

Arthur

Hello Arthur,

ha ha ... I hope your rusty parts start working again soon. Glad to help