VB Code Help

[shaikhiy]

Hi,

I need to do an if statement within the VB code, to say that if you cannot find the "#" don't do anything,otherwise, do what is in the code below...can you help???

The code is listed below:

Range("R10").Activate
Range("Draw2").Find(what:="#", after:=ActiveCell, LookIn:=xlValues, lookat:=xlWhole, searchorder:=xlByRows, searchdirection:=xlNext, MatchCase:=False).Activate
ActiveCell.Offset(0, -1).Select
Application.CutCopyMode = False
Selection.Copy
Application.Goto reference:="DD2_Home_Date"
ActiveCell.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

End Sub

Cheers
Imran

 

[Andrew Poulsom]

Is there a relationship between "Draw2" and "DD2_Home_Date"? That is, will the number always be the same and do you always want to perform the same actions?