A loop if a cell equals to cell text

[sabre_slychimp]

I am looking for a VB way of if the active cell is equal to the text "Benefit" then xldown else add borders to the cell (i already have the code for) and then move up one cell.

This is for a copied over spreadsheet that I only want the values for so all of the formatting I am doing in VB. all is fine untill I get to a section where the amount of rows can be different everytime. My idea is to xldown to the bottom of the column and then work my way back up till U reach the cell with "Benefit". I would like it to stop then and xldown to the bottom. I am a bit rusty on VB so any help would be great.

[thisisgerald]

Can you paste your code or upload a sample workbook?

[sabre_slychimp]

all i have so far is

Please Login or Register  to view this content.

I have not even stated a loop yet. but just by doing this I know that the cell with the text Benefit in it does not work.

[Cutter]

@ sabre_slychimp

Welcome to the forum.

Please notice that [CODE] tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

[sabre_slychimp]

I have managed to find a way of doing it. This checks to make sure the cell text is not called Milestone and then merges two cells together and the moves up one to the next row until it gets to the cell called Milestone.

Please Login or Register  to view this content.

I have had to make all the cells hight the same as there could be more text in and it will have to text wrap, but some strange reason the autofit command makes it only one line.