![]() |
How to create a formula with ListBox toa othes Sheet
Hi, if some body can help me I would appreciate:
what I want to do is to put a formula in running I fill the ListBox Uno from Sheet1 and then once is selected the information from ListBox Uno I want to put create a formula and put that in other Sheet2 If IsNumeric(Uno.List(i, 3)) Then Worksheets("Sheet2").Cells(iRow, 5).Formula = "=(Uno.List(i, 3)*FacInd!$E47 * FacInd!$E93)" So once I run the result is #NAME and is because the Uno.List(I,3) was in run time, I have tryed to return the value from the Uno.List to the Sheet1 ,but then did not work, If some body can Help me Thank you Alberto |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com