Hmmm, I thought so, I looked and used the PULL function (and I really liked it, but the problem I came across was the speed, it was just toooo SLOW).
Also looked at the inderict.ext in the more function add in. But the company does not have it installed.
So I came with using the find the replace method, it does the trick (only just). I ended up with the following:
Sub Macro1()
ActiveCell.Replace What:="01.01.2113", Replacement:="02..01.2013", LookAt _
:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
I have replaced the Waht:="01.01.2013" with "??.??.???"
What do you think? Was going to write some VBA code to make sure the date entered was the correct if not exist sub.
Any thoughts, do you fell I could do better? If so any help in simply pointing me in the right direction would be great.
The only thing left for me is to loop through the different name ranges. I think I shd be able to that.
Many thanks for looking at my problem. I REALLY appreciate the time you have spent.
Kind regards
Vj