subscript out of range

[janefo]

Hi,

I tried to add 3 non adjacent cells,but I get this error message
runtime error 9
Subscript out of range
I look at help, but did not understand it. Can someone explain to me why this happen?
Thank you,

janefo

 

[sathish_fun]

hi

if you are trying to add 3 cell ,then try this

 Range("A6").Select
        ActiveCell.FormulaR1C1 = Range("A5").Text + Range("b5").Text + Range("c5").Text
    Range("A6").Select

 

[Trebor76]

That error message is usually generated when you're trying to reference a tab name incorrectly. Make sure the spelling of any tab you're referencing is exact and try again.

 

[janefo]

Thank you.
janefo