I am receiving the error message:
"Run time error 52: Bad File name or error"
This occurs in the following code (I'm a novice trying to write a simple Do Until end of code macro):
Sub Change_Back_color()
'Change the interior cell color based on employee function.
Do Until EOF(1)
Select Case Resource
Case "Aiken Michael"
Cell.Interior.ColorIndex = 3
Case "Brown Jeanne"
Cell.Interior.ColorIndex = 3
End Select
Loop
End Sub
Can anyone help me understand the error message and why I'm recieving it/how to correct the error of my ways????
Thank you in advance for your help.
FusionRed
"Run time error 52: Bad File name or error"
This occurs in the following code (I'm a novice trying to write a simple Do Until end of code macro):
Sub Change_Back_color()
'Change the interior cell color based on employee function.
Do Until EOF(1)
Select Case Resource
Case "Aiken Michael"
Cell.Interior.ColorIndex = 3
Case "Brown Jeanne"
Cell.Interior.ColorIndex = 3
End Select
Loop
End Sub
Can anyone help me understand the error message and why I'm recieving it/how to correct the error of my ways????
Thank you in advance for your help.
FusionRed