Importing selected ranges

[nrn]

hi,

I am new at VBA coding. Can anyone help with a standard code to import certain ranges from a closed(or opened) workbook to a specific range in a new master sheet (open workbook).

thanks for your time
Nrn

 

[Andrew Poulsom]

Maybe this will help you:

http://www.rondebruin.nl/ado.htm

 

[nrn]

Dear Mr.Andrew Poulsom,

Thank you for helping out. I wish one day i would be able to help other as you do.

Thank u once again

your truly,
Naren, Bangalore India.