Solution to copy a range of cells and paste in another Worbook w/o using an input box

I posted on another forum, but never got a response.

HTML Code: 

Is there a way to copy a range of cells instead of using an Input Box. The cells I need are from E1 and then I know you could use xlDown from the E1cell. Here is my current code w/Input Box. I tried this but it didn't work: .Copy. The code I'm referring to is right after Workbooks(1).Activate. I can provide both workbooks if needed. What I need is to copy the E range and then paste it in another workbook w/o using an Input Box.

Thanks Ken Mc.

Please Login or Register  to view this content.

Kev,
Thank you so much! You are a gem. That worked perfectly.
Thanks again,
Ken Mc