'If Left' no longer works

**Steve Riley** · 10-04-2012, 11:01 AM

I used the following in Excel 2003 but it give a 'Compile Error: Can't find project or library' in Excel 2007
Any help would be appreciated

If Left(iVal, 2) <> "00" Then
iVal = "00" & iVal
ElseIf Left(iVal, 1) <> "0" Then
iVal = "0" & iVal
End If

**shg** · 10-04-2012, 11:03 AM

In the VBE, Tools > References, untick any marked MISSING.

**Steve Riley** · 10-04-2012, 11:06 AM

References is Greyed Out

**shg** · 10-04-2012, 11:18 AM

Press the Reset button on the Debug toolbar, or Run > Reset

**Steve Riley** · 10-04-2012, 11:32 AM

Thanks

Problem solved!

'If Left' no longer works

LinkBack

Thread Tools

Rate This Thread

Display

'If Left' no longer works

Re: 'If Left' no longer works

Re: 'If Left' no longer works

Re: 'If Left' no longer works

Re: 'If Left' no longer works

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions