I'm updating a workbook that I did a while back and hoping to overcome a problem I wasn't brass enough to take on before.
Previously, because I didn't know how to set formulas to change sideways, so I just setup the workbook to go up and down. But it displays better going sideways, so I'd like to find a way to do it that way.
My current code looks like this:
For that code, it would cycle with "i" and move down one row at a time.
Please Login or Register to view this content.
Now I want to do the same thing, but instead of moving down, I want to move over. This means that as "i" increases my "=C" becomes "=D" then "=E" ....
I'm not aware of a way to enter formulas using a .cells(x,y) notation. What ideas do y'all have? The best I can come up with is a secondary function that converts 1 to A, 2 to B, 3 to C, etc.