Search results

Thanks Narayan, this is great, now it works cleaner. I will distribute this to my colleagues with your compliments. I also want to send this to Chandoo to include in the page "17 clever ways to copy" on this website with your name on it, is that ok for you ? Or feel free to do this yourself...

Hi Narayan, Thank you very much again for putting in your time, I really appreciate it. It's a pity that the access to and contents of the Clipboard is so limited, so I guess we'll have to live with that. However, in a normal Ctrl-C / Ctrl-V sequence, the data from the Clipboard that gets...

Thanks again Narayan, I don't mind some delay, no worries! @SirJB7: thank you for your suggestion, maybe it helps Narayan? Thanks, Wouter

Thanks Narayan you did it !!! It works like a charm and fulfills my needs. I saw your previous post today and knew this is where my knowledge of VBA script is way too limited. I understand it when someone else writes it but that's not good enough. I've put the script in my PERSONAL.XLSX and...

Hi Narayan, Thank you for your swift reply. The links provide some different ways how to solve this, but all involve several steps. I would like to have this automated in VBA script. So the sequence would be: 1- select region to copy (e.g. 5x10 cells) 2- Ctrl-C to copy 3- select top left...

Hi Chandoo and posters, I am a business analyst and build business case spreadsheets. Many times I wish to duplicate a block of cells on the same sheet, while keeping all cell contents exactly the same, whether it be formulas or numbers doesn't matter. So references to other cells should stay...