Hi,

Using some of Ron's Code. I want to change this bit of code to look at first sheet regardless of Sheet name

 GetData FName(N), "Sheet1", "A1:C1", destrange, False, False

tried this but didn't work
Sheets("Sheet1")

Any help appreciated

VBA Noob