| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextToColumns Destination:=another worksheet
Does anyone know whether I can do TextToColumns to a worksheet other than
the one I'm processing? It doesn't appear so, but I want to make sure. Thanks. Geof. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TextToColumns Destination:=another worksheet
Geof,
You need to copy or cut/paste the original data to the new worksheet prior to doing the conversion. HTH, Bernie MS Excel MVP "Geof Wyght" wrote in message ... Does anyone know whether I can do TextToColumns to a worksheet other than the one I'm processing? It doesn't appear so, but I want to make sure. Thanks. Geof. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Source and Destination worksheet difference | Excel Worksheet Functions | |||
| Macro changes formulas on destination worksheet | Excel Discussion (Misc queries) | |||
| Hyperlink formula with destination in same worksheet | Excel Worksheet Functions | |||
| texttocolumns | Excel Programming | |||
| TextToColumns | Excel Programming | |||
Hybrid Mode
