I'm getting an error with the below snippet of code, for some reason it seems to want to create another sheet with the same name 'DkRateVariances' The sheet name is not mentioned anywhere else in my code and if I change that page name I still get there error, can anyone help me fix this?
Code:Sheets.Add.Name = "DkRateVariances" Set DKData = ActiveSheet myRow = 4 myCol = 4 Do Until CADsheet.Cells(2, myCol) = "" DKData.Cells(myRow, 1) = CADsheet.Cells(2, myCol) myCol = myCol + 1 myRow = myRow + 1