how do i refer to a named cell in vba?

Range("Hello").Value = 2

or

[Hello] = 2

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

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

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

Range("hello").Cells(2, 2).Value = "Hello world"

Originally Posted by yellowpower

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:

[INDEX(Hello,2] = "apple"

You could however use:

   Evaluate("Hello")(i) = i

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