Dynamic row Ranges for VBA

[dbiluk]

Hi Everyone,

Attached I have an excel spreedsheet where I am creating a macro to develop charts. I need a dynamic range so when new data is inputed the desired range for the chart includes the new data. The excel file is attached.Exceltrial(1)2 (version 1) (version 1).xls

The ranges are on a per row basis.
Basically I need a dynamic range that only incorporates the data in the blue atrea of the work book. What would the vba code look like for this?

Thanks,
dbiluk

[dbiluk]

any luck people?

[dbiluk]

For those interested I solved this myself, I used this method to name the ranges:

Please Login or Register  to view this content.

Instead of using Set...