| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets changing name
Hi again oldjay,
If you want both values and formats you need to copy the source and paste it to the destination. The following line of code copies and pastes in the one line of code. Cells(X, Col).Copy Destination:=Cells(NewRow, NewColumn) The code can actually be shortened to the following because Destination is default parameter. Cells(X, Col).Copy Cells(NewRow, NewColumn) -- Regards, OssieMac |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheets changing names | Excel Programming | |||
| Numbers changing between sheets | Excel Discussion (Misc queries) | |||
| Changing dates on multiple sheets | New Users to Excel | |||
| Changing Sheets in chart | Charts and Charting in Excel | |||
| Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
Threaded Mode
