how do i refer to a named cell in vba?

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"