How to increment formulas in VBA

[dannyok90]

Hi All,

Im sure this has probably been asked a million times but im struggling to work out how to increment a formula in my VBA code:

Cells(emptyRow, 2).Formula = "=LEFT(UPPER(XXXXXX),3)"

Id like the XXXXX to increment in the B column starting at b7

sure theres a simple answer but I just cant work it out

Thanks!
Dan

 

[Peter_SSs]

Tell us more about what you have and what you are trying to achieve.

Could we see the rest of your code to see how this line relates to it and what emptyRow is?