peacenik
08-31-2005, 01:39 PM
I have this code that will run without issues on Office XP but is not running on Office 2003.
I had to explicitly declare all my variables, (I know, I should do that anyway) but I am still getting an error in this code.
Function findalphacolumn(ColumnNo) As String
If ColumnNo > 26 Then
findalphacolumn = Chr(Int(ColumnNo / 26) + 64) & Chr((ColumnNo Mod 26) + 64)
Else
findalphacolumn = Chr(ColumnNo + 64)
End If
End Function
The error I am getting is "Can't find project or library" and the first chr() is highlighted. Any ideas. http://vbaexpress.com/forum/images/smilies/banghead.gif
I had to explicitly declare all my variables, (I know, I should do that anyway) but I am still getting an error in this code.
Function findalphacolumn(ColumnNo) As String
If ColumnNo > 26 Then
findalphacolumn = Chr(Int(ColumnNo / 26) + 64) & Chr((ColumnNo Mod 26) + 64)
Else
findalphacolumn = Chr(ColumnNo + 64)
End If
End Function
The error I am getting is "Can't find project or library" and the first chr() is highlighted. Any ideas. http://vbaexpress.com/forum/images/smilies/banghead.gif