Excel VBA: easy way to paste to visible cells

[Akuini]

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...

Read more about this Excel article...

 

[Boonchai Charoenek]

Dear Akuini,

Greeting from Bangkok Thailand.

Thank you very much for your amazing VBA code, which really help my life.

Refer to your VBA code, which work for hidden ROW, but not work for hidden column.

Kindly advise me back, if you have any new VBA code, which can work for both Row, and column.

I look forward to hearing from you soon.

 

[Akuini]

Kindly advise me back, if you have any new VBA code, which can work for both Row, and column.

Thanks for informing me that the code is useful for you.
Try using a code from @CephasOz in this article, it is designed to work on hidden rows & columns.

 

[Boonchai Charoenek]

Thanks for informing me that the code is useful for you.
Try using a code from @CephasOz in this article, it is designed to work on hidden rows & columns.

Dear Akuini,

Thank you very much for your kind support.

I follow the advise article, but I don't know that I do it correct or not ( really sorry for my stupid).

I copy the first VBA code in Module one, and the second one (BubbleSort2D) in Module two , but it cannot work.

Kindly guide me, so I can follow your advise.

Look forward to hearing from you soon.

 

[Akuini]

I copy the first VBA code in Module one, and the second one (BubbleSort2D) in Module two , but it cannot work.

You should ask the question in that thread.
I haven't tried the codes my self but I think both codes should be in the same module.

 

[Boonchai Charoenek]

Dear Akuini,

Thank you very much for your advise.

BTW, I found that your code are super amazing, (just only unable to apply for hidden column)

Again, Thank you so much for sharing this amazing VBA code.