Previous Topic Next Topic

VBA: search for a value then Moving cusor

Closed
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

1 reply

Answer 1 / 1
Trowa
Jul 23, 2009 at 06:56 AM
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
0