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
|