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

VBA: search for a value then Moving cusor
Vba case like - Guide
Number to words in excel without vba - Guide
Enable vba in excel - Guide
Vba check if value is in array - Guide
Vba calculator code - Guide

1 response

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

Similar discussions

Create folder in desktop with vba, if exist, ignore

VBA find column by name and sort

Comparing Two Excel Sheets and copying like data to third sheet

Similar discussions

Subscribe To Our Newsletter!