Rob342
08-25-2012, 11:06 AM
I knew i would be back with this one from a previous post
I am using Chip Pearsons routine to find all occurences on a sheet
When i open up the form and go to that tab and run it it does not find anything at all, if i go back and clear Col T on the MainDB sheet then reinput "I" in that column then it works ok, But........... as soon as i close the WB down then reopen it go to that tab and run the routine it comes up with nothing again!!!!!!
Does anybody have any idea why it is doing this or am i missing something?
Have tried all the obvious (Trim) etc but nothing seems to work
Enclosed a sample workbook but this works every time??
Rob
I am using Chip Pearsons routine to find all occurences on a sheet
When i open up the form and go to that tab and run it it does not find anything at all, if i go back and clear Col T on the MainDB sheet then reinput "I" in that column then it works ok, But........... as soon as i close the WB down then reopen it go to that tab and run the routine it comes up with nothing again!!!!!!
Does anybody have any idea why it is doing this or am i missing something?
Have tried all the obvious (Trim) etc but nothing seems to work
Enclosed a sample workbook but this works every time??
Rob