jeffouille
New Member
- Joined
- Dec 13, 2009
- Messages
- 22
Hi All,
Ive checked few threads online but my problem is actually a bit different so do require your valuable help...
Basically i will copy some range somewhere (simple copy by ctrl+c for ex) then id like to select another cell and paste to visible cells only (there can be hidden rows and columns).
I just need the function that paste only because what i will copy can be anything. However, i dont know how to play w clipboard content in order to paste. If the copy part was in the same sub then i would just use the copyrange, cell by cell, and then paste 1 by 1 if the row/column is visible, however in my case i dont have a copyrange, i just have a clipboard content. Hope am not too blur...
Many thanks for your help
Ive checked few threads online but my problem is actually a bit different so do require your valuable help...
Basically i will copy some range somewhere (simple copy by ctrl+c for ex) then id like to select another cell and paste to visible cells only (there can be hidden rows and columns).
I just need the function that paste only because what i will copy can be anything. However, i dont know how to play w clipboard content in order to paste. If the copy part was in the same sub then i would just use the copyrange, cell by cell, and then paste 1 by 1 if the row/column is visible, however in my case i dont have a copyrange, i just have a clipboard content. Hope am not too blur...
Many thanks for your help
