This code successfully changes the range for name "graphdata", but is this the simplest way to do it?
(I got it from running a macro.)
Also, how do I convert it from R1C1 to normal A1 format?
many thanks!
Please Login or Register to view this content.
Last edited by alansidman; 11-03-2017 at 05:32 AM.
You can just set your range in VBA and name it as well.
if you wanted to offset it you would just offset it.Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
Thanks for the info. It is very helpful.
I have a large number of names that i need to keep changing, for my graphs. Is there a simple one line code to do this e.g. name("example"). value=example ?
I don't no what "name("example"). value=example " means.
You should only actually require
though I don't see why you need to keep changing them if they are dynamic ranges like that one?Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks