I have recently been upgraded to Excel 2007 and I am running into some problems. One of the programs I run constantly does a simple conversion of a social security number to elimination the dashes (123-45-6789 gets converted to 123456789). The code below has done for me for years where ID is the old social security number and ssn will be the converted social security number
I am now getting an error when that says "Cannot find project or library" and Left in the the above code is highlight. I feel that in the VBA editor under Tools one of the References needed has not been checked. There appears to be about 200 references available and I haven't got the slightest idea which one might not be checked that should be.Please Login or Register to view this content.
In the past when I was in the VBA editor debugging a program I could place my cursur over a variable and it would give me the value of that variable in a little box near the curser. Now that I have Excel 2007 it has stopped doing this. Is this feature not in 2007 or is there a switch I need to flip to get that turned back on.
Can anyone help me with these two problems?
Bookmarks