Macro to enter formula is not referencing correct cells.

Hello all,

I wrote the following code to enter a formula in column B referenncing cells in column T:

Please Login or Register  to view this content.

When the code is run it is creating 2 problems;

1. When it runs this code the code runs for several minutes at this stage and I'm not able to understand why. It does finally complete after several minutes have elapsed so I think there may be something wrong.

2. After the maro has run, all the cells in column B, are referencing Cell number T2 in column B instead of the adjacent cell in column T.


Any idea on what my coding error is?

I'm not sure on speeding up the code, if you want the cell number to increment as you describe I think you would need to have:

Please Login or Register  to view this content.

Hello Yudlugar,

Thanks for the modified code. This took care of problem number 2 as with this modified formula the correct cells are being referenced. However with the modification Problem number 1 has gotten worse. It took about 35 minutes for Excel to process the macro, which means I'm still doing something wrong.