[RESOLVED] Parts of macro made in 2007 not working in 2010
I'm attempting to use a macro in Excel 2010 that a coworker made using Excel 2007. The majority of the macro works fine, excel for one section:
Private Function IsCheckedOut() As String
Do While ActiveCell.Value <> ""
If ActiveCell.Value = ScanNumber.Value Then
MsgBox "Found Scan Number"
If ActiveCell.Offset(0, 2).Value = "" Then
MsgBox "Not Checked Out"
IsCheckedOut = "Yes"
MsgBox "Looping to Next Row"
IsCheckedOut = "No"
I've added some message boxes to see where it gets, and in a situation where it should be setting "IsCheckedOut" to "Yes" it is not getting past the first "If" statement, I'm only seeing the "Looping to Next Row" box.
Any ideas why this is not working in 2010? All my googling has not yielded anything informative.