|Hi again, |
Sorry for the confusing question!
I found a solution to solve it, however i just have a little problem. A shortend version of my code is shown below. Right now the code is repeating itself 32 times, because i have 32 different variables. But i just want it to repeat itself untill an empty Cell, so that i dont have change the code when the number of variables changes.
Can i do that without using a "DoLoop", and just use "For... To" ?
'Open workbook with Model "Be05_TEST2"
Workbooks.Open ("C:\UA SA\Be05_TEST2")
Dim i As Integer
For i = 2 To 32
Workbooks("Be05_TEST2").Sheets("Hoved").Cells(511, 3).Value =
'Energiramme - BR10
ThisWorkbook.Sheets("Output").Cells(i, 1).Value = Workbooks("Be05_TEST2").Sheets("RESULTAT").Cells(9, 17).Value