#### 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: