Macro dosn't recognize the value in a cell?
Posted by Paul Magruder on June 26, 2001 11:44 AM
Having trouble with the macro recognizing the value in column "N" (ins). If I check the code, it knows the value from the inputbox, but won't recognize the number when searching column "N". I have tried formatting as Text and Number....If I retype the number in "N" it sees it.....If I bring it in using copy / paste it dosn't see it...any Suggestions?
Sheets("By Shift").Select
Range("n6").Select
ins = InputBox("Insurance Number?")
Range("N2") = ins
Sheets("People").Select
Range("a2") = ins
Sheets("By Shift").Select
Range("n5").Select
Do Until ActiveCell = "xxx"
If ActiveCell = ins Then
Selection.EntireRow.Copy
ActiveCell.Offset(1, 0).Select
Sheets("People").Select
Range("a5").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste
Selection.Value = Selection.Value
End If
ActiveCell.Offset(1, 0).Select
Sheets("By Shift").Select
Application.CutCopyMode = False
loop
end sub
Thanks
Paul