Run-Time Error '424': Object Required

[marcus.brown]

Hi,

I have a piece of code which was working ok. However, i realised that when comparing two strings the case may not be correct, so amended my code

from:
i_name = Sheets("Sheet1").Cells(rCount1, 1).Value

to:
UCase(i_name) = UCase(Sheets("Sheet1").Cells(rCount1, 1).Value)


Not sure what i've done incorrectly please help (this is the first instance where this type of check is being made, there will be others further down the code.

Thanks!

 

[VoG]

Try

i_name = UCase(Sheets("Sheet1").Cells(rCount1, 1).Value)

 

[marcus.brown]

Thank you - that worked. Can't believe i hadn't realised that error - d'oh!