Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help With CODE!!!
I run a standard find macro but if the file i try to import does not
have the particular find command (in the sample case below it's "PUP") then my code breaks and I have an error Is there anything i can input that will allow me to say that if the word "PUP" is not there, then dont do anything, but if it's there, then run my code below. Windows("2.txt").Activate Cells.Find(What:="PUP", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate ActiveCell.Offset(rowOffset:=0, columnOffset:=6).Activate Selection.Copy Windows("DAILY OPERATIONS_2004.xls").Activate Range("K10").Select ActiveSheet.Paste --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |