A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Named Cell issue - dangers of cut and paste

Thread Tools Display Modes
Old June 24th 06, 05:01 PM posted to microsoft.public.excel.misc
external usenet poster
Posts: n/a
Default Named Cell issue - dangers of cut and paste


-I also have a cell that lists the Total Income, which i name GSI
-I also have collumn listing Expenses and at the bottom, sums the total
expenses, which iname TOTAL_EXPENSE
-Lastly, below that, i calculate the Net Income by subracting the
expenses from the income, which i call NET_INCOME
-All are in one column.

In both formulas and code elsewhere , i refer to GSI and TOTAL_EXPENSE
cells by name. For instance the NET_INCOME cell is GSI - TOTAL_EXPENSE.

My issue here is, when i now cut and past that column to create a new
column, the forumla in the new column still refers to the named column
in the original column. So in this example, for column two, the net
income cell refers to the column 1 cell, since it is referencing

My question is, how do i handle this and still be able to use named
columns, which are so much more clearer if someone were looking at my
formula or code. Is there a way to create ARRAYs of named cells in
this case? so that the first column would be referred to as
TOTAL_EXPENSE[0] and the second column would be referred to as

i hope i explained myself clear. Please advise if you are able to.

thank you


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.