getting error : select method of range class failed

**clammastak** · 05-11-2015, 04:10 PM

I am getting this error when running the following macro. I think it has to do with my "range.select" but not sure how to work around it. any help?

Please Login or Register  to view this content.

**AB33** · 05-11-2015, 04:36 PM

Replace these two lines

Please Login or Register  to view this content.

with this line

Please Login or Register  to view this content.

**shg** · 05-11-2015, 04:40 PM

Please Login or Register  to view this content.

@ AB: That second range reference is to the active worksheet -- was that your intent?

**clammastak** · 05-11-2015, 05:08 PM

Thanks for the help! I found this to be the most useful...really appreciate your help.

Please Login or Register  to view this content.

Re: getting error : select method of range class failed