I'm trying to select a range of cells with the Target address but I'm getting "Object Required" error. What I have is:
I remember having this problem before I just can't remember how I fixed it.Please Login or Register to view this content.
I'm trying to select a range of cells with the Target address but I'm getting "Object Required" error. What I have is:
I remember having this problem before I just can't remember how I fixed it.Please Login or Register to view this content.
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
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I'm going to guess (and assuming Target is actually a valid object in this context):
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
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.
Last edited by Demon4231; 04-14-2011 at 12:25 PM.
Change this:
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.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks