Yes that would fall under my original statement. Go ahead and try it.

But even if it did work (but lets be clear, it doesn't), didn't you rule out
macros?

--
Regards,
Tom Ogilvy


"Floyd" wrote in message
oups.com...
Would this fall under your original statement as well?

Thanks in advance.

Option Explicit

Sub Macro1(Rng1)
Rng1.Select
With Selection.Interior
.ColorIndex = 1
.Pattern = xlSolid
End With
End Sub

Function Test(Rng1 As Range)
If Rng1.Value = 1 Then
Call Macro1(Rng1)
End If
End Function