I'm trying to, via VBA, put a formula in a range of cells, but I'm having trouble collecting my file name from an offset cell using R1C1 notation. My file name is created through formulas, so I have to pick up the value: 
Please Login or Register  to view this content.
Using R1C1 the code bombs. I could use OFFSET, but don't know how to structure that one, either, in this case, because I don't think I could offset from the Activecell, right? Assistance is requested and appreciated.