It's not so much the code itself I was having
difficulty with as much as replacing A with B in the formula. Since
the formula is a text string then, could I use:

.Cells(i,j) = "=Replace("#Ref",1, 10, "Autofilter")"

I tried this before but it would come up with an error on this line
unless something else was causing it to falter. I will double check
on my part. But does that seem reasonable?