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