Yes of course you can still hide it, but as there is no data, there is no end of data, so there is no way of knowing where to stop.
Or do you want to hide them all except 50? If so, maybe
BTW, why would you use Excel for a periodic table?Rows(k & ":" & Rows.Count - k + 1).Hidden = True
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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' ...
Posting Permissions
Reply With Quote