Hide rows after last entry macro

[Buns1976]

Hi Everyone,

We import approximately 400 rows of data into a spreadsheet. I would like to hide all rows after the last entry with a macro.
The caveat is that the last populated row is not the same each day so today might be 374 and tomorrow might be 402.

Any help would be appreciated!

Thanks

 

[Fluff]

How about

Sub Buns1976()
   Range(Range("A" & Rows.Count).End(xlUp).Offset(1).Row & ":" & Rows.Count).EntireRow.Hidden = True
End Sub

 

[Buns1976]

Hi Fluff,

That hides all the rows in the sheet! We just want to hide rows after the last entry please.

Thanks

 

[Fluff]

Which column will always have a value on the last row?

 

[Buns1976]

Hi Fluff,

My bad. I missed "A". Changed to "B" and all is good. Sorry!
Quick question off topic a bit. I'm running a macro that inserts
today's Date in B2. In the formula bar I see 4/4/2019 but cell B2
is blank?

Thanks a bunch!

 

[Fluff]

You're welcome & thanks for the feedback

Sounds like you either have conditional formatting on that cell, or a custom number format.

 

[Fluff]

Another possibility is the font is the same as the fill colour.

 

[Buns1976]

Hi Fluff,

or white text on a white background.....I'm losing my mind!!

Thanks again!