how to copy & paste only the visible rows

[mrpink]

Hi,

Being still a vba-novice, I would appreciate it if someone could help me out.
I need a macro where a user can select 1 or more rows, copy this, and paste it in the same or another workbook. BUT, certain colums are hidden (the hidden colums vary from file to file). Thus when selecting a row the normal way, copying and pasting it, it also pastes the hidden cells. This is what I don't want. It should only paste the visible cells, not the cells from a hidden column... It would be great if this can be done by letting the user first select some rows, and then pressing short-cut command (eg. crtl + alt + c) to copy only the visible cells, selecting a cell where the result has to be placed and then pressing ctrl + alt + v to paste it.
Is this possible?
Thanks 4 your help.

 

[ThePencilQueen]

I know how to find a button to put on the toolbar to select visable cells only (you could always record a macro and see what code it produces)

Goto View|Toolbars|Customise
Select the Commands tab, click on edit in the left hand box, scroll down in the right hand box and drag and drop the "Select Visable Cells Only" button onto your toolbar.

Hope this helps.