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
Last edited by revenge4ash8; 12-15-2014 at 08:32 AM.
Bookmarks