vba like using cell formulas

[ccordner]

I'm struggling with something that should be oh so easy.

I want to test, using vba, if the formula in a cell references another worksheet (the code later depends on following a reference).

I have so far:

if Sheets("Week 2").range("D17").formula like "='*'!" then
Code here
else
failure code
end if

Ultimately, I want it to be sheets(sheetname).cells(row, col)

Thanks
Chris

 

[VoG]

Maybe like this

If Sheets("Week 2").Range("D17").Formula Like "='" & "*" & "'!" Then

 

[ccordner]

Thanks for that.

Just discovered what it was! Should have been like "='*'!*".

Otherwise it's looking for something with JUST a sheet reference.

Chris