imtiaztariq
New Member
- Joined
- Jul 22, 2010
- Messages
- 4
Hi guys,
I am stuck in completing this task. It might be very simple but I am not good at VBA so please help.
I want to pass a Range of cells which needs to be given via prompt box into the following formula but I dont know how to do this.
This is the formula I have placed in my Excel sheet cell and I am reffering to this range in many other cells so What i need is that the user selects its range and it is placed it in every cell that contains this list.
=INDEX(LINEST('Regression Input Data'!$N$5:$N$19,'Regression Input Data'!$M$5:$M$19,1,1),5,1)
Would really appriciate your help thanks in advance
I am stuck in completing this task. It might be very simple but I am not good at VBA so please help.
I want to pass a Range of cells which needs to be given via prompt box into the following formula but I dont know how to do this.
This is the formula I have placed in my Excel sheet cell and I am reffering to this range in many other cells so What i need is that the user selects its range and it is placed it in every cell that contains this list.
=INDEX(LINEST('Regression Input Data'!$N$5:$N$19,'Regression Input Data'!$M$5:$M$19,1,1),5,1)
Would really appriciate your help thanks in advance
Last edited: