subscript out of range

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
 
D

David McRitchie

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
--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Syntax 3
ListIndex 2
Creating a defined name's Refersto range 2
Select range from unopened workbook 7
subscript out of range error: tyring to copy a hidden sheet 3
subscript out of range error: tring to copy a hidden sheet 1
ERROR: subscript out of range 6
Runtime Error 9 8

Top