Select method of Range class failed" error message

**Session101** · 11-12-2009, 08:36 PM

Hey guys,

My macro is searching for a string in a cell, then upon finding it, select the entire row and copy/paste it to another sheet. However, I am getting a "Select method of Range class failed" error message when I try to select the entire row. Can someone check this out?

Please Login or Register  to view this content.

TIA!

**Palmetto** · 11-12-2009, 10:11 PM

Per the Forum rules you agreed to follow, all VBA code must be wrapped in code tags. Please amend your post by applying code tags. How: highlight all of the code then click the # button.

After complying with the rule for code tags solutions to your question will be provided.

Thanks.

**Session101** · 11-13-2009, 12:59 AM

I apologize as I forgot. My post has been amended. Thanks.

**protonLeah** · 11-13-2009, 01:47 AM

Try adding the line: Sheets("Trades").Select before the While...

Also, when pasting to the second sheet I got a warning message: 'areas not the same size...' so I changed the line: Rows(CStr(LCopyToRow) & ":" & CStr(LCopyToRow)).Select to

Please Login or Register  to view this content.

**Marzuk** · 11-13-2009, 01:54 AM

Please Login or Register  to view this content.

x is the row being copied, y is the row you are going to copy to. Just use a counter for Y most likely, and you are home free. No selection / activation of sheets needed.