If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel VBA: easy way to paste to visible cells

Thread starter Akuini
Start date Jun 22, 2023

Overview Discussion

Akuini

Well-known Member

Jun 22, 2023

Akuini submitted a new Excel article:

Excel VBA: easy way to paste to visible cells - A macro to copy-paste from visible cells to visible cells that is available on any open workbook

Excel does not provide a direct method for copying and pasting from visible cells to visible cells.
So here's a method using VBA:

How it works:
1. Put the "Sub CopyVisibleToVisible1" code in a code module.
2. Run the code.
3. An input box will appear, asking you to select the range you want to copy. Select the range as required and click "OK."
4. Another input box will appear, asking you to select the range where you want to paste. Select only the first cell and click "OK."

The code...