LinkBack URL
About LinkBacks
Hello.
I've been trying to use vba to input a formula into a cell and then offset the reference cell for each subsequent loop.
What I have is:
Please Login or Register to view this content.
This gives me #NAME? error and I'm not sure how to fix it.
Hello.
I've been trying to use vba to input a formula into a cell and then offset the reference cell for each subsequent loop.
What I have is:
Please Login or Register to view this content.
This gives me #NAME? error and I'm not sure how to fix it.
I assume i is your variable, you need to put it outside of a string for Excel to recognize it's a variable.
Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
This works! Thanks!!
Say I want to anchor R[4]C[2], how could I do this? When my code runs down the columns I get D8, D9, D10. I want it all to reference D8 though.
Edit: My current codePlease Login or Register to view this content.
D8 is R8C4, basically just remove the square brackets to change it from relative cell to absolute cell referencing.
Works perfect! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks