I have a userform that takes 5+ seconds to save a row. I have tried everything in this http://analystcave.com/excel-improve-vba-performance/ page without success.
I am thinking that the OFFSET function is slow when writing to the spreadsheet.
Sheets("Test").Range("DataStart").Offset(TargetRow, 0).Value = TargetRow
Sheets("Test").Range("DataStart").Offset(TargetRow, 1).Value = L鄚
Sheets("Test").Range("DataStart").Offset(TargetRow, 2).Value = Kommun
Is there any way to speed up this code? Perhaps without using the OFFSET function?
I have seen some code that uses cells().
Cells(TargetRow, 0) = TargetRow
Cells(TargetRow, 1) = L鄚
Cells(TargetRow, 2)= Kommun
Thanks in advance
Bookmarks