Thread
:
HELP - Running Macros in VBA
View Single Post
#
5
Louise
Posts: n/a
I enter a workbook. Open the MVB editor. I put the code in a module (Insert
Module) in the Modules folder under the VBAProjects (PERSON.XLS), and I tried
to run the Macro from the workbook which I have entered Microsoft Visual
Basic through. Is this right?
"Don Guillett" wrote:
I just placed this macro into a REGULAR module and it ran fine by f5 at the
macro.
Where did you put it and how are you trying to execute.
--
Don Guillett
SalesAid Software
"Louise" wrote in message
...
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
Reply With Quote