What I want to do is hide all rows on a sheet below the last row with data.
I can find the last row;
But when I try this:
I can find the last row;
Code:
lastrow = Range("A65536").End(xlUp).Row
But when I try this:
Code:
ActiveSheet.Rows(lastrow + 4 & "65536").Hidden = True
[\code] or
[code]
Range(Rows(lastrow & "65536")).Select
Selection.Hidden = False
[\code]
it errors out. I know the solution to this has to be something I'm blind to.
Thanks.