Ask Your Question

VBA support - "selection.copy" not working in LO3.5 [closed]

asked 2012-03-14 16:33:25 +0200

dwhiting gravatar image

updated 2015-10-15 15:28:32 +0200

Alex Kemp gravatar image

I've just upgraded to 3.5.0rc3 and find that one of my old VBA macros that used to work under version 3.4 has stopped working, it runs through all the code and does not throw any errors, but when stepping through it I can see that it does not execute the copy action on one line.

So when I later paste, blank cells are pasted instead of the data from C11:C16.

Does anyone know why this is?

example code below

Option VBASupport 1

Sub Copy_Paste()




Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True

End Sub

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 15:28:58.908359

1 Answer

Sort by » oldest newest most voted

answered 2012-03-15 16:40:02 +0200

dwhiting gravatar image

I found a work around for this. I didn't realise but you can call a BASIC sub routine from within the VBA code, so I simply recorded a new macro within Libre using dispatch code to do the copy and called this at the point in my VBA code where the selection.copy failed.

edit flag offensive delete link more

Question Tools


Asked: 2012-03-14 16:33:25 +0200

Seen: 1,035 times

Last updated: Mar 15 '12