Re: $$Excel-Macros$$ Help urgently required for objective

2010-03-27 Thread C.G.Kumar
Thanks Ajay. On Fri, Mar 26, 2010 at 5:45 PM, Ajay Varshney wrote: > Here are the codes for your first five objectives: > > 'Objective 1 > Sub Delete_rows_above_headings() > Rows("1:12").Select > Range("A1").Activate > Selection.Delete Shift:=xlUp > Range("A1").Select > End Sub >

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

2010-03-27 Thread Santosh Vishwakarma
Use the DLookup function to get the value of a particular field from a specified set of records. pls attach ur file if u r not able to From: Vikas Chouhan To: excel-macros@googlegroups.com Sent: Sat, 27 March, 2010 7:00:34 PM Subject: Re: $$Excel-Macros$$ "

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

2010-03-27 Thread Vikas Chouhan
*how to put formula,lookup in access* On Sat, Mar 27, 2010 at 4:29 PM, Deepak Rai wrote: > Hi Vikash, > > Want help you want on Access ? > > Regards, > > Deepak > > On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan wrote: > >> hi >> >> Dear all please help in access urgent plsss >> >> >> >> >>

$$Excel-Macros$$ Capturing part of string in the cell

2010-03-27 Thread Ramesh Katta
Hi Gurus, In excel sheet Column A contains the strings like the follwing. ex: 1. "Fwd: A9504X1-1435 effexor - mexico - category" 2. "Re: effexor - taiwan - category B5343x4-1346" 3. "Fwd: Protocol number 2353x1- 4353 taiwan" 4. "Re : A3536x6 - 5325 protocol number" 5. "Pro

$$Excel-Macros$$ Re: Create an Array Function..

2010-03-27 Thread Born to Win
Dear Vikas, Please Find Attached Sheet. Thanks & Regards, Chandrabhan Singh 9911255330 On Sat, Mar 27, 2010 at 3:52 PM, Vikas Chouhan wrote: > Sir, > Urgent Help Pls > > > > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask...@gmail.com,vikask...@redif

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

2010-03-27 Thread Deepak Rai
Hi Vikash, Want help you want on Access ? Regards, Deepak On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan wrote: > hi > > Dear all please help in access urgent plsss > > > > > > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask...@gmail.com,vikask..

$$Excel-Macros$$ Re: E Book "Excel 2007 Macros Made Easy by Gail Parry"

2010-03-27 Thread Harpreet Singh Gujral
Hi Hemant, Thanks for providing the source But i am unable to download the file, the download stops in between. Tried many times, would you be able to make available the file through some other source. Thanks Harry On Mar 26, 5:21 pm, Hemant K wrote: > Hi All, > > Here is the link for the fol

Re: $$Excel-Macros$$ Outlook and excel integration

2010-03-27 Thread ~ Z A H E E R ~
Thank you very much Mahesh. This is what i want. On Wed, Mar 24, 2010 at 7:58 PM, Mahesh parab wrote: > Dear Zaheer > > I herewith attach sample sheet as per your requirement, u can read further > on below mention link, write back if u still find > any difficulty http://www.rondebruin.nl/mail/ch

Re: $$Excel-Macros$$ Unique No

2010-03-27 Thread Abhishek Jain
Vivek, The steps given earlier are not exactly good. Try it this way - 1. Select the cell A1 2. Data --> Data Validation --> Settings 3. From the Allow dropdown list, select Custom. 4. Enter the following COUNTIF formula in the Formula box: =COUNTIF(A:A,A1)=1 5. Select the Error Alert tab. 6. In

Re: $$Excel-Macros$$ Unique No

2010-03-27 Thread Abhishek Jain
Vivek, Have you tried Data Validation ? See this: 1. Select the range to validate (cells A2:A10) 2. Data --> Data Validation --> Settings 3. From the Allow dropdown list, select Custom. 4. Enter the following COUNTIF formula in the Formula box: =COUNTIF(A:A,A1)=1 5. Select the Error Alert tab. 6

Re: $$Excel-Macros$$ Code or Formula Required

2010-03-27 Thread Puttaswamy
Hi Group, Could you please help on this. Thanks Puttu On Fri, Mar 26, 2010 at 3:44 PM, Puttaswamy wrote: > Attached is the spread sheet. Please do the needful. > > > On Fri, Mar 26, 2010 at 12:49 PM, Puttu wrote: > >> Hi Group, >> >> I have sheet where I get a details of the company in differ

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

2010-03-27 Thread Vikas Chouhan
hi Dear all please help in access urgent plsss -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´

RE: $$Excel-Macros$$ Unique No

2010-03-27 Thread Sathish Jalendran
Hi, Check the attached file and let me know if its ok for you Regards Sathish Jalendran Picture (Device Independent Bitmap) From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of C Vivek Sent: 26 March 2010 PM 04:52 To: excel-macros@googlegroups.com S