VBA: search for a value then Moving cusor [Closed]

Question

VBA: search for a value then Moving cusor [Closed]

Report

Jat - Jul 21, 2009 at 06:15 AM
Trowa - Jul 23, 2009 at 06:56 AM

Hello,

i need the code for the following please:

Find a specific value in a spreadsheet
Then move the cursor 5 cells/ spaces up

thanks

Jat

VBA: search for a value then Moving cusor
Excel vba search - How-To - Excel
Excel vba search array for match - How-To - Excel
VBA search column for matching string ✓ - Forum - Excel
Vba userform to search and edit data ✓ - Forum - Excel
Search function in VBA/Excel - How-To - Excel

1 reply

Ask a question

Trowa · Answer 1 · 2009-07-23T06:56:34-0400

Here you go Jat,

Sub NAMEOFMACRO()
Cells.Find(What:="YOURSPECIFICVALUE", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
ActiveCell.Offset(-5, 0).Select
End Sub

Best regards,
Trowa

VBA: search for a value then Moving cusor [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!