InStr function to find nth position of a space in a string

[MaartenRo]

Hi,

I wrote a function in a macro which should find the position of the first space (" ") from the 8th character onwards in each cell in a column.
For each value i get a result 0. What am i doing wrong?

Any input is much appreciated!

Please Login or Register  to view this content.

[MaartenRo]

I figured it out. The right way to do it is:

Please Login or Register  to view this content.

By entering "C" as range to be searched in the code executes the funcion foreach cell in the selected range