Reference cell in ActiveCell row but different column

[BigTenBoy15]

I'm trying to get a cell in a VBA code to reference the value in column J (in the same row as ActiveCell) and multiply it by another value. I currently have used "= RC[-30] * RC[-39]" for the cell value to be input, but I have to do this for a number of different cells. The RC[-30] part will always stay the same but I want RC[-39] to always reference column J of the ActiveCell row instead of having to enter RC[-40], RC[-41], RC[-42], .... for the 20+ cells I need to do this for. Let me know if you have any suggestions. Thanks!

 

[Andrew Poulsom]

Welcome to MrExcel.

You can use RC10.

 

[Joe4]

Sorry I started typing up a response and got distracted.
Just to follow up on what Andrew said, if the value is between square brackets, it is an offset from the ActiveCell.
If the number is not between square brackets, it is the "hard-coded reference", i.e. C10 means the tenth column (which is column J).