Range Selection Problem

I am having a problem with selecting a range for some reason tonight. I have tried everything I know to do and nothing seems to be helping.

Here is all of the code

Please Login or Register  to view this content.

This is the line that is giving me the problem (4th up from the bottom)

Please Login or Register  to view this content.

Everytime I run the code I get "Select method of Range Class failed"

This has got to be something simple. Maybe I am just tired and need to go home for the night!

Does anyone have any suggestions!

Do you realize you have the "Range" property twice in that line?

Please Login or Register  to view this content.

Update: You may also need a line before that to activate the sheet if it's not the active sheet, e.g.

Please Login or Register  to view this content.

pjoaquin,

I forgot to take the second range out of my post. That was one of those "I know it is wrong, but let's try it anyway" type of things.

What you sent

Please Login or Register  to view this content.

fixed the problem. I knew it was something simple. It has just been a long day and the old brain is not quite up to speed.

Thanks a bunch for the help!