error in VBA code (excel2007)

[wmbb]

What is wrong in the code below defining a range?

x=2
rng = Sheet1.Range(Cells(x, 2), Cells(x, 30))

 

[SkipVought]

Hi,

How is rng declared? It should be declared as a RANGE. Then...

Dim rng as range, x as long
x=2
[b][red]Set [/red][/b]rng = Sheet1.Range(Cells(x, 2), Cells(x, 30))

Is there a worksheet with a CodeName of Sheet1?



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[wmbb]

He Skip, Thanks for your quick response.
I just forgot "set"
Now it works like it should.

Thanks again.

 

[PHV]

For safety purpose I'd use full qualified objects:
Set rng = Sheet1.Range([!]Sheet1.[/!]Cells(x, 2), [!]Sheet1.[/!]Cells(x, 30))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886