String search + page break

**StephenR** · 10-08-2009, 08:37 AM

Do you have "project" in A1? If so, you can't add a page break before row 1. EDIT: should say, needless to say, the code works for me otherwise.

**shg** · 10-08-2009, 08:41 AM

Dunno if that's the problem, but good catch, Stephen, thank you.

Prior post corrected.

**VTdude12** · 10-08-2009, 12:01 PM

That worked great. Thanks all!

One more thing:

Would it be easier to include this into the same macro or create a seperate one:

1) When it finds "Project" -- in column C of the same row --
=right(cell w/ "project", 9)

2) Copy and paste special that cell (I need it in number format to vlookup against it)

3) In column D of the same row -- =vlookup(# from column C, Sheet1!A:B, 2, FALSE)

Please let me know if you need any further information! THANKS!