Hi,
I posted this yesterday afternoon but it seems to have disappeared.
I am having some trouble getting a copy paste to work properly in VBA, tried all yesterday afternoon with no luck.
I have teh following code which works well but the paste code will paste it into the required sheet and overwrite everything in its path, i tdont want this, i want to insert the copied cells "shifting cells down" but you cant seem to do this when copying a filtered range made up of inconsistent row numbers ie 1-3 4-5 10-15 etc etc
I had thought about doing a COUNT of the rows to be copied and a INSERT ROWS into the new sheets before pasting but seems long winded??
Thanks in advance
Bookmarks