My VBA code stopped working please help.

Originally Posted by dangelor

There is a difference between Sheets(1) and Sheet1. Sheet(1) is the first worksheet tab, while Sheet1 is the name of a particular worksheet. Is it possible that your Sheet1 is not the 1st tabbed worksheet?

You missed the important bit where I said "if Sheets(1) is the leftmost sheet tab AND it also has the VB CODE name Sheet1"

@DarkOPrince.

There are three ways of directly referencing a particular sheet.
1. Sheets(x) where x is an index number representing the number of sheets across the tab names starting with the left hand sheet. So Sheets(3) will be the third sheet from the left

2. Sheets(string) where string is the sheet tab name.

3. Sheetx where x is any integer. This is the VBA sheet code name.

You should always work with the VBA code name since the sheet tab name is too easily changed which will cause any code that uses it to fall over. Similarly avoid the sheet index number since a sheet tab can be dragged to another position on the bar that contains the sheet tab names.