Hide rows between last row and row 100

[MasonSinclair]

Hi everyone,

Im looking for a macro that can hide all the rows between the last row of data and row 100, ive tried all sorts of things but always get a type mismatch error.. any help will be appreciated

[mohd9876]

Range(UsedRange.SpecialCells(xlCellTypeLastCell).Offset(1), Range("A100")).EntireRow.Hidden = True