Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dim Rng As Range
For Each Rng In Sheet1.UsedRange.Cells Spreadsheet1.Range((Rng.Address)).Value = Rng.Value Next Rng This code seems to be working well, is there anyway to keep the formatting of the text? Thanks so much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Web Excel Component Bug | Excel Discussion (Misc queries) | |||
Set up costing sheet for multiple component recipe. | Excel Discussion (Misc queries) | |||
Loading sheet names in Combobox | Excel Programming | |||
Excel sheet not loading | Excel Discussion (Misc queries) | |||
Loading Sheet Names into Combo Box | Excel Programming |