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

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.

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

nevermind ... I solved it a different way.


"crimsonkng" wrote:

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.