subscript out of range

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Whats wrong with the below code? I am getting the error subscript out of
range.

Worksheets("Reps Current").Range("H1").Value = "= (Total" & IndxNumber & " -
'On Time " & IndxNumber & "')/ Total" & IndxNumber



Todd Huttenstine
 
The subscript out of range is probably not having a
a worksheet named "Reps Current" spaces have to
match exactly you could have spaces at the end, but I
don't know what the rest of it is and if it is a formula
you probably want .formula = instead of .value =

=(Total3 - 'on Time 3')/Total3
--
 
Back
Top