mouzi4us
02-01-2016, 12:22 AM
Hi Friends
I have a Problem in VBA and looking for solution for my case .
I want to insert Dynamic Spark lines in my excel, so I have to define Dynamic Range for that and assign it to my spark lines, I did it with Offset and Count function . My problem is that there are so many Rows ( Abou 200 Rows ) that I should define name ranges for that .
So I recorded a Macro of defining Name and used a For loop to create Name Ranges . my Problem is that it refers to RC Ranges that wont work in excel .
I insert 3 pics to show my problem.
153261532715328
I would be so thankful if u guys help me on that.
I have a Problem in VBA and looking for solution for my case .
I want to insert Dynamic Spark lines in my excel, so I have to define Dynamic Range for that and assign it to my spark lines, I did it with Offset and Count function . My problem is that there are so many Rows ( Abou 200 Rows ) that I should define name ranges for that .
So I recorded a Macro of defining Name and used a For loop to create Name Ranges . my Problem is that it refers to RC Ranges that wont work in excel .
I insert 3 pics to show my problem.
153261532715328
I would be so thankful if u guys help me on that.