Hi,

I've been trying to find how to do this and don't seem to find what I am
looking for. How would I go about doing this?

I have a named range that is 2 columns wide and 18 rows long. I want to use
an if then statement to check the value of a specific cell (10,1) and if the
value is greater than 0, call another proceedure.


MyGrid = ("F11:N13")
MyLabel = ("E11:E13")

If MyNamedRange(.cells(10,1).value 0 then
Call NewProceedure(MyGrid,MyLabel)
End If

I get an error with this. The called proceedure is to add labels and
borders to a group of cells. I am usure if MyGrid and MyLabel should be
defined as a range or a string.

Thanks for your help.