I have used the code below to add a formula into a cell but all the references are absolute and I want C4a to be relative. How do I modify the code to get C4a relative?
Thanks SandyPlease Login or Register to view this content.
I have used the code below to add a formula into a cell but all the references are absolute and I want C4a to be relative. How do I modify the code to get C4a relative?
Thanks SandyPlease Login or Register to view this content.
Try something like this:
Does that help?Please Login or Register to view this content.
Hi Ron, That got the row relative, thanks. How do I get the column relative as well?
Not surprisingly:
Please Login or Register to view this content.
Thanks Ron that worked Sandy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks