select range with x value as row 2

[chilly442]

Want to do something like this, but can't get it to work.

Any ideas???

x = 1
Sheets("Sheet1").Range("x + 1, 15: x + 1, 7").Select

If I run the above code I get:
"application-defined or object-defined error"

Thanks,
Chilly442

 

[ettienne]

Remove the quotes from

"x + 1, 15: x + 1, 7"

 

[AnotherHiggins]

Have a look at CELLS.

Something like this:

Sheets("Sheet1").Range(Cells(x + 1, 15), Cells(x + 1, 7)).Select

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.