VBA code to select two variable ranges in a row

[martinrrrr]

I recorded a macro to make a chart. I have two ranges that will be used to define the chart Category Axis and the Series Values. The macro recorded the range as:
Range("A1:AF1,A12:AF13").Select
This range will vary depending on the number of columns containing data. The beginning of the range will always be A1 and it will be just row 1 for the first range and the second data range will begin at A12 and end on row 13. What code do I use that will automatically select the variable ranges (at the same time) that will be used to create the chart?

Thanks for any help

 

[Akuini]

This range will vary depending on the number of columns containing data.

Can we use row 1 to determine the last column with data?

n = Cells(1, Columns.Count).End(xlToLeft).Column
Union(Range("A1").Resize(, n), Range("A12:A13").Resize(, n)).Select

 

[martinrrrr]

Can we use row 1 to determine the last column with data?

Yes, row 1 can be used to determine the last column with data.

 

[martinrrrr]

Thanks Akuini, you code works.

Best regards and have a great day.

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.