When i try to copy a worksheet which has a large number of rows by using the
"right mouse button then move or copy function buttons "

1) It moves it ok into a brand new workbook. but

2) When i try to move it to a worksheet that has other sheets of data
already on it it says "Can not move as the new destination does not contain
enough rows or columns heading for the source destination"

Is there a way of increasing the default number of rows in my worksheets or
another way round this.. I don't want to just use the copy paste function
as not all the formulas copy correctly.

thanks in advance..