searching only part of the values in a cell

[saziz]

Hello All,

I have a pretty large sheet to look into ("CellData"). I am looking in column B which has the following value pattern:

129(8769)

I would like a vba code to search based upon numbers in brackets i.e 8769 only and once it is found that row should be put in a new sheet.

Will appreciate any help in this regard.
Thank you for your help.
Saziz

[Rick_Stanich]

This should get you started.
In a worksheet (column B) I have three entries that have the exact verbiage and three entries that do not.
It finds the correct entries based on your Yes or No answers.

Please Login or Register  to view this content.

[saziz]

Thank you Rick. How can I put the found complete row in a new sheet?
Appreciate your help.
Thanks
Saziz

[Rick_Stanich]

Unfortunately, that is an area I am stumbling on for my own code in this post:
http://www.excelforum.com/showthread.php?t=635034

If I find a fix I will adapt to the code I provided here.

[saziz]

Rick,
Thank you. I will be looking for it.
Saziz

[saziz]

Hello All,

I have a pretty large sheet to look into ("CellData"). I am looking in column B which has the following value pattern:

129(8769)

I would like a vba code to search based upon numbers in brackets i.e 8769 only and once it is found that row should be put in a NEW SHEET.

Will appreciate any help in this regard.
Thank you for your help.
Saziz

[jindon]

try

Please Login or Register  to view this content.

[saziz]

Hi Jindon,
Thanks for your help. I get 'Object Required' error when I run your code.
Saziz

[SOS]

Hi all,

The only change I had to make to jindon's code was to add an End With and it works well:

Please Login or Register  to view this content.

[saziz]

SOS,
Yes I did that too. It says object variable or with block variable not set.

Thanks
Saziz

[jindon]

SOS,
Yes I did that too. It says object variable or with block variable not set.

Thanks
Saziz

Is it not working?