Hi all,

I've just started learning vba and have a question that conventional google hasn't managed to help me with... I want to do an if statement which would look on a specified sheet in a different workbook.

The full filepath of the different workbook is: C:\BantersaurusRex\.....\DifferentWorkbook.xls

I have made a variable called WBTarget which is equal to the above directory.

My If formula looks like: If Workbooks(WBTarget).Sheets("Sheet1").Cells(r, Columns("C").Column).Value = [some criteria here]

I get a debug runtime error: 9 on the line above but can't figure out how to properly reference an external sheet within an if function...

Any help would be much appreciated!