Hi guys I just cant figure this one out figure I'd ask...
need to tell vba to find all the most active cells in a sheet (i am using autofilter) so thought maybe a lastrow variable and then format it the row with a height of 50. This is what I came up with:
Dim LastRow As Long
LastRow = Range("D65536").End(xlUp).Row
ActiveSheet.Rows("7:Lastrow").RowHeight = 50
Please help!
need to tell vba to find all the most active cells in a sheet (i am using autofilter) so thought maybe a lastrow variable and then format it the row with a height of 50. This is what I came up with:
Dim LastRow As Long
LastRow = Range("D65536").End(xlUp).Row
ActiveSheet.Rows("7:Lastrow").RowHeight = 50
Please help!
