SpeedUp/Alternative to Offset.Value = Offset.Value

[Jovica]

Is there an alternative to speed up this procedure :

Please Login or Register  to view this content.

I am using it to add those values into database (another sheet), but it's very very slow.

Thanks

[millz]

Maybe:

Please Login or Register  to view this content.

[Jovica]

Thanks, it's much faster but this line doesn't work

Please Login or Register  to view this content.

Only the first value rV.Offset(10, 2) is copied into next 11 cells.

...
changed that line with copy (11 cells) /paste values transpose=true and it's still slow.

[millz]

Oh, right, forgot about that. Try changing to:

Please Login or Register  to view this content.

[Marc L]

Please Login or Register  to view this content.

[Jovica]

Wow, much faster. Thank you so much!
I'll try to reverse engineer this into my other macros.