I made myself a macro by combining a series of recordings made when I performed the needed task step by step.

One of the steps was to go to another sheet, copy a column of formulas and return to paste it into the original sheet.

When I ran this step of the macro directly from the module, where it is generated at the recording, there was no problems, but adding it to the rest of the sequence made the macro stop when the cursor was at the 'foreign' sheet and the area to copy was marked. A message informed me of the figure 400 and gave me an OK botton. There was no error message.

As far as I know the answer to everything is 42 rather than 400, so what does this figure mean?

NSV