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
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Todd Huttenstine" wrote in message ...
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