| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy sheets of cell length is more than 255 char
Hi,
extra information: you should note that UsedRange doesn't always start A1. wsSource.Cells.Copy works as well. wsSource.UsedRange.Copy wsNew.Range("A1").PasteSpecial -- HTH okaizawa ilyaskazi wrote: ok here is the solution.... http://www.pcreview.co.uk/forums/thread-1739316.php |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have charac in new column with 40 char length only... | Excel Discussion (Misc queries) | |||
| copy cell info to other sheets, other sheets dont contain all row. | Excel Worksheet Functions | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Threaded Mode
