Offset function

Help
,
1

Dear community

I have a question regarding offset function.

As you may know, offset function can be used in write cell activity by setting “offset(starting cell, row#, column#)” in the range.

I am trying to replace column# by counter variable so that I can move horizontally.

However, this does not work.
It seems that the range does not accept variables together with offset function.

Am I using offset function incorrectly?

2

Either I had the same question, Its not right there but can use Invoke VBA/VBScript to make it done.