Search for decimal and when found pass row number to rest of string

[beenbee]

Hi All,
I hope someone can help with this issue. I am trying to search through column "I" for numbers that are decimals, when the first decimal is found, use the row number that the first decimal appears in the string that populates the bookmarks stored in a word template I have created.
The code I have so far checks for the decimal and then populates the bookmarks, however it requires me to input the ranges manually, meaning I can set them as the first row in my tabel. But if the decimal appears in the second row and not the first I'm bookmarking the wrong data.
Here is the code I have so far;

Please Login or Register  to view this content.

Any help would be great!

[Izandol]

I am not certain of your problem but perhaps you wish:

Please Login or Register  to view this content.

[jmac1947]

hi beenbee

you are using 2003 which I cannot get to so I cannot even get the code to compile (fails on the DIm wrdApp as Word.Application line)

However, it also seems (when i paste the code into a workbook woth indenting that you are missing a "Next" statement immediately before the end sub (needed for the For each loop)

That may be a clue to why you only get one bookmark, best I can do without being able to even compile the code (and I have never tried to update word from excel so I have little experience in how to overcome the error)

sorry i cannot be of more help

Jmac1947

[beenbee]

Hi, Thank you both for your responses. Izandol that works well, thank you.
jmac1947 the decimal section is just 25lines of a 950line code, which is so unwhielding (I have ask'd for help to condense it, if its possible but no one responded.) the next comes further down.
Thank you both