Ask Your Question

dwhiting's profile - activity

2013-07-29 18:25:09 +0200 received badge  Famous Question (source)
2012-12-27 13:10:44 +0200 received badge  Notable Question (source)
2012-12-06 10:32:50 +0200 received badge  Taxonomist
2012-05-08 15:45:08 +0200 received badge  Popular Question (source)
2012-03-15 16:40:02 +0200 answered a question VBA support - "selection.copy" not working in LO3.5

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.

2012-03-14 16:35:41 +0200 received badge  Editor (source)
2012-03-14 16:33:25 +0200 asked a question 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