Hi there,
I have the following code that assumes the value it is looking for is
always present:


Code:
--------------------

Range(Columns("A:A").Find("Unplanned Prospects").Offset(0, 0), _
Columns("A:A").Find("Unplanned Prospects Total").Offset(0, 14)).Select
Selection.borders(xlDiagonalDown).LineStyle = xlNone
Selection.borders(xlDiagonalUp).LineStyle = xlNone
Code:
--------------------


i've just run this and it couldn't find "Unplanned Prospects" so it returned an error.
how can I get around this?

thanks in advance,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=504857