Excel Macro Prob

[Hadfield82]

First off I am a total noob when it comes to VB. Anyway, I'm having a problem figuring out how to select a particular row using a variable ive set (Row) as an integer, to act as a counter. (I want it to go down each row and compare it to another sheet).


I'm trying this:

Rows("Row:Row").Select

But it doesnt seem to like that at all


Anyone got any ideas how I can do this?

[bingodave]

Anything within the inverted commas will be treated as a value, not a variable, hence this:

Rows(Row & ":" & Row).Select

will give the desired result

[Hadfield82]

Brilliant mate, thanks a lot