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

[dwhiting]

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()

Range(“C11:C16”).Select

Selection.Copy

Range(“D1”).Select

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

End Sub

[dwhiting]

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.