Hi all, really stumped here. Have searched all over and seemed to find an answer but can't get it to work for me, so anyhelp would be great.
I have a script which loops through a column in an excel workbook and for each filled cell in turn checks the value and depending on its value calls a sub which adds bookmarks to a word template.
What I'm trying to do is if the cell value of the found cell in "I" is >1 then find a cell in column "c" of the corrosponding row number. Then divide the value of cell "C?" by the value "I?".
Both "c" & "i" are stored as ranges as they need to be for the bookmark code.
Is what I'm trying to do possible?
I have tried converting the ranges to Integers, Long, Short, and tried rounding them, Int, Value. Cell..... but always comes back "Type Mismatch".
So the top one is what I'd like to happen.
Have tried adding the value of "I" as a set value of x but that doesn't work either. However my bookmark code does work, so it is finding fCell.Please Login or Register to view this content.
Any help would be greatPlease Login or Register to view this content.
Bookmarks