Here I am back, "thick as a brick" :hammerhe: with the same problem of entering a formula into a cell, where the row number should be pulled from a loop that contains the code.
"r" is a row number from the loop that contains the code line, and each cell ref in the formula should inherent the respective "r" when it is entered into the cell.
So, if I am in r = 7 ,for example, the formula entered into cell I7 by the code should actually like this:
I have read all previous help provided to me here (on the very same topic), tried every double-quote combination I could think of (including using char(34) ) and came up with errors, each time...
Again, I reach out to your support :confused: