I ahve a large amount of data, I have hidden some of the rows and colums and only want to copy the visible data left across to a new work sheet. Any ideas how? Pase seems to take everything.

Thanks