I want a macro that copy information from the seccond sheet including
the last but one, and only from the fifth row in columnd B and C
including the last row used in those two columns

Note that all sheets contains information in other columns than B and C.

The macro I specified copy data in all columns used, and I do not know
how to restrict the range to copy.

Paul



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!