View Single Post
  #1   Report Post  
Louise
 
Posts: n/a
Default HELP - Running Macros in VBA

Why (&%ยค#"!!!) are my macros in VBA not running? I have copied small Macros
from reliable sources on the Internet to Modules in Excel, but I can't make
them run?! What can I be doing wrong?

One example:

Sub DeleteBlankRows2()
'Deletes the entire row within the selection if _
some of the cells WITHIN THE SELECTION contain no data.
On Error Resume Next
Selection.EntireRow.SpecialCells(xlBlanks).EntireR ow.Delete
On Error GoTo 0
End Sub