Thread
:
Run macro Once
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Run macro Once
OOPS
with Worksheets("qry_aga_corps")
if len(application.trim(.Range("X1")))<1 then
"Run Code"
'I assume that code puts somehing in cell x1
Else
MsgBox ("The Macro has been run once, cannot run twice")
End If
end with
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Don Guillett" wrote in message
...
with Worksheets("qry_aga_corps")
if len(trim(Range("X1")))<1 then
"Run Code"
'I assume that code puts somehing in cell x1
Else
MsgBox ("The Macro has been run once, cannot run twice")
End If
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"
PR
" wrote in message
...
Can anyone let me know how to get this code to work when there is a null
entry in X1...
Worksheets("qry_aga_corps").Activate
Range("X1").Select
If ActiveCell isnull Then
"Run Code"
Else
MsgBox ("The Macro has already been activiated once, cannot run
twice")
End If
Regards - Paul
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett