Inserting Formula containing Absolute Cell Address into Table Column

[talking_walnut]

Hi all,

Hope I've got the right terminology for what I'm asking but apologies if I don't, I haven't been using VBA too long.

I'm trying to insert a formula into each column using VBA code. It seems like it should be pretty simple but I can't figure out how to do it. The code is of the form:

Please Login or Register  to view this content.

i.e. I want the user to be able to enter a scaling factor in a cell and the results column be updated automatically (scalingFactor here is a string of the form "A1").

It seems like it should be easy but Excel is incrementing my cell reference for each row in the table. So A1 becomes A2 on the 2nd row, A3 on the 3rd, etc. I've tried a lot of different forms of code (.Formula = , scalingFactor as numbers, etc.) and spent a few hours looking for the answer but the solution eludes me. Can anyone tell me what I'm doing wrong?

[talking_walnut]

Figured this out.

Set

Please Login or Register  to view this content.

Nothing like a new day to figure out stupid problems