I am trying to write a macro that will copy a selected range and paste it to a seperate worksheet.

A basic selection.copy command works to copy, but I can not seem to make it paste where I want it without a lot of hastle and without leaving the page I am on.

I used to be able to do this in lotus, but it doesn't seem to want to work in excel. I am trying to copy a range of numbers to one location, thenanother number to a location near the last group, then formulas apply to further calculate (not significant here). The copied numbers change month to month, and Ineed to be able to do this several times over several sheets.