See additional replies to your other post.

"Taner Kalkay <" wrote:

I was not able to solve my problem yet. I am trying to find a row
carrying certain data in a page and I want to cut this row and paste to
another page.

VLOOKUP finds any data at the search column and and copies the indexed
value found at the place where the VLOOKUP required.

With this I can copy all the row that found data exist. But my problem
is also to delete the contents of the copied row or indidually the
cells at their original place.

When I use FIND Function it behaves similar to VLOOKUP and finds and
copies the data where it is required, When I use the Search under the
File Tab in Excell it finds and shows the row that I want to operate.
This is cool but it requires the search data to be typed (no cut and
paste allowed). But I dont want to type it because I want to use this
operation, finding, cutting and pasting in a macro.

Do I want something impossible ?

If anyone can help I will be greatfull.

Taner Kalkay

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson