Hi All,
I have posted this before however no one posted back, maybe due to the stupidly unwhieldyness of the code I have so far.
I am attempting to serach a column of data in a workbook (this column displays decimals up to 1dp/v.important). I want to be able to search the column and every time an integer or decimal is found, run a code that populates bookmarks with the data found in the rame row numbers as the search returns when a number or decimal is found. To add another level to the confusion I also would if possible like for if there is more that one decimal and they =< 1 then they add 2spec numbers to the same sheet.
What I am trying to do is create a pallet marker sheet which is populated with data from my delivery note.
The code which I have written is a huge if statement;
I don't believe its the best way to do it, but my knowledge stops here really. Any help or advice would be great
The limitations of my current code is that I have had to scale back the amount of numbers I can check to 9 as I butted up against the 1000line limit for VBE.
I can't post my whole code as it wildly exceeds the character limit of the forum, so I have given the top snippet. I can post wb & wrd doc if that would help?
Thanks
Bookmarks