| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA extraction of a part of the cells content
Hi all (is Luke still listening?),
In Range(Cells(rijrij, kolkol), Cells(rijrij, kolkol)) I want to extract the part after position (say) 18 and before position 29. I forgot what VBA instruction does the trick. Please help because I can't go on with my work. Jack Sons The Netherlands |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA extraction of a part of the cells content
First, it looks like you can just use:
cells(rijrij, kolkol) since the range is a single cell. msgbox mid(cells(rijrij, kolkol).value, 19, 10) Start with position 19 for a length of 10. Jack Sons wrote: Hi all (is Luke still listening?), In Range(Cells(rijrij, kolkol), Cells(rijrij, kolkol)) I want to extract the part after position (say) 18 and before position 29. I forgot what VBA instruction does the trick. Please help because I can't go on with my work. Jack Sons The Netherlands -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to delete part of the content on multiple cells in excel? | Excel Discussion (Misc queries) | |||
| testing range of cells for part of cell content | Excel Worksheet Functions | |||
| Can I use the content of a cell as part of filereference in other | Excel Worksheet Functions | |||
| Replacing Part of a Cell's Content | Excel Worksheet Functions | |||
| display part of the cell content | Excel Discussion (Misc queries) | |||
Linear Mode
