Copy visible cells to visible cells

[CephasOz]

CephasOz submitted a new Excel article:

Copy visible cells to visible cells - Copy only the visible cells of a source range to only the visible cells of a destination range.

Looking through the Excel articles, I was inspired by the article by Akuini Excel VBA: easy way to paste to visible cells. My code below takes into account hidden rows and columns in both source and destination. It also ensures that overlapping cells of source and destination are not copied; it will copy as much as it can, so cells that don't overlap are copied and cells that do are...

Read more about this Excel article...

 

[Boonchai Charoenek]

Dear CephasOz,

Greeting from Bangkok Thailand.

Thank you very much for sharing very useful VBA code, I try several week to find how to paste data, only in visible cell. (for both hidden row, and hidden column)

Refer to your code, I try to input the first code in module one, and the second code in module two (I don't know, I make it correct or not) , but finally cannot work.

I am so sorry for my stupid, but kindly guide me, how to input the code correct, and how to use this amazing function.

I look forward to hearing from you soon.

Thank you very much in advance.

 

[CephasOz]

Hi Boonchai.

The two pieces of code don't have to be in different modules. It won't make any difference if they are in two modules or one.

Are you making sure that you get all of the code? There is a copy icon at the top right of each piece of code. If you click that icon, all of that piece of code will be copied, so you can paste it into your module.

If that's not the problem, can you tell me exactly what the problem is that you are experiencing?

Regards, Peter