Excel vba

[mdo21]

Hello, I am trying to code that locates the position of a cell in VBA.


a=Range("b").Value
Range("C")(1, 1 + 8 * (a - 1) = "hello"

The "1+8*(a-1)" part does not work. Could someone please help solve this problem? Thank you in advance.

-M

[TMS]

The code does not work because it makes no sense. Range("b"). Value will not work, unless b happens to be a Named Range. Similarly, in Range("C"), C would also need to reference a Named Range.

Please explain what you are trying to do.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.