Pull the information of a searched cell up as well

**FCarv** · 08-17-2012, 08:06 AM

Hello guys,

I am recent at the forum, therefore please forgive me if I have skipped something I shouldn't.

I am doing a macro that searches a certain text and then selects that cell as well as the rest of the column (from that text cell to the end) and pulls it to the cell before.

Example:
Searched Text: Fe.contab.

Text Position: Uncertain (Not fixed)
Last Cell of that Column: Uncertain (Not fixed)

P.S: Each file has a different amount of rows. it can be 30 or it can be 1584..So that's why it's Uncertain (Not fixed)

Let's pretend the searched text is at cell A317 (like the attached file I placed). What i want is that the information from that cell untill the end of column be one cell up, which means that it will start not on A317 but on A316.

The code i have come up untill now is the following

Please Login or Register  to view this content.

I believe the problem is at:

Determining the cell it starts and where it stops

Please Login or Register  to view this content.

and at:

Determining the cell where it should be placed

Please Login or Register  to view this content.

I hope you did understand what i meant with the code i'm building and I'm looking forward for a reply.

Thank you guys.

Kind Regards,
FCarv

**patel45** · 08-17-2012, 09:47 AM

Please Login or Register  to view this content.

**FCarv** · 08-17-2012, 10:06 AM

Hello patel45,

Thank you for your prompt feedback.

Your code is far more complex of what i'm used to

The part you did not understand was probably the part where I was trying to set it to paste into the Cell before where it was.

Example: Was at A317 and I need to to paste to the A316, but has the little problem of being uncertain.

Nevertheless the first part of the code is running perfectly. It selected what I wanted to, and cut it. Now I only need to paste into that cell I said to you above in the example.

**FCarv** · 08-17-2012, 11:02 AM

Ok, sorry about the double post but I managed to build the rest of the code

Therefore the final code will be the following:

Please Login or Register  to view this content.

I forgot about the offset option that would do just what I wanted to.
I will put the thread as SOLVED.

patel45, thank you so much again. I think I gave you a like(at star) but i'm not sure

Kind Regards,
FCarv