When coding I use this alot : Worksheets("sheet1").Cells(y,x) or .row(y) or
..column(x) is there code to use to choose the active row, column, cells, or
worksheet....so that i don't have to change the worksheet name every time I
want to use some code I wrote on another sheet?

Thanks

Hi,
If you go into a module and open the immediate window and the library, you
can try these things out.
?activesheet.name
Sheet1
?activecell.address
$A$1
?activecell.Row
1
?activecell.Column
1
This will help you reference objects. Hope this helps.

Thanks,

"sip8316" wrote:

When coding I use this alot : Worksheets("sheet1").Cells(y,x) or .row(y) or
.column(x) is there code to use to choose the active row, column, cells, or
worksheet....so that i don't have to change the worksheet name every time I
want to use some code I wrote on another sheet?

Thanks

You will kick your self when you read this.
Try
Activesheet
Activecell
Activecell.row
activecell.column

Chris


"sip8316" wrote in message
...
When coding I use this alot : Worksheets("sheet1").Cells(y,x) or .row(y)
or
.column(x) is there code to use to choose the active row, column, cells,
or
worksheet....so that i don't have to change the worksheet name every time
I
want to use some code I wrote on another sheet?

Thanks