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.

Copy visible cells to visible cells

Thread starter CephasOz
Start date Feb 1, 2024

Overview Discussion

CephasOz

Active Member

Feb 1, 2024

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