Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Im crap at VBA
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/ |