cant see the macro

S

SangelNet

hi guys,

i have the following

Sub daterange(Optional today As Date)

today = Date

For Each cell In Worksheet("updated calls").Range("H:H")
If cell.Value <> "" Then
If cell.Value = today Then
sStr = sStr & cell.Offset(0, -6).Value & vbNewLine
End If
End If
Next
If sStr <> "" Then
MsgBox sStr, , "message here"
End If
End Sub


Im trying to assign the macro to a button, but the nacro doesnt appear
in the macro list.

Any thoughts? thnx
 
J

Jim Rech

Sub daterange(Optional today As Date)

If you specify a parameter, even optional, the macro will not appear in the
list.

And since you have this:

today = Date

you're overriding it anyway so you might as well remove the parameter.

--
Jim
| hi guys,
|
| i have the following
|
| Sub daterange(Optional today As Date)
|
| today = Date
|
| For Each cell In Worksheet("updated calls").Range("H:H")
| If cell.Value <> "" Then
| If cell.Value = today Then
| sStr = sStr & cell.Offset(0, -6).Value & vbNewLine
| End If
| End If
| Next
| If sStr <> "" Then
| MsgBox sStr, , "message here"
| End If
| End Sub
|
|
| Im trying to assign the macro to a button, but the nacro doesnt appear
| in the macro list.
|
| Any thoughts? thnx
|
 
J

John Bundy

Save it in your Personal.xls workbook and you'll see it then. If you don't
have one, hit the record a macro button, select personal macro workbook from
the "Store macro in" drop down, do something, then stop recording, you will
now see it anytime you have the editor open, put your code in there.
 
S

SangelNet

If you specify a parameter, even optional, the macro will not appear in the
list.

And since you have this:

today = Date

you're overriding it anyway so you might as well remove the parameter.

--

| hi guys,
|
| i have the following
|
| Sub daterange(Optional today As Date)
|
| today = Date
|
| For Each cell In Worksheet("updated calls").Range("H:H")
| If cell.Value <> "" Then
| If cell.Value = today Then
| sStr = sStr & cell.Offset(0, -6).Value & vbNewLine
| End If
| End If
| Next
| If sStr <> "" Then
| MsgBox sStr, , "message here"
| End If
| End Sub
|
|
| Im trying to assign the macro to a button, but the nacro doesnt appear
| in the macro list.
|
| Any thoughts? thnx
|

Thnx, That was it! fix in a jiff!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top