how do i refer to a named cell in vba?

[yellowpower]

e.g. i name a cell "hello"
i would like to assign a vaule 2 to that cell, what will be the correct vba syntax to perform hello =2 ?

thanks

[sweep]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[yellowpower]

thanks a lot,
If i name instead multiple cells(range) as Hello,
Could I refer to each cell using [Hello](i) = i?
just like when we did range("Hello")(i) to refer to a certain cell in the range

[royUK]

Do you mean create a range that contains multiple cells, like a table?

[yellowpower]

yeh, like naming range("a1","c6") as hello

[royUK]

Something like this will work in a table say A1:C6.

Please Login or Register  to view this content.

[DonkeyOte]

Could I refer to each cell using [Hello](i) = i?

If as I suspect you're referring exclusively to Evaluate then no, not with the shorthand notation assuming i is meant to reflect a variable.

If i is a constant:

Please Login or Register  to view this content.

[yellowpower]

Great! thanks

[romperstomper]

You could however use:

Please Login or Register  to view this content.

[yellowpower]

thats very helpful. tx!

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save