On Nov 1, 4:10 pm, "Jim Rech" wrote:
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"SangelNet" wrote in message

ps.com...
| 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!!