Hi There,
This might be an easy question, but is it possible to have named range in quotes?
For example the code below selects a range in a chart based on a users selection:
If however, I had a named range called 'Category' which referred to $B$10:$B$19, and a named range called 'Sales' which referred to $AE$10:$AN$19, is it possible to replicate the above code, so essentially it would look something like:
The problem with the above is that it does not just select $B$10:$B$19 & $AE$10:$AN$19 - it also selects every column in between. So column C, D, E etc... are also selected.
The only difference between the codes above are the quotation marks. Is it possible to use quotation marks with named ranges, or is there another way completely?
Thanks for any help in advance.
Ashley
Bookmarks