Previous Topic Next Topic

VBA: search for a value then Moving cusor

[Closed]
Report
-
 Trowa -
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

1 reply

Answer 1 / 1

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
Ask a question