sheets.range problem

[paul_taylor]

This code works for me

range(cells(variable1,1),cells(10,variable2)). value = 1

This code doesn't work

sheets(1).range(cells(variable1,1),cells(10,variable2)).value = 1

Why not?

The reason I need this is I need to get to

sheets(2).range(cells(variable1,1),cells(10,variable2)) = sheets(1).range(cells(variable1,1),cells(10,variable2)).value

or something like that.

 

[AlphaFrog]

Try something like this...

[COLOR="Red"]Sheets(1).[/COLOR]Range([COLOR="Red"]Sheets(1).[/COLOR]Cells(variable1,1), [COLOR="Red"]Sheets(1)[/COLOR].Cells(10,variable2)).Value = 1

Or better yet...

With Sheets(1)
    [COLOR="Red"].[/COLOR]Range([COLOR="Red"].[/COLOR]Cells(variable1,1), [COLOR="Red"].[/COLOR]Cells(10,variable2)).Value = 1
End With

 

[paul_taylor]

Try something like this...

[COLOR="Red"]Sheets(1).[/COLOR]Range([COLOR="Red"]Sheets(1).[/COLOR]Cells(variable1,1), [COLOR="Red"]Sheets(1)[/COLOR].Cells(10,variable2)).Value = 1

Or better yet...

With Sheets(1)
    [COLOR="Red"].[/COLOR]Range([COLOR="Red"].[/COLOR]Cells(variable1,1), [COLOR="Red"].[/COLOR]Cells(10,variable2)).Value = 1
End With

Worked. ****. Nice job.