Hi guys. I am trying to run a macro to delete blank rows within a range on all the worksheets in a workbook. Here is what i got so far and is not working. thanks for any help you can provide.
Sub SheetTest()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Sheets
MsgBox ws.Name...