Search results

yes shreyash, this is exactly what i needed. i remember trying this code when i first started this project, but i didn't know enough about excel vba to get it to do what i wanted. this is what i'm using as of now and it looks like its doing just what i need. i'll test it more when i get back...

thanks for all your help on this. i just got back from vacation and starting to work on it again. the input box you suggested works great and does away with the other stuff i didn't need. can we tell the find method where to look using the LookIn, LookAt, or After parameters? and about the...

haha, wow thats great. I had just finished writing this nasty chunk of code that worked (but a tad over complicated :p ). Cells.Find(What:=strSic, After:=[A1], LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ True...

thanks for the reply, here is the macro i recorded: Cells.Find(What:="516916", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate Rows("179:179").Select...

hi all, I'm working on a VBA script for Excel that i need some help on. i'm familiar with programming vb applications, but not in excel. I have an excel file with about 24,000 rows and 50 columns. I need to search for a unique value in one of the columns, then copy that row to the next sheet...