VBA: search for a value then Moving cusorClosed

Question

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

Trowa · Answer

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

1 reply

Similar discussions

Subscribe To Our Newsletter!