Hello all,
I have altered a simple macro to find a record within a sheet why oh
why does it not work when a new work sheet is created and I copy the
macro across and also how do I make this search all sheets within a
work book all help gratefully received.

Sub cmdFind_Click()
Dim nResult As Integer
Dim cFind As String
Dim cBookMark As String
'
Cells.Find(range("a1"), LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False).Activate


End Sub


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/