I need to read data for a group of charts into a master template file.
Sometimes my chart data range needs to be
AS31:AT35
Other times, when different data is read in, the same chart may need to only read
AS31:AT33
Is there any to name a range to read until row AT reaches it's first blank?
Thanks
Re: Chart Data Range
Depending on how you are selecting the range there is an IsEmpty(ActiveCell) that I use when running a loop to check cell contents to be included in specific ranges. If you used something like:
Dim ClmLgth As Integer
Dim Num As Boolean
ActiveSheet.Range("AS31").Select
Num = True
If IsNumeric(ActiveCell) And Num = True Then
Do
ClmLgth = ClmLgth + 1
Cells(ActiveCell.Row + 1, ActiveCell.Column).Select
If IsEmpty(ActiveCell) Then
Num = False
End If
Loop While IsNumeric(ActiveCell) And Num = True
End IfWhich can probably be trimmed down even more depending on your situation.
Re: Chart Data Range
codyfairdark,
A non-macro solution would be to create a dynamic range name for the chart data. That way when you specify what range the chart uses, you put in the range name you created and the chart will automatically adjust from then on.
Jim
Don’t have an account yet? Register yourself now and be a part of our community!