Hello,
I would like to know how to get VBA to find the range for a chart by looking for the last row and column of an array. Basically find the last row in multiple data series.
Currently, I am setting the range manually but would like to automate it.
I was not sure how to word the question on google so I was not able to find similar posts.
Thanks.
I would like to know how to get VBA to find the range for a chart by looking for the last row and column of an array. Basically find the last row in multiple data series.
Currently, I am setting the range manually but would like to automate it.
I was not sure how to word the question on google so I was not able to find similar posts.
Thanks.