Macro command button to hide empty rows

A couple of comments. (1) Since you are already coding with VBA, why not use VBA to extract your information rather than use Lookups that will have blank rows? (2) If you do need the formulas, can you post a sample of your workbook so we can more easily code this for you?

Honestly, as I've had a lot less experience with macros, so I tend to use formula when I can.