dannyok90
Board Regular
- Joined
- Aug 30, 2016
- Messages
- 115
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:
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
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:
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