$$Excel-Macros$$ Re: VBA code to search a column for a string

2009-05-10 Thread Senthil Kumar Palani
Hai all, im very beginner level excel can anyone tel me How to use VBA with excel? Thanks & Regards, Kumar On Tue, May 5, 2009 at 5:33 PM, Doug wrote: > > Seems easy enough but I'm new at VBA so I can't seem to get it right. > > I have a sub that adds a row to my worksheet but this particular r

$$Excel-Macros$$ Re: VBA code to search a column for a string

2009-05-06 Thread Dave Bonallack
Good. Glad to help. > Date: Wed, 6 May 2009 05:22:51 -0700 > Subject: $$Excel-Macros$$ Re: VBA code to search a column for a string > From: dsrmccl...@gmail.com > To: excel-macros@googlegroups.com > > > Dave, > Thanks. With a little bit of tweaking that's just wha

$$Excel-Macros$$ Re: VBA code to search a column for a string

2009-05-06 Thread Doug
Dave, Thanks. With a little bit of tweaking that's just what I needed! Doug On May 5, 10:12 pm, Dave Bonallack wrote: > Hi, try this code somewhere in your sub: > > With Range(A1:A1000) > >     D = "Seed-BOD" >     Set C = .Find(D, LookIn:=xlFormulas) >     If Not C Is Nothing Then MsgBox "Samp

$$Excel-Macros$$ Re: VBA code to search a column for a string

2009-05-05 Thread Dave Bonallack
Hi, try this code somewhere in your sub: With Range(A1:A1000) D = "Seed-BOD" Set C = .Find(D, LookIn:=xlFormulas) If Not C Is Nothing Then MsgBox "Sample is already here." End With If you are already using C and/or D as variables, you'll need to change them. You may need to cha