Selecting Range with Target cell

[Demon4231]

I'm trying to select a range of cells with the Target address but I'm getting "Object Required" error. What I have is:

Please Login or Register  to view this content.

I remember having this problem before I just can't remember how I fixed it.

[TMS]

It would be better if you posted the workbook so this line of code can be seen in the context of the module and the data.

Regards

[romperstomper]

I'm going to guess (and assuming Target is actually a valid object in this context):

Please Login or Register  to view this content.

[Demon4231]

I tried the code but I get the same error. What I have is:

Please Login or Register  to view this content.

EDIT: I got it, Target was not a valid object. I had to assign a variable before calling the sub.

[romperstomper]

Change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

and replace this:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.