I'm new to excel programming and have written a quite complicated sheet....... any way i'm stuck on this and was wondering if anyone could help. It's been driving me mad because on my main pc this code works fine with no issues........ but as soon as I put onto a different machine I keep getting the 91 error and I don't know how to solve it can you help me?

Heres the code
-----------------------------------------------------------------------------------------------
Sub Delnowin()

Dim uRange As Range
Dim FindTitle As Range
Dim tRow As Integer
Dim tCol As Integer
Set uRange = ActiveSheet.UsedRange
Set FindTitle = uRange.Find("NO WINNER")

tRow = FindTitle.Row <----- this is the line that the debugger says is the issues!!!

Rows(tRow & ":" & tRow).Select
Selection.ClearContents

------------------------------------------------------------------------------------------------
I can supply more of the code I have written but this is the only bit that is letting the whole thing down.

I'm sure there is a simple fix but as I can't see it!

Any help would be appreciated!

Many thanks in anticipation.

Bighitch