IRish3538
05-07-2012, 02:33 PM
Hey guys,
I'm "copying" cell contents (not using the copy function) from one workbook to another and am trying to figure out how keep the source formatting..
ActiveWorkbook.Sheets("A").Range(Destination_Cell) = _
ThisWorkbook.Sheets("B").Cells(n,1)
I loop this function and there's different number formats.. some are dates, some are $.. How can I get this to just keep whatever the format is of the cell in ThisWorkbook.
Thanks so much for your help!
I'm "copying" cell contents (not using the copy function) from one workbook to another and am trying to figure out how keep the source formatting..
ActiveWorkbook.Sheets("A").Range(Destination_Cell) = _
ThisWorkbook.Sheets("B").Cells(n,1)
I loop this function and there's different number formats.. some are dates, some are $.. How can I get this to just keep whatever the format is of the cell in ThisWorkbook.
Thanks so much for your help!