Hi. ...as a follow up... Checked out CDATE() and it advised that an error would occur if it recieved a wrong data type value is supplied, then we will...
Thank you both for the replies. I had in fact gone through Excel setting to ensure UK. However the system setting was US??? Just now changed thet. ...
Hi Catalin, and thank you for the quick response. The 12 data sheets, and therefore the structure of the data, evolved over several years. I started o...
Hi. Yes... The gardening tasks - - are listed in chronilogical order. Not all dates exist on the data sheet and of those that do, most are repeate...
Hi All -- Beepee again. The first reply to this post works and solved my immediate problem. Many thanks to Catalin. However I am still strugglin...
Hi Its Beepee again. Please ignor my previous reply to this post... STUPID HAST on my part. It all works fine now that I have my head straigh...
Hi Catalin. Thank you for responding to my query. I had tried "xlValues" but I had not used any other date format. However, having made the chan...
That is perfect. Thanks again. Beepee
Hello again -- said I may be back. I think my mum told me about biting off more than I can chew!!!!! Sorted the ListBox issue thanks. Now it works ...
Thought it would be something straightforward. Many thanks this problem is now resolved - not getting the right results displayed but I'll try to res...