I want to hide row 50, 51, 52, 53, ...
Like the small screenshot i posted, the space is grey there, no rows are shown...

It's not my choice to make this in Excel, we have to create this table using VBA (we wont insert the data manually), it's sort of like my 'homework' ...