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

okay thanks On Mar 26, 12:56 pm, amitabhbo...@hotmail.com wrote: > Hi > I have this book but will have to find the cd. > > I will try and send it this weekend > > Thanks > > Amitabh > -- > > > > -Original Message- > From: anandydr > Date: Thu, 25 Mar 2010 21:19:13 > To: MS

RE: $$Excel-Macros$$ how can protect the excel sheet in VBA Passward.

Hi, The code for protecting a worsheet is: Sheets("YourSheetName").Protect Password = "YourPassword" Regards - Dave. Date: Fri, 26 Mar 2010 17:40:58 +0530 Subject: $$Excel-Macros$$ how can protect the excel sheet in VBA Passward. From: jaihumtu...@gmail.com To: excel-macros@googlegrou

$$Excel-Macros$$ How to copy non-contiguous columns

I found this code online that will copy information to new worksheets with a new worksheet for each unique value in column A. It works perfectly for what it is designed to do however I would like to modify it to only copy the following columns: A, C, D, L, M, T, V, W, AA, AB. Can this be done? C

$$Excel-Macros$$ Re: Question about QueryTable

Yes, there is a way, and it's name is VBS scripting: it allows you to grab data from the browser and insert it into your excel sheet... Greetings Paul Willekens -- -- Some important links for excel users: 1. Follow

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

Hi All, Here is the link for the following great book for beginners in field of Macros http://cid-8debefc810167f39.skydrive.live.com/self.aspx/.Public/Excel%202007%20Macros%20Made%20Easy.pdf?lc=16393 Regards Hemant Koranne -- --

$$Excel-Macros$$ how can protect the excel sheet in VBA Passward.

DEAR ALL,EXPERTS Can you Tell me that how can protect the excel sheet in VBA Passward. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://

$$Excel-Macros$$ Unique No

Hello All... A Column in a sheet must have only unique nos... when we enter the same no again it have to give t message NO ALREADY EXIST. pls help to to find it out. Thanking you, Vivek Chandran, Ooty - TN -- --

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

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 'Objective 2 Sub Delete_Blank_Columns() Range("A1").Select i = 1 a = Workshe

$$Excel-Macros$$ Re: Excel Ppt Interface... Please help..

On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar wrote: > Dear All, > > I am having presentation (PPT) of 3 slide. Each slide contains one excel > sheet. > The last slide will have sum of values of Sheet 1 to 2 (i.e. Slide 1 &2 ). > > The original file is having some inportant data hence I am at

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

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 different format, > which the output need in one excel row. > > Example > > Jamrut Trading Co. Send Mail > > Busin

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

hi friends, i do have certain vba books will send you shortly. Regards, Raj On Fri, Mar 26, 2010 at 2:37 PM, rajasekhar praharaju < rajasekhar.prahar...@gmail.com> wrote: > > > On Fri, Mar 26, 2010 at 1:26 PM, wrote: > >> Hi >> I have this book but will have to find the cd. >> >> I will try a

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

On Fri, Mar 26, 2010 at 1:26 PM, wrote: > Hi > I have this book but will have to find the cd. > > I will try and send it this weekend > > Thanks > > Amitabh > -- > > -Original Message- > From: anandydr > Date: Thu, 25 Mar 2010 21:19:13 > To: MS EXCEL AND VBA MACROS > Subj

Re: $$Excel-Macros$$ Group Data

Hi, A sample file of your query would help to understand better, please attach if possible. However, you may try subtotal. Data>Subtotal. Cheers! AJ On Thu, Mar 25, 2010 at 11:21 PM, Dave wrote: > Hi, > I have a spreadsheet with the following columns: > > Item # 1 to 1000 > Account Number al

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

Hi I have this book but will have to find the cd. I will try and send it this weekend Thanks Amitabh -- -Original Message- From: anandydr Date: Thu, 25 Mar 2010 21:19:13 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" b

$$Excel-Macros$$ *******TIP*******SOME NET CONCEPT**********

''**Net Concept* ' '''Send Current Workbook Mail'''

$$Excel-Macros$$ Code or Formula Required

Hi Group, I have sheet where I get a details of the company in different format, which the output need in one excel row. Example Jamrut Trading Co. Send Mail     BusinessEstablished Sales Manufacturer   1977  250,000 to 1 million USD    Deals In Export Of :

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

Hi Dear all, *Please help in access* it a urgent On Fri, Mar 19, 2010 at 10:45 AM, C.G.Kumar wrote: > Dear Masters, > > > File attached for your kind consideration and support.Please let me know > whether the objective from Sl No.6 onwards is possible to achieve or not. > > > Regards, > > C.G.Ku

Re: $$Excel-Macros$$ Need how can vb in ms excel and ebook

Hello Dear, Try to Read on following link.. http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm This is good link for Beginner. Hope it will Help Happy to Help :) Shyam On Thu, Mar 25, 2010 at 10:32 PM, prabhakar thakur wrote: > Dear Group, >                       I need