Dim temp_range As Range

Set temp_range = Worksheets("Template").Cells.Find(Value:="Sum. Table"
_
SearchOrder:=xlByRows)

When i run this in a subroutine I get this error:
"Named arguement not found."

All I want to do is locate the cell with the value="Sum. Table" an
figure out its address so I can assign it as the beginning of
continuous range that is 3 cells wide and 4 cells deep

--
botha82
-----------------------------------------------------------------------
botha822's Profile: http://www.excelforum.com/member.php...fo&userid=3675
View this thread: http://www.excelforum.com/showthread.php?threadid=57009