| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find the last Fred and goto cell
Hello from Steved
Using the below I want to have a macro that will find the last Fred which in this case is in Cell A4 and put the cursor there please. A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Thankyou |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find the last Fred and goto cell
Look in the vba help index for FIND and then xlprevious from the bottom up
-- Don Guillett Microsoft MVP Excel SalesAid Software "Steved" wrote in message ... Hello from Steved Using the below I want to have a macro that will find the last Fred which in this case is in Cell A4 and put the cursor there please. A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Thankyou |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find the last Fred and goto cell
Hello from Steved
How do I ask the below to find the Last "Fred" please Sub Find() Cells.Find(What:="Fred", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate End Sub Thankyou. "Don Guillett" wrote: Look in the vba help index for FIND and then xlprevious from the bottom up -- Don Guillett Microsoft MVP Excel SalesAid Software "Steved" wrote in message ... Hello from Steved Using the below I want to have a macro that will find the last Fred which in this case is in Cell A4 and put the cursor there please. A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Thankyou |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find the last Fred and goto cell
Option Explicit
Sub myFind() Dim FoundCell As Range With ActiveSheet With .Range("a:a") Set FoundCell = .Cells.Find(what:="Fred", _ after:=.Cells(1), _ LookIn:=xlValues, _ lookat:=xlWhole, _ SearchOrder:=xlByRows, _ searchdirection:=xlPrevious, _ MatchCase:=False) End With End With If FoundCell Is Nothing Then MsgBox "Fred wasn't found!" Else Application.Goto FoundCell, scroll:=True End If End Sub Steved wrote: Hello from Steved How do I ask the below to find the Last "Fred" please Sub Find() Cells.Find(What:="Fred", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate End Sub Thankyou. "Don Guillett" wrote: Look in the vba help index for FIND and then xlprevious from the bottom up -- Don Guillett Microsoft MVP Excel SalesAid Software "Steved" wrote in message ... Hello from Steved Using the below I want to have a macro that will find the last Fred which in this case is in Cell A4 and put the cursor there please. A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Thankyou -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find the last Fred and goto cell
Thankyou.
"Dave Peterson" wrote: Option Explicit Sub myFind() Dim FoundCell As Range With ActiveSheet With .Range("a:a") Set FoundCell = .Cells.Find(what:="Fred", _ after:=.Cells(1), _ LookIn:=xlValues, _ lookat:=xlWhole, _ SearchOrder:=xlByRows, _ searchdirection:=xlPrevious, _ MatchCase:=False) End With End With If FoundCell Is Nothing Then MsgBox "Fred wasn't found!" Else Application.Goto FoundCell, scroll:=True End If End Sub Steved wrote: Hello from Steved How do I ask the below to find the Last "Fred" please Sub Find() Cells.Find(What:="Fred", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate End Sub Thankyou. "Don Guillett" wrote: Look in the vba help index for FIND and then xlprevious from the bottom up -- Don Guillett Microsoft MVP Excel SalesAid Software "Steved" wrote in message ... Hello from Steved Using the below I want to have a macro that will find the last Fred which in this case is in Cell A4 and put the cursor there please. A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Thankyou -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find the last Fred and goto cell
A1...Fred
A2...Biff A3...Fred A4...Fred A5...Lisa Hmmm....that looks familiar! -- Biff Microsoft Excel MVP "Steved" wrote in message ... Hello from Steved Using the below I want to have a macro that will find the last Fred which in this case is in Cell A4 and put the cursor there please. A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Thankyou |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find the last Fred and goto cell
Hello Biff from Steved
oops! yes I thought I'd use it it to explain what I required "T. Valko" wrote: A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Hmmm....that looks familiar! -- Biff Microsoft Excel MVP "Steved" wrote in message ... Hello from Steved Using the below I want to have a macro that will find the last Fred which in this case is in Cell A4 and put the cursor there please. A1...Fred A2...Biff A3...Fred A4...Fred A5...Lisa Thankyou |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you count number of times Fred Smith appears in a list | Excel Discussion (Misc queries) | |||
| Goto a specific cell in a macro | Excel Discussion (Misc queries) | |||
| Are Fred Pryor Seminars good? | Excel Discussion (Misc queries) | |||
| I need help fred smith | Excel Worksheet Functions | |||
| Goto a dynamic cell address within a macro | Excel Discussion (Misc queries) | |||
Linear Mode
