I have this formula:

=IF(ISERROR(MATCH(old!$C$1:$C$" & overallLastRow & ",new!$C$1:$C$" & overallLastRow & " ,0)),old!$C$1:$C$" & overallLastRow & " ,"""")
It doesn't matter what the formula does, I know it works. The problem I have is rather than acting with specific sheets i.e. old and new I want it to use sheets known as oldSheet and newSheet.

These have been declared (is this the right term) earlier in the code as:

Dim oldSheet As String
oldSheet = "OLD ONE"
Sheets.Add.Name = oldSheet
This is my last post before I can get some rest :P

Thanks Guys!
Dave