G
Guest
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.
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.