Re: $$Excel-Macros$$ Regarding copy of BORDER LINE

There's no built in feature for this apart from VBA approach. Another try would to be Creating Custom Styles or use built in table formats. On Wed, May 1, 2013 at 6:21 PM, L.K. Modi wrote: > Dear Brothers > > I am facing problem in the matter of Format borders as i have excel sheet > containin

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Dear Pankaj, Please see attached. Hope this is what you are looking for, if not, let me know. However, it is advisable to have a sample file for your query ready with you, particularly for VBA and User Form related problems. You would appreciate that in this forum people voluntarily take time and

Re: $$Excel-Macros$$ Future Growth Calculation

Dear all experts, Any update on my query. Regards, Chaya Regards, Chaya On Tue, Apr 30, 2013 at 4:15 PM, Chaya wrote: > Dear Hilary Sir, > > I am very new to excel. Please elabrote with my previous attached > excel. And please tell me what is CAGR > * > * > > Regards, > Chaya >

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

in VBA Form. Regards, Pankaj On Wed, May 1, 2013 at 4:30 PM, ravinder negi wrote: > please give more detail with example file so we can understand properly > whether you want this in VBA for or normally in excel sheet. > > > --- On *Wed, 5/1/13, pankaj gmail account * wrote: > > > From: pankaj g

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Dear Priti, I want user restriction in Excel GUI form. Regards, Pankaj On Wed, May 1, 2013 at 2:59 PM, priti verma wrote: > Hi Pankaj, > I thing you want data validation thats restrict to enter the name in to > the column of phone number.and to restrict the phone number to enter into > columns

Re: $$Excel-Macros$$ Advanced Pivot Table Question

xlstime: I would like to respectfully thank you for correctly answering this question. - nyc.actuary On Tue, Apr 30, 2013 at 10:46 PM, xlstime wrote: > Hi Nyc, > > 1st filed it is not possible in pivot table (need to create another column > and put condition then add in pivot table ) > 2nd f

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Hi Ashish, Thanks for the code.I am using this code for multiple addresses in excel and I keep getting an error message of Over query limit. Can you please let me know how I can avoid this. I have a spreadsheet that has over 100 origins and I need to find the closest origin to my destination.

$$Excel-Macros$$ Regarding copy of BORDER LINE

Dear Brothers I am facing problem in the matter of Format borders as i have excel sheet containing many rows and columns and i have to give border each column manually so its takes a lot of time. is there any way by which we can copy only border format in other columns as i have tried paste specia

$$Excel-Macros$$ Re: Functions returning an integer

ok thanks On Monday, April 29, 2013 11:00:13 AM UTC+2, colmkav wrote: > Hi, I am trying to execute this function to return the column number of a > heading. However although the value is correctly 3 when it reaches the end > of the function it becomes 0 when I set it to iFund2Col after leaving

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

please give more detail with example file so we can understand properly whether you want this in VBA for or normally in excel sheet. --- On Wed, 5/1/13, pankaj gmail account wrote: From: pankaj gmail account Subject: $$Excel-Macros$$ Fwd: Mandatory Cell Entry To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ copy the active worksheet and paste it to another workbook in a given path.

here is the code... Sub filecopy()sheetname = ActiveWorkbook.ActiveSheet.Range("a16")Path = ActiveWorkbook.ActiveSheet.Range("a15")     Sheets("Sheet1").Select    Sheets("Sheet1").Copy    ActiveWorkbook.SaveAs Path & "\" & "book2", FileFormat:=56    ActiveSheet.Name = sheetname    ActiveWorkbook

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Hi Pankaj, If you have a sample file and form ready, I can help with VBA. Please share. Regards, On Wed, May 1, 2013 at 2:30 PM, pankaj gmail account wrote: > > > -- Forwarded message -- > From: pankaj gmail account > Date: Sat, Jan 5, 2013 at 9:10 AM > Subject: Mandatory Cell

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Hi Pankaj, I thing you want data validation thats restrict to enter the name in to the column of phone number.and to restrict the phone number to enter into columns of name. am i right or not. Regards, Priti verma On Wed, May 1, 2013 at 2:30 PM, pankaj gmail account wrote: > > > -- Forw

$$Excel-Macros$$ Fwd: Mandatory Cell Entry

-- Forwarded message -- From: pankaj gmail account Date: Sat, Jan 5, 2013 at 9:10 AM Subject: Mandatory Cell Entry To: excel-macros@googlegroups.com Dear Gurus I want to make a excel data entry form in which i want some cells to be mandatory and some can be left out. But with se

$$Excel-Macros$$ Curve Graph Help

Dear Gurus how can i create Curve bell Graph with this data. Month - Failure in Month Year - Failure in Year Month Yr -2007 2008 2009 2010 2011 2012 2013 1 6 4 1 2 1 1 2 12 7 3 5 9 43 11 7 3 8 4 144 18 12 11 7 12 65 12 12 4 3 8 7 1 6 15 11 7 9 7 13 2 7 13 9 6 10 5 5 1 8

$$Excel-Macros$$ Tricks to hide/restrict viewing excel data in sheets

Dear Gurus, Please suggest ideas to hide/restrict data viewing in excel data sheets version 2007/2010. using VBA also. blocking right click, copy/paste, printing, saving, copy file, not able to view formula's etc. -- Thanks Pankaj Kumar 9910075248 -- Thanks Pankaj Kumar 9910075248 -- Ar