Using Text Formulas in VBA

Hi All,

I've stumbled into an issue while trying to use a text formula in VBA to set the value of certain cells. Hypothetically I could insert a formula into a cell then paste as value to get the same result, however I am working with a huge document and trying to write the most efficient code possible.

Here is the code I've written, with the understanding that the "v = ..." part of the code isn't correct, but I wanted to show the formula I need to use there. In that formula, the cell "B2" should be dynamic such that it is "B"&i.

Please let me know if you have any solutions or thoughts.


Thanks in advance.

Please Login or Register  to view this content.

Tiger - That .UsedRange function is awesome. Can't believe I had not seen that yet!

Thank you Tiger. That works perfect!