Cell Value as Named Range Reference
Little bit of a quirky question...
Trying to use a cell value as a reference in a formula, where that
cell value is the name of a named range.
So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.
I want to get the correlation vale for A1:A3 and B1:B3
So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
formula: =correl(D1,D2). But I get an error. Have also tried using
Indirect to no avail.
Any help would be hugely appreciated. Thank you.
http://www.wimgielis.be = Excel/VBA, soccer and music
"ste...loss of connection to e2k3 server after 4 or 5 days uptime
I'm having a strange issue with Outlook & our Exchange server. This is our
topology (all one domain):
2 Windows 2003 SP1 Enterprise Domain Controllers
1 Windows 2003 SP1 Enterprise Exchange 2003 SP1 w/KB894549 Enterprise Back-end
1 Windows 2000 SP4 Advanced Server Exchange 2003 SP1 w/KB894549 Enterprise
site-to-site IPSec VPN w/CheckPoint R55 (Datacenter) & Cisco 1721 (Corporate
1 Windows 2000 SP4 Advanced Server Domain Controller
50 Windows XP SP1/SP2 PCs w/Outlook 2003 SP1
What happens is that after 4 or 5 days ...Exchange 5.5 / Exchange 2003
We migrated our NT4 network into a Win2k (SP4) network
using Active Directory. Our 5.5 exchange server is in
this forest/domain and running on a Windows 2000 member
server. We have 1 forest and 1 domain. We want to replace
the existing exchange server with new hardware and it
will have Exchange 2003 on an Windows Server 2003. The
questions: 1. I presume that the new server has to have
the same name so that we don't have to change our
clients' settings. 2. What is the best method to migrate
the mail to the new server? 3. Any issues with running
Exchange 2003 on a 2000 A/D? (I ...00/01/1900 In the date cell when linked cell is empty?
Hi I have 52 worksheets all linked up to a total sheet that is working very
well thanks to RD
All I need to do now is sort out the date this is copied from sheet1 onto
the totals page and works fine when the date is put into sheet1.
However if the cell is blank on sheet2 the date is put into the totals sheet
as 00/01/1900 when the date is put in sheet2 all is well with the right date
entered into the totals sheet.
So how do I get the totals date to stay blank until the weekly sheets have a
date put into the sheet please.
the format I am using is below
many thanks for all the help I ...Need to reference a block of cells from another sheet.
apologies if this is probably a mundane question, but I didn't know what
'search terms' to put in google to return any results..
I've got a Spreadsheet with 12 tabs (sheets), I need part of tab 12 (sheet)
to appear on tabs 1-11 (sheets), so that if I change data in tab 12 (sheet),
tabs 1-11 (sheets) are changed too.. the cells themselves will never move
location, just the data within them..
Is it possible?
On your sheet1 select the cell that should receive the data from Sheet12;
Hold down the Shift key and Click on Sheet11 << this shoul...Meetings Exchange 5.5
I always receives a "Not read" message form a person which I didn't invite
for an appointment, everytime I invite another and always the same
We're from IT, but haven't had this kind of problem before.
Please give any advice where to search .... Hope our Exchange 5.5 (W2000
clients) isn't "tripping"?
Does the user you are sending the meeting request to have a delegate set?,
is is calendar set to send meeting requests to both the user and the
"Steve" <Steve@steve.com> wrote in message
news:3...Problem with Outlook 2003 & Exchange Server 5.5
It seems Outlook 2003 causes my Exchange Server 5.5 Sp4
to hang. I'm running Windows 2000 on the Exchange server
and WinXP on the client running Outlook 2003
There is a notice on microsofts website about installing a patch for
Exchange. Has to do with rules processing.
"Scott" <email@example.com> wrote in message
> It seems Outlook 2003 causes my Exchange Server 5.5 Sp4
> to hang. I'm running Windows 2000 on the Exchange server
> and WinXP on the client running Outlook 2003
...refering to a name range area as a reference value multiple times on a worksheet at different locations
i was wondering if i had posted this in the right section as it could
apply to both
please could you take a look at the following post
Is there some reason you can't post your question here instead of asking us
to look elsewhere?
Microsoft MVP Excel
"Blinds Nottingham" <firstname.lastname@example.org> wrote in
news:email@example.com...Help: Disclaimer on Exchange5.5
I have implement imsext.dll on Exchange 5.5 Server. and it works for
inboundappend and inboundprepend, however, it doesn't work for
outboundappend and outboundprepend.
I appreciate for any comments or advices.
"Little Cat" wrote:
> I have implement imsext.dll on Exchange 5.5 Server. and it works for
> inboundappend and inboundprepend, however, it doesn't work for
> outboundappend and outboundprepend.
> I appreciate for any comments or advices.
>LC, can i ask where you got the imsext.dll file? I'm try to outbound pre-prend on Exch...What is IVA# in Distribution Reference and Reference?
We did an inventory adjustment and now we get a unknown amount in Debit under
the Inventory account and Credit for COGS account in the Transaction Entry
Zoom. We're trying to figure out where that amount came from but we couldn't
zoom more than what it's currently shown. In both fields, Reference and
Distribution Reference, it's shown IVA#######... that is unknown to or setup
by us in anywhere, i.e. Audit Trail, Source Document.
Does this amount affect the dollar in the accounts mentioned?
And can anyone please help to where we could drill down the IVA details?...macro button refers to prev. workbook?
When I create a macro in Excel, and assign a button to it, it works
fine the first time, but when I re-open the workbook for a second
time, and try to run the macro again, the macro seems to refer to the
previous workbook...For some reason, the macro saves the name of the
Dim name As String
Dim adress As String
name = ActiveSheet.Range("B6").Value
adress = ActiveSheet.Range("B4").Value
ActiveWorkbook.SaveAs Filename:="C:\WINDOWS\Desktop\Temp...Data Validation in cell
I have a sales order form with the equipment on the second sheet as "PartNo"
"Description" "Cost" selected each column of data then clicked in the
cellname box and called them "PartNo" "Description" "Cost"
On the sales order form I have the columns "Qty" PartNo" "Description"
"Serial No" "QtyDes" "Price" Total"
I have set up data validation for the description as a list with
=Description what I want it to do is display the part no in the part number
Column and the cost in...How do Macro to EDIT cells?
Am using MS Excel XP (2002). All I want to do is a short macro to, in
effect, press F2 (to EDIT the cell), then let's say delete the first
character of the cell and change it to let's say X, like this...
I just want to put the cursor on a given cell, click CNTL-A to run the
macro, and have it change one cell at a time. There are reasons why I can't
use the search and replace. Problem is... if I record the macro (turn it
on, press the key sequences, F2, Home, Delete, X, GoDownOneCell, ...Column and Row reference
How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top and right hand side references
Uncheck "row and column headers".
Good idea to spend a few minutes browsing through the various Tools>Options
tabs to see what else is available to toggle on/off.
Gord Dibben Excel MVP
On Mon, 19 Jul 2004 15:53:02 -0700, "Dave" <Dave@discussions.microsoft.com>
>How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top an...customer loyalty
does anyone have a recomendation for how to handle this type of loyalty
program? Simply we were thinking we could generate a report that shows all
customers with sales over $300 and then manually assign them vouchers but
this could be time consumming. Also - how do you give a customer a gift
voucher - you would have to sell it to them to track it voucher # at
redemption but how do you sell it without selling it?
Any thoughts? all the loyalty programs I have found are based on points.
My customer wants it simply based on net sales.
There is a customer loyalty addon that supports thi...Exchange 5.5 Maintenance not happening?
I run an Exchange 5.5 server (SP4). I'm looking for the entry in the event
log that tells me how much whitespace was in the IS. But there are no
events for the information store in the application log. I check the
Exchange Administrator and it says that maintnenance is to happen between 1
and 6AM. Are there other settings that affect IS maintenance?
You want to make sure the time allowed for backup doesn't overlap with the
time of the maintenance. The events you are looking for in the application
log are events 1221.
Michael Barta [MSFT]
Microsoft Exchange Support
I had a problem today with a missing reference - Microsoft Forms 2 on a
colleague's machine at work (Office 2003; VBA 6.5; XP).
I've read Chip Pearson's "Missing References in VBA" which is a geat
explanation about how to fix problems like this.
Oddly the library didn't seem to be flagged as "missing" and was in fact
present in the system32 directory but didn't show up in the list of
Now to the questions:
I'm not clear on whether if I write code in a project that references a
library which is not part of the &qu...Cells do not Retain Formatting After Pasting.
I have very a simple spreadsheet with lists of names, addresses, telephone
I have preset the formatting for the telephone number column, to "text" and
centre alignment. When I paste in a telephone number from Outlook Express
such as 01282830756 it changes the format and I lose the first 0 and the
alignment is from the right. After pasting I have to reformat to text and
This is a real pain and time consuming. Is there any way to cure this and
force Excel to retain the formatting I have set?
Paste the values only.
Edit, Paste Special, ...Which function to use? Trying to ref a cell based on another.
I'm starting to get confused by the vocabulary in Excel. I'm not necessarily
looking for someone to just give me a solution to my problem. I'd just like
some advice on which functions I should be reading up on. I'm still a newbie
to the formulas. If Excel would let me, the closest I could express what I'm
trying to do is something like this. =IF(A3=sheet2!A$:A$, sheet2!H$:H$
Of course this doesn't work b/c I don't know what I'm doing. I know this is
simple to some of you gurus out there, everybody starts somewhere.
To explain what I'm trying to...Remove last 5.5 server
I am trying to remove our last 5.5 server and get the following error message:
"The server could not be deleted because some public folders were not
successfully moved to a different server. You do not have the permissions
required to complete the operation on the information store. Microsoft ID:
I have gone through the MS document on this and believe I have the necessary
permissions set. Any idea's on where I should start looking?
Have you moved the System folders as well as the regular public folders?
Exchange User Education
****** Discla...Make pasted value in last blank cell the focus
Whichever cell has the focus when the following code is run that is the row
that will be copied into any other sheet in the range.
What I need is the row containing the last blank cell in "B" in which the
value of "B9" take the focus, although the exact row to be copied wont be
determined until the sheet has first been sorted.
Here is the code in it entirety:
Option Compare Text
Private Sub AddRow_Click()
Dim rng As Range
Dim lr As Long
Dim sh As Worksheet
Dim ws As Worksheet
Dim i As Integer
Dim FD As String 'find string
...Exchange 5.5 : How to move users to new domain?
I have 15 users on an Exchange 5.5 / NT 4.0 domain.
The NT 4.0 PC is the PDC of the domain (no BDC).
I need to move those users into an existing Server
2003 Active Directory domain and do so without
losing their Exchange 5.5 mailboxes.
What would be the best way to do this?
The main question is what you want to do with Site Service account,
which is cornerstone to Exchange operations?
Rick Troha wrote:
> I have 15 users on an Exchange 5.5 / NT 4.0 domain.
> The NT 4.0 PC is the PDC of the domain (no BDC).
> I need to move those users into an existing Server
> 2003 Activ...Unwanted blank line in cell with wrapped text
Unwanted blank line sometimes appears in cell with wrapped text. Editing,
Autofit height and width, and justify do not eliminate it. Forcing column
width to be excessively wide makes it go away, as does reducing the font size
(neither of which I want to do). What's going on? This only happens in some
wrapped text cells.
If you uncheck "wrap text" do you see a little square box in the text where
the blank line is?
If so, someone entered a new line using ALT + ENTER.
In that case, you can get rid of these boxes by Edit>Replace
what: hit ALT + 0010(you won't se...How to convert text-cells
I've problems to import Excel-spreadsheet-data into our database. I'm using
Borland-Delphi-ADO, but a test with MS-Access importing feature leeds me
into the same problems.
The spreadsheet contains a col with only 9-digit values, but they have got
the text-attribut except of two that are numbers.
I see this when I delete the aligning-property, all cells are left
justified, but the two right.
I know I can give a col the text-attribute while importing data from a
But I dont know how to delete the text-attribute or set it for a complete
"...Nested IF that will ignore blank (empty) cells
I have a simple nested IF function (Excel 2003) which compares numbers in
two cells, then returns a word depending on whether one number is greater
than, equal to, or less than the other:
Either (or both) of the compared cells might contain the number 0 (zero) in
which case I want the IF function to display the appropriate word.
However if the compared cells are blank (have no data in them), my
unsophisticated IF function thinks that F3=G3 and returns the word "Equal".
How can I get the ...