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

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!