Autofill Macro not working

Dear Friends,
Does the worksheet number given in the code refers to sheet number under VBA project. (kindly refer to screenshot).Error.jpg
I copied a code from another website, but is not working.

I have a code that is in sheet6 (Cost Center Owner)

I want the formula in range A6:C6 and F6:G6 to be copied down to A6:C5000 and F6:G5000. The purpose of this code is to update the formula up to 5000 rows if any rows is deleted / inserted by the user.

The code below is not working. Kindly let me know how to fix this code.

Please Login or Register  to view this content.

Thanks,
Rahul

What you are referring to are the sheet codenames, which can be used like

Please Login or Register  to view this content.

The sheet index

Please Login or Register  to view this content.

is the position of the sheet in the workbook.
So the left most sheet will be sheets(1)