PDA

View Full Version : Opening A Working Book and Using Copy & Paste



bloodmilksky
10-20-2016, 08:24 AM
Hi Guys,

I just wondered if anyone knew if it was possible to use VBA to Copy a Range B5:D62 from Workbook 1 and open work book 2 and paste it into a defined range? : pray2:

Many thanks

Jamie

mana
10-21-2016, 04:05 AM
Why do you use VBA?
you can use formula refer to workbook1 range.