Stuck using the Offset in Excel 2013, hi guys and gals, what is wrong with this code?

[Hurricanefly]

If Offset(0, 6).value = "Y" Then
Sheets("Sheet3").Select
Range("C21").Select

Any help would be great. In windows7 this code is fine.

If Activecell Offset(0, 6).value = "Y" Then
Sheets("Sheet3").Select
Range("C21").Select

Not sure why you have to say Activecell? Windows 7 so much better for VBA

[PcSaggio]

Hi,

Please Login or Register  to view this content.

Tested Excel 2013

[Hurricanefly]

Thanks for your reply, great help ta