| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Macro to Copy and paste formulas from one spreadsheet to anoth | Excel Discussion (Misc queries) | |||
| Copy last cell with data in column E on one sheet to cell on anoth | Excel Worksheet Functions | |||
| macro needed to compare value and copy data underneath it to anoth | Excel Discussion (Misc queries) | |||
| copy every 30th cell in the column into consecutive cells in anoth | Excel Worksheet Functions | |||
| Copy Cells formats to another workbook | Excel Programming | |||
Linear Mode
