Last row Code
 

This is the third time I have tried to post this question. I can't seem to
find it anywhere. My question is this. I have the below code, which works
great. Howvever, I would like it to reference the active sheet, as opposed
to a spelled pout one. This way I can use repeatedly, without having to
reference the specific sheet name.

Any help would be great.

Thanks!

Mike

Last row Code
 

This is the third time I have tried to post this question. I can't seem
to
find it anywhere. My question is this. I have the below code,

There was no code below...


which works great. Howvever, I would like it to reference the active
sheet,
as opposed to a spelled pout one. This way I can use repeatedly, without
having to reference the specific sheet name.

Where you spell out the sheet name (as a String value), I would guess you
could replace that String value with this...

ActiveSheet.Name

and concatenate that in instead.


Rick

Last row Code
 

With Activesheet

'do stuff

End With

But what is wrong with referencing a specific sheet name, at leat you know
you have the correct sheet then. Someone or something may change the
activesheet.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike Milmoe" wrote in message
...
This is the third time I have tried to post this question. I can't seem
to
find it anywhere. My question is this. I have the below code, which
works
great. Howvever, I would like it to reference the active sheet, as
opposed
to a spelled pout one. This way I can use repeatedly, without having to
reference the specific sheet name.

Any help would be great.

Thanks!

Mike