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