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
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
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
: $$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
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.
-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
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.
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
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
: $$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
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
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
--
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
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??
--
--
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
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
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
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
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
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
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
21 matches
Mail list logo