Hi all Master of VBA
I hope you can help me for the issue below. I tried several ways in my ability but it still doesn't resolve
I have two ranges (1 row and unknown number of column) same size. We can call them is range1 & range2.
For example: Range1 = sheets(1).Range(Cells(1,1),Cells(1,Last_Column)) & Range2 = Sheets(1).Range(Cells(2,1),Cells(2,Last_Column))
I want to create a formula in sheets(1).Cells(1,Last_Column + 1) = Cell(1)Range1(refer address not value)*Cell(1)Range2(value) +...+Cell
Range1(refer address not value)*Cell
Range2(value)
For the picture attached, (https://imgur.com/1BrY6Ks) I have 5 columns but it is not always 5 like this so I used Last_Column to count
The number which appear on the formula in cell F1 come from range2 (A2:E2)
Hope to get the solution soon
Thank you so much
I hope you can help me for the issue below. I tried several ways in my ability but it still doesn't resolve
I have two ranges (1 row and unknown number of column) same size. We can call them is range1 & range2.
For example: Range1 = sheets(1).Range(Cells(1,1),Cells(1,Last_Column)) & Range2 = Sheets(1).Range(Cells(2,1),Cells(2,Last_Column))
I want to create a formula in sheets(1).Cells(1,Last_Column + 1) = Cell(1)Range1(refer address not value)*Cell(1)Range2(value) +...+Cell


For the picture attached, (https://imgur.com/1BrY6Ks) I have 5 columns but it is not always 5 like this so I used Last_Column to count
The number which appear on the formula in cell F1 come from range2 (A2:E2)
Hope to get the solution soon
Thank you so much