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) |