Can I put multiple columns into 1 set range?

[JasperD]

Hi guys,

I have a database with a lot of columns with data. I get the first column I want and stick it into x, then the last column I want and stick it into Y. Z is the last row of the sheet.
Then I have the following code :

Please Login or Register  to view this content.

Which gives me the following :
$G$8:$G$34254,$J$8:$J$34254,$M$8:$M$34254,$P$8:$P$34254,$S$8:$S$34254,$V$8:$V$34254,$Y$8:$Y$34254,$AB$8:$AB$34254,$AE$8:$AE$34254,$AH$8:$AH$34254,$AK$8:$AK$34254,$AN$8:$AN$34254,$AQ$8:$AQ$34254,$AT$8:$AT$34254,$AW$8:$AW$34254,$AZ$8:$AZ$34254,$BC$8:$BC$34254,$BF$8:$BF$34254,$BI$8:$BI$34254,$BL$8:$BL$34254,$BO$8:$BO$34254,$BR$8:$BR$34254,$BU$8:$BU$34254,$BX$8:$BX$34254,$CA$8:$CA$34254,$CD$8:$CD$34254,$CG$8:$CG$34254,$CJ$8:$CJ$34254,$CM$8:$CM$34254,$CP$8:$CP$34254,$CS$8:$CS$34254

I want to put this into one range, so I can subtotal them all together - I try to set the range as :

Please Login or Register  to view this content.

but it errors out without a clear error code.
What am I doing wrong?

EDIT
If I would just set "ytdcols" to "ytdcols = "$G$8:$G$34254,$J$8:$J$34254,$M$8:$M$34254,$P$8:$P$34254,$S$8:$S$34254,$V$8:$V$34254,$Y$8:$Y$34254,$AB$8:$AB$34254"" then it works fine... Is there a limit to the number of arguments / cells you can put in a range?

[nathansav]

UNION(range1, range 2,etc)

[JasperD]

Hi Nathansav, thanks for your reply! How would I incorporate this into my code?

[nathansav]

Please Login or Register  to view this content.

not in excel, so cant test, and heading home now.

[JasperD]

Thank you Nathansav.

After one small tweak, it works like a charm!
Much appreciated!