how to use a macro to copy cell formats from one workbook to anoth

G

Guest

I have C:\MY DOCUMENTS\TARGET.XLS opened to a worksheet called RESULTS. The
cell highlight is residing in B90.

There's another file C:\MY DOCUMENTS\SOURCE.XLS that also has a worksheet
called RESULTS.

Without opening SOURCE.XLS, I want to copy the cell formats from B90:G175
from SOURCE to TARGET. (How) Can I do that in a macro without opening
SOURCE.XLS?

I found something in Excel Help about copying a formula from one workbook to
another but that's not quite what I'm looking for. Thanks, in advance, for
any assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste selected columns between Excel workbooks 4
copy several sheets from a workbook to a single sheet in a new wor 2
Find a day and copy 1
Open a wb and keep the focus on it 6
Copy work sheet to another work book, pros and cons 1
Paste selected columns from worksheet in a workbook to anotherworkbook 1
first sip of working with range in vba excel 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top