Active cell, row, column, worksheet, etc
 

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

Active cell, row, column, worksheet, etc
 

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

Active cell, row, column, worksheet, etc
 

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