Copy & Paste val on a filtered list to adjacent column

[Gazmoz147]

Hi,

I have a spreadsheet with a helper column. I understand you cant copy and paste correctly from filtered list into adjacent cells. So I'm having to un-filter list then highlight start of orig filtered list cell beginning to end (including blank cells) and then Paste Special skip blanks.

Is there a solution to this where can leave the filter on and paste into left of the cell from N to M?

Many Thanks
Gareth

[Bernie Deitrick]

With a macro - for desktop versions, at least.

Please Login or Register  to view this content.

But if you are running the workbook in both versions, you need to follow these instructions:

PtrSafe keyword
12/03/2018
2 minutes to read




The PtrSafe keyword is used in this context: Declare statement.

Declare statements with the PtrSafe keyword is the recommended syntax. Declare statements that include PtrSafe work correctly in the VBA7 development environment on both 32-bit and 64-bit platforms only after all data types in the Declare statement (parameters and return values) that need to store 64-bit quantities are updated to use LongLong for 64-bit integrals or LongPtr for pointers and handles.

To ensure backwards compatibility with VBA version 6 and earlier, use the following construct:

VB

Please Login or Register  to view this content.

When running in 64-bit versions of Office, Declare statements must include the PtrSafe keyword. The PtrSafe keyword asserts that a Declare statement is safe to run in 64-bit development environments.

Adding the PtrSafe keyword to a Declare statement only signifies that the Declare statement explicitly targets 64-bits. All data types within the statement that need to store 64-bits (including return values and parameters) must still be modified to hold 64-bit quantities by using either LongLong for 64-bit integrals or LongPtr for pointers and handles.

[Akuini]

This code is to copy values from visible cells to visible cells. You can paste to any cell, not just the adjacent cell.
Run the code > an inputbox will appear > select a range to copy > OK > select only the first cell to paste > OK.

Please Login or Register  to view this content.

[Gazmoz147]

Hi Bernie & Akuini,

Both work perfectly thank you very much, will be a huge time saver.

Also thank you for the PtrSafe keyword info

Many Thanks
Gareth

[Akuini]

You're welcome, glad to help & thanks for the feedback.