Variable not working(Type Mismatch)-New to VBA

[sculler]

I am trying to have a row variable so that I can increment it as need be. However, when I write

Worksheets("Project Summary-Resources").Rows("ProSumRow:ProSumRow").Interior.ColorIndex = xlNone

I get a "Type mismatch" error. Do I need to declare ProSumRow as a certain variable? option explicit is off.

When I replace ProSumRow with an integer the code works. Any Help?

 

[Norie]

If ProSumRow is a variable try this.

Worksheets("Project Summary-Resources").Rows(ProSumRow)Interior.ColorIndex = xlNone

 

[sculler]

Thanks! That worked, you just saved me from 30 minutes of frustration

If ProSumRow is a variable try this.

Worksheets("Project Summary-Resources").Rows(ProSumRow)Interior.ColorIndex = xlNone