Hi,
I am new with OpenOffice. I really hope you can help me with the following. A sample file would be ideal.
I need to have a button that will copy a small range (2 columns with 5 rows), and special paste (values only) where the cursor is placed/cell selected on the sheet.
Thank you!
Macro to copy and special paste into an active/selected cell
Macro to copy and special paste into an active/selected cell
Last edited by robleyd on Wed Nov 22, 2017 3:45 am, edited 1 time in total.
Reason: remove Known Issues icon by robleyd
Reason: remove Known Issues icon by robleyd
OpenOffice 4.1.3 - MacOS Sierra 10.12.6
Re: Macro to copy and special paste into an active/selected
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
-
- Posts: 1
- Joined: Tue Jan 30, 2018 6:24 pm
Re: Macro to copy and special paste into an active/selected
I have tried to copy paste special values only. There is no provision for values but only numbers which I selected. But only blank space appears. I tried alt+ESV which also did not work. What is the solution?
Open office 4 Windows 10 O/S