Hi John, and welcome to the forum,
It's late here, and I'm a little tired, but if you're just trying to copy the block of formulas down, you could do a Find/Replace on your existing selection to replace $1 with 1. At that point if you copy the block from Rows 1:18 down to 19:36, it would apply the correct formulas.
I'll try to look at this again to solve your original question late this weekend.
Bookmarks