Modifying code for copying and pasting between sheets

Hi, and welcome to the forum.

Please take a few moments to review the rules and guidance notes, particularly the requirement to make sure VBA code is placed between code tags, which makes it more readable. I've edited it for you on this occasion.

The answer to your question is to use the VBA instruction Instr in your code. i.e.

Please Login or Register  to view this content.

The default result for a Range instruction is the Value of the range addresses, hence there's no need for .Value

You will also speed up your macro if you do away with all the .Select instructions. There's no need for them. Just address the object directly and add the appropriate instruction. So instead of

Please Login or Register  to view this content.

Hello-

I am working on a sheet where I want to copy and paste all rows within a column that contain the value ";" into another sheet. This code works if the cell value is equal to ";" alone but not if it's mixed with other characters. (ex: P330;P440). I think this is relatively simple to modify, but I am new to macros and can't figure it out. Here is the code (copied from another source and modified).........

Please Login or Register  to view this content.

Any help would be greatly appreciated. Thanks!

john