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) |