value of one cell in a named range
 

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.

value of one cell in a named range
 

Karen,

Imagine your named range as a grid and you can refer it individual cells
within it like this:-

Sub sonic()
x = Range("myrange").Item(2, 2).Value
End Sub

item refers to row, column.
It's also useful to note that you can use this method to refer to cells
outside your named range so a 3,3 grid could iuse the reference 3,4 which
would rer to the column to the right of your grid.

So to return item 10,1 is
x = Range("myrange").Item(10, 1).Value

where "myrange" is the name of your range.

Mike

"Karen53" wrote:

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.

value of one cell in a named range
 

Thank you, Mike!

"Mike H" wrote:

Karen,

Imagine your named range as a grid and you can refer it individual cells
within it like this:-

Sub sonic()
x = Range("myrange").Item(2, 2).Value
End Sub

item refers to row, column.
It's also useful to note that you can use this method to refer to cells
outside your named range so a 3,3 grid could iuse the reference 3,4 which
would rer to the column to the right of your grid.

So to return item 10,1 is
x = Range("myrange").Item(10, 1).Value

where "myrange" is the name of your range.

Mike

"Karen53" wrote:

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.

value of one cell in a named range
 

And explicitly using Item is superfluous.

x = Range("myrange")(10,1).Value

works fine.

Alan Beban

Mike H wrote:
Karen,

Imagine your named range as a grid and you can refer it individual cells
within it like this:-

Sub sonic()
x = Range("myrange").Item(2, 2).Value
End Sub

item refers to row, column.
It's also useful to note that you can use this method to refer to cells
outside your named range so a 3,3 grid could iuse the reference 3,4 which
would rer to the column to the right of your grid.

So to return item 10,1 is
x = Range("myrange").Item(10, 1).Value

where "myrange" is the name of your range.

Mike