Active spreadsheet

[Panoos64]

Hi all, i have a workbook with many sheets and i would like to modify a little bit the below VBA code so that to runt only in active spreadsheet.

Thanking you in advance


Range("S3").Select
ActiveCell.FormulaR1C1 = _
"=IFERROR(VLOOKUP(RC16,'C:\Users\User\Desktop\[FINGER.xlsx]Sheet1'!R13C2:R10000C47,36,FALSE),"""")"
Range("S3").Select
Selection.AutoFill Destination:=Range("S3:S3050"), Type:=xlFillDefault
Range("S3:S3050").Select

 

[Joe4]

If you do not include and sheet references in your range references, it will only run on the ActiveSheet, by default.
So, you shouldn't need to do anything.

If it is not running on the sheet you want it to, that means that you are not on the sheet you think you are when the code runs.

 

[Panoos64]

Thanks Joe, i tested and it works as your advice. Thank you so much for your support. Have a nice day