Why does code only works in Sheet1

[wmbb]

The code below works fine starting the macro from sheet1 but starting the macro from another sheet I get an error message.
[red]methode "range" of object "_worksheet" failed[/red]

For Each cell In Sheet1.Range(Cells(x, 2), Cells(x, 30))

How to change the code to get the macro working from any sheet in the workbook ?

 

[wmbb]

I don't understand it, but when I change [blue]Cells(x,2)[/blue] and [blue]Cells(x,30)[/blue] into [red]Sheet1.Cells(x,2)[/red] and [red]Sheet1.Cells(x,30)[/red] it works.

 

[SkipVought]

ALL range reference ought to be fully referenced...

with Sheet 1
   For Each cell In .Range(.Cells(x, 2), .Cells(x, 30))

   next
end with

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wmbb]

Again, thanks for your help.
I'm learning every time I visit this forum.

 

[SkipVought]

oops, I had a extra SPACE in Sheet1.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wmbb]

Okay, I understand.
This is the other way.