Sorry for a really daft question, I’ve trawled the internet trying t
find this particular method of extract the range value. I have a loo
that looks for cells that contact a particular value, one a cell i
found it should call another sub passing the cell name i.e B3 as a
argument.

Sub FindValueOfCell()
For Each Cell In Range("A1:L40")
If Cell.Value = "Apple" Then
Call DrawBordersFunction(Pass range value to other sub?)
End If
Next
End Su

--
webby200
-----------------------------------------------------------------------
webby2006's Profile: http://www.excelforum.com/member.php...fo&userid=3674
View this thread: http://www.excelforum.com/showthread.php?threadid=56901