Guidance required please...
Garry
I took onboard what you mention and I did the following.
Changed Cell to TEXT format
Changed the sheet back to text name "Bray"
Again, it hung on the sVal=.
So I undid all the changes again to reflect the numeric state and it worked.
Got me stumped, I even went to check if I had a "Missing" highlighted
reference libraries and I only have 2 in use and they are fine, 1 = Visual
Basic for Applications, the other being MS Excel 12.0 Object Library, with
this in mind, any thoughts spring to mind whereby you think I may need to
expand on my Library to add addition features that are possibly needed.
BTW: Although, at home I use 2007, this being for work, they use 2003.
Thx again
Mick.
|