I am generating an excel spreadsheet and there will be an unknown amount of columns created (decided at runtime). I know that the last column index could be say... 63.
But I need to do a formula for the row not all, just from column 3-62. but i can't do
formula =SUM(3:3,3:63), i have to do this:
formula =SUM(C3,BK3) etc.
How can i convert 63 into BK (if thats what it is?) without creating a HUGE select statement ?