https://bugs.documentfoundation.org/show_bug.cgi?id=122684
--- Comment #5 from Gunnar <[email protected]> ---
Thanks!
But the code fails to remove the contents of the copied range.
rSrc = "B2:C5"
rDst = "E2"
Worksheets("Sheet1").Range(rSrc).Copy
destination:=Worksheets("Sheet2").Range(rDSt)
Worksheets("Sheet2").Range(rDst).ClearContents
rDst points to upper left corner in the destination sheet, which is cleared.
rScr and rDst are not equal!
To make it work, you need to set rDst = "E2:F5" (same size)
But anyway, it's close to a solution.
This bug cost me a lot of trouble because what was copied was changing all the
time since the selected range was random, and I couldn't get hold of what was
going on. I was close to giving up until, by luck, the selected cell had a
different background color. Viola!
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
