I have recently installed Office 2007. I have a program used by more than just myself and I'm getting errors such as "Can't find project or library" and the code highlights both "UCase" and "Trim" so far. Are these functions no longer used in 2007? I have to be able to run the code for production purposes and I'm not sure how to work around this problem. This "program" was something I created quite a few years ago under a much earlier version of Excel and I've never had a problem running this particular code over the years until now. Any help would be appreciated. A sample is below:
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = True
.Font.Name = "Arial"
.Font.Size = 9
.Formula = _
"ONE (1) " & Worksheets("Misc Calcs").Range("BF37").Text & " " & UCase (Worksheets("Cust Info").Range("C18").Text) & " VIBRATING CONVEYOR"
The code halts at UCase...