Re: $$Excel-Macros$$ Name Range Change through VBA

2014-03-08 Thread ashish koul
Sub chnage_address() Dim rng As Name, rngaddress As String, k As Long k = 30 For Each rng In ThisWorkbook.Names rngaddress = rng.RefersTo rng.RefersTo = Left(rngaddress, InStrRev(rngaddress, "$")) & k Next End Sub On Fri, Mar 7, 2014 at 12:54 PM, Prafull Jadhav wro

Re: $$Excel-Macros$$ Name Range Change through VBA

2014-03-07 Thread priti verma
try this, Sub namerange() Dim rngRange As Range Dim rngCell As Range Set rngRange = Application.InputBox("select range", , , , , , , 8) For Each rngCell In rngRange.Columns(1).Cells ThisWorkbook.Names.Add rngCell, rngCell.Offset(, 1).Formula Next End Sub On Thu, Mar 6, 2014 at 11:24 PM, Pr

$$Excel-Macros$$ Name Range Change through VBA

2014-03-06 Thread Prafull Jadhav
Dear All, Good Afternoon, I have one query . Can we change the Name Range with help of VBA for example below are the name range in my excel file & I have to extend the range by 2...i.e 85000. if it is possible ..Kindly provide the code for the same. Abhijit_ =Details!$AJ$1:$AJ$65000 Bucke

RE: $$Excel-Macros$$ Name a table

2012-06-11 Thread Rajan_Verma
: $$Excel-Macros$$ Name a table Dear all, Please try to find out any solution! Sandeep Chhajer Sent on my BlackBerryR from Vodafone -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 11 Jun 2012 10:59:23 To: Reply-To: excel-macros

Re: Fw: $$Excel-Macros$$ Name a table

2012-06-11 Thread ashish koul
s@googlegroups.com > Date: Mon, 11 Jun 2012 10:59:23 > To: > Reply-To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Name a table > > Dear Mentors, > > I want to create tables in Excel 2010 as following > > My data in excel is > Column 1.

Fw: $$Excel-Macros$$ Name a table

2012-06-11 Thread chhajersandeep
-Macros$$ Name a table Dear Mentors, I want to create tables in Excel 2010 as following My data in excel is Column 1.Column 2 Reserve_surplus Other_exp Capital Reserve. Salary Securities Premium. Printing Revaluation reserve. Insurance General

$$Excel-Macros$$ Name a table

2012-06-11 Thread chhajersandeep
Dear Mentors, I want to create tables in Excel 2010 as following My data in excel is Column 1.Column 2 Reserve_surplus Other_exp Capital Reserve. Salary Securities Premium. Printing Revaluation reserve. Insurance General Reserve.

Re: $$Excel-Macros$$ Name Manager

2012-05-12 Thread dguillett1
Homework? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Saturday, May 12, 2012 12:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Name Manager Hi, I want to know about Name Manager.. .. what is the use of Name manager

Re: $$Excel-Macros$$ Name Manager

2012-05-12 Thread ╰» ℓαℓιт мσαнη
Regards > > Rajan verma > > +91 7838100659 [IM-Gtalk] > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of vijayajith VA > Sent: 12 May 2012 10:35 > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Name Ma

RE: $$Excel-Macros$$ Name Manager

2012-05-12 Thread Rajan_Verma
: $$Excel-Macros$$ Name Manager` Hi, I want to know about Name Manager.. .. what is the use of Name manager.how to use it.. Can any one explain me with examples...or any nice links ..Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

$$Excel-Macros$$ Name Manager

2012-05-11 Thread vijayajith VA
Hi, I want to know about Name Manager.. .. what is the use of Name manager.how to use it.. Can any one explain me with examples...or any nice links ..Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please H

$$Excel-Macros$$ Name AND CODE

2011-03-11 Thread Mishra, Kailash (GE Capital, Non-GE)
Hi Experts Please find the attached file in the attaché file I have some Code and Name which are in one column. I want bifurcate this with two column one is Name & one is Code. Please confirm, if any specify formula for this . Regards Kailash --

Re: $$Excel-Macros$$ name

2011-01-24 Thread Sanjoy Nath
Select the Column and From Formula tab there is the name manager. [ ] kind of things are not allowed in naming On Mon, Jan 24, 2011 at 1:46 PM, airen wrote: > How do i name a column in Excel 2003. For eg in excel 2007, i have a > table named table1 having column Item...now i could name use > tab

$$Excel-Macros$$ name

2011-01-24 Thread airen
How do i name a column in Excel 2003. For eg in excel 2007, i have a table named table1 having column Item...now i could name use table1[Item] as name...but unfortunately this convention is not applicable in Excel 2003...So is there any solution?? -- --

Re: $$Excel-Macros$$ Name of last Month

2010-01-13 Thread Sachin Shukla
Dear Mahesh, Please find attached soluation Thanks Sachin Shukla On 1/13/10, Mahesh wrote: > > Dear Friends, > > I need your help, > > I have to prepare the monthly Reports in which the heading contains the > name of last month. > > For Example:- > > 1. If I am preparing report in Ja

Re: $$Excel-Macros$$ Name of last Month

2010-01-13 Thread ankur
hi mahesh this will help u ="For the month of "&" "&TEXT(EOMONTH(TODAY(),-1),"mmm,") On 1/13/10, ankur wrote: > hi mahesh > > Sorry for geting your question wrongly, my answer will get only present > month. > > On 1/13/10, ankur wrote: >> hi mahesh >> write this formula in your coloum head

Re: $$Excel-Macros$$ Name of last Month

2010-01-13 Thread ankur
hi mahesh Sorry for geting your question wrongly, my answer will get only present month. On 1/13/10, ankur wrote: > hi mahesh > write this formula in your coloum heading > > ="For the month of "&" "&TEXT(TODAY(),"mmm,") > > for any more clarification , u can mail me > > On 1/13/10, Mahesh w

Re: $$Excel-Macros$$ Name of last Month

2010-01-12 Thread ankur
hi mahesh write this formula in your coloum heading ="For the month of "&" "&TEXT(TODAY(),"mmm,") for any more clarification , u can mail me On 1/13/10, Mahesh wrote: > Dear Friends, > > I need your help, > > I have to prepare the monthly Reports in which the heading contains the name > of

Re: $$Excel-Macros$$ Name of last Month

2010-01-12 Thread ayush jain
Hi Mahesh, You can use the formula =DATE(YEAR(NOW()),MONTH(NOW())-1,DAY(NOW())) & change the format of the cell by following below steps. GO to format cells--->Custom-->"For the month of" -yy--->Click Ok.. Attached is the solution for your reference. Let us know if it helps you. Thanks and

$$Excel-Macros$$ Name of last Month

2010-01-12 Thread Mahesh
Dear Friends, I need your help, I have to prepare the monthly Reports in which the heading contains the name of last month. For Example:- 1. If I am preparing report in January then heading will be “For the month of December, 2009” 2. If I am preparing report in February then head

$$Excel-Macros$$ Name Matching In Excel

2009-09-21 Thread Sonal Gadgil
Hi... I am new in this group. I am facing one proble while working in the excel. I am having two excel files where i have to map the customer based on customer name by matching customer name manually. Now, in case there is any macro available which help me to search & map names this will be gre