Trying to combine print areas

[tom.mat.walker]

Good Afternoon guys,

I am trying to sort an excel report so that it only selects certain print areas according to values in different cells. To do this I am applying the different print areas to variables and then will combine all of those into a print command. However, when I select the first print area, which is set in a variable it works but adding the second variable with an "&" symbol causes a runtime 1004 error. The next problem is that the runtime 1004 error is not a regular one it shows up as the error that you normally get in excel when a formula is not correct (see attached picture).

Please Login or Register  to view this content.

scrnshot.jpg

Any help as to what that error code means in that form would be greatly appreciated!

Regards

Tom

[Greg M]

Hi there,

Try using the following code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[tom.mat.walker]

Perfect, thats done the trick thanks!

Tom

[Greg M]

Hi Tom,

Many thanks for your prompt feedback - glad I was able to help.

Regards,

Greg M