Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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

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

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 1

Sub Copy_Paste()

Range("C11:C16").Select Selection.Copy Range("D1").Select Range("C11:C16").Select

Selection.Copy

Range("D1").Select

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

End Sub

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

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