[VBA] RowCount = Worksheets("Sheet3").Range("A7").CurrentRegion.Rows.Count [/VBA]

Is sheet3 named exactly as it is in your code?