MVC2: linking from one area view to another area view
I am working on an MVC 2 app. I have 7 different areas in it which has a
view that should be accessible from the home page (or anywhere else really).
The links most likely will go in a sitemap and get put on the apps master
page. Either way, How would I say link to Headlines/home/ from the apps
...PASTING NON ADJACENT CELLS
I'm sure this is a very silly question, but I sometimes have a problem
pasting non adjaent cells. I select the cells using the CTRL click then
copy, which always works fine, but sometimes when I try and paste the cells
elsewhere I get an error message saying I can't paste non adjacent cells.
Has anyone else come across this? It's very frustrating as sometimes I can
do it and sometimes I can't. Anu sugegstions would be welcome.
Good morning FarGardner
The excel rule is "you cannot copy non-adjacent ranges."
But you can. Sort of. If the se...XP visual styles in tab controls
I'm having a couple of problems applying the new Windows XP visual
styles to a legacy application.
A property sheet with several property pages looks perfect:
...., but a similar dialog box implemented with a tab control looks
The problem is that the content of each tab has the same color of the
tip of the tab in the property sheet, whilst one and the other differ
in the second version.
Do you hav...Arrow appears next to some cells
I have a problem with an Excel sheet someone sent me by
email. I have Office XP SP2.
When I select some cells in this sheet, an arrow pointing
down appears to the right of the cell. This arrow opens a
blank drop down selection box. How can I remove this arrow.
I can paste a blank cell over this cell to remove the
arrow, but I want to know exactly how to add/remove this
arrow in the future.
It's probably Datavalidation pointing to an
Remove it by selecting the cell, choose
Data > Datavalidation
In "Allow" (or similar) choose &q...Money2000/Windows XP
I purchased a new computer because the motherboard died
on my old computer. The harddrive from my old computer is
however intact. My old computer used Windws 2000. I have
installed the old harddrive in my new computer as a
second harddrive but are unable to open MS Money.
Unfortunately I have no backup of the MS Money info.
In microsoft.public.money, <email@example.com> wrote:
>I purchased a new computer because the motherboard died
>on my old computer. The harddrive from my old computer is
>however intact. My old computer used Windws 2000. I have
>installe...Cell Formatting Defaults To Scientific
I have a spreadsheet that a user is having problems with.
One of the columns contains a job name which is made up of numbers and
If I enter 7E1, it immediately formats the cell to Scientific and turns the
information into 7.00E+01
Even if I go in and format the cells to General and try to re-enter the
details, it does exactly the same.
Is there a way to stop this happening.
Formatting to General doesn't help, as you've found. Either format the cell
as TEXT before you enter the data, or precede the data with an apostrophe.
David Bid...Outlook XP hangs #2
Help! I can't get my outlook to do anything. Once it
opens, t jams and then says not responding. What can I
do? Will reinstalling the software help?
You may have a corrupted outcmd.dat file. This is the file that stores your
toolbar customizations, and when it becomes corrupted, Outlook can't use it
at startup to build your toolbars, thus causing the hangups. Try renaming
or deleting your outcmd.dat file while Outlook is closed. Renaming it might
be the best idea if you have a lot of customizations that you'd prefer not
to lose; that way if renaming the file doesn't solve...sheet cell linking?
I have sheet1 and sheet2.
In sheet1 (A1) I need to write number 5.
In sheet2 (A2) I need to write number 3.
Then, when I enter number 3 in sheet2 (A2) it automaticly needs to correct
number 5 from sheet1
to number 2 ( so it does 5-3=2).
How can I do this?
Thanks in advance.
Insert the following worksheet event macro in the Sheet2 code area:
Private Sub Worksheet_Change(ByVal Target As Range)
Set ws1 = Sheets("Sheet1")
Set s1a1 = ws1.Range("A1")
Set ws2 = Sheets("Sheet2")
Set s2a2 = ws2.Range("A2")
If Intersect(Target, s2a2) Is Nothing Then E...Painting a cell depending on written content
I would like to paint cell depending it's content.
The content is chose from a list.
A cell had a list of values: Value 1 and Value 2
when the cell is empty (no value has been chosen) it's color shoul
When we pick value 1 in list, the cell becomes red.
When we pick value 2 in list, the cell becomes Blue.
Thanks for your help
Message posted from http://www.ExcelForum.com
You can use conditional formatting to colour the cells. There are
instructions in Excel's Help, and here:
ru...XP-32 can't read dynamic disk set after Win7 install
I've got XP Pro 32-bit, XP x64 installed and did a clean install of
Win7 Pro. I have a couple of dynamic disks which have stripe and volume sets
on them. Win7 apparently "touched" them in some way and XP 32-bit can't read
them. Trying to "reactivate" in Disk Management produces errors in the event
logs of "Format Error was found in configuration copy" and "Internal Error:
The disk group contains no valid configuration copies".
Now, XP x64 can read the dynamic disks just fine (as well as Win7
which continues t...IE7 replaces phone numbers on web pages with Skype links
Win XP, IE7. I have Skype installed but normally not running. Yet IE7 puts a
Skype link on all phone numbers on web pages. Firefox doesn't do this, so
this must be some setting in IE7. Anyone know how to fix this?
Never mind- I found the solution. It's a Skype Add-on. It can be disabled in
IE7 via Tools | Manage add-ons.
(I recently installed IE7 and had a lot of settings changed by software
upgrades, so a lot of things aren't working as they used to.)
"Bobbi" <firstname.lastname@example.org> wrote in message
news:uZwLhvGALHA.3...How to use an integral for cell output value.
Suppose in the A column, I have a column of data in cells A(1) to A(10).
I would like the output data in cells B(1) to B(10) to be given by the
B(N) = Integral of f(x)dx, evaluated from 0 to 10.
Where f(x) = sin[A(N) * pi * x / 10]
This integral gives a real # in all cases; my hand-held calculator can solve
them, but it's tedious to do each calculation individually (because in
reality I have way more than 10 values I need to solve). Iit would be handy
if I could have excel do this calculation for me, but I can't figure out how
to make excel use an integral...Tab name when cell is blank
I have a multiple worhseet workbook. I need to see the tab name for those
worksheet that have a specific blank cell. So, within a range of worksheets
I need the tab name for those where A1 is blank.
Your help is greatly appreciated
Regards from Montreal
Not really sure what you mean, do you want a list of all such sheets (which
will need VBA), or do you want a formula that will test a value in a sheet
(which needs the sheet name to test - circuitous).
(remove nothere from the email address if mailing direct)
"Jet" <Jet@discussions.microsoft.com> wrote in me...select specific cells and consolidate same over many worksheets
Given that my excel skills are limited at present, I have a task for work
that I hope you can help with.
A series of saved excel files that are based on weeks - Monday to Sunday.
The sheets are arranged with 1st column being a store with various stores
runing down in rows(not each week shows the same sytores however there are
many times where the same store is shown in seperate sorkbooks). The days of
the week are also aranged in columns- Mon, Tue Wed, Thur, etc.
The cells below each day for the store shows total sales .
So the workbook for the week will show the total sales per store p...External links #4
I have a sheet with a bunch of links to external data, which is just
another workbook. The links are created with a formula. Now, the links will
not update unless I have the other books open too. Is there a way to update
them automatically? Excel doesn't want to ask me if I want to update them
Check under Tools/Options/Edit and make sure Ask To Update Automatic Links is
"Andrew Clark" wrote:
> I have a sheet with a bunch of links to external data, which is just
> another workbook. The links are crea...randomized slide links
I am using PowerPoint 2000. Is there a way to set up a custom show so that
the next slide is randomized.
I have looked at action settings and of course don't see a way to link to a
random slide. Is there another way in 2000?
In article <7ADF5D21-1EF9-4C45-9669-1BE717F45E15@microsoft.com>, Dkb43 wrote:
> I am using PowerPoint 2000. Is there a way to set up a custom show so that
> the next slide is randomized.
> I have looked at action settings and of course don't see a way to link to a
> random slide. Is there another way in 2000?
Not bui...Outlook 2002 on Win XP hanging at start up
I have a problem where Outlook under Office XP hangs at
startup. This only seems to occur after the first time
it is loaded - i.e. Outlook started (usually OK), then
Exited, and then re-started. Full service packs loaded
for Office and SR1 for Windows XP.
Anyone any thoughts as to what the problem might be?
...How to find highest, lowest and last cell in row?
I'm having trouble trying to find an excel function that will let me return
the highest, lowest and last cell in a row of cells spanning M10..CF10 (60
All the consecutive cells will have a value, but the row will only be
partially full with some number of still empty cells at the end.
Is there someone who knows how I can solve this problem. Thanks for your
Please reply to the newsgroup as my email address is false to avoid spam.
1. Min value: MIN(M10:CF10)
2. Max value: MAX(M10:CF10)
3. Last value (if you only have numeric values):
=I...Get Range object from Cell Row and Column No.
I'm using Excel 2003, I have a function which I want it to return a range
object which points to a cell, the cell is identified by the code which
determins which column number and row number make up the Cells RowIndex and
ColumnIndex attributes. For some reason I keep receiving an
application-defined or object-defined error, my code is below, any advice
would be appreciated:
Function GetJournalInsertRange(ColumnHeader As String) As Range
Dim ColumnNumber As Integer
Dim RowNumber As Integer
ColumnNumber = 0
For Each header In Range("JournalHdr&q...Formula to update cell w/ActiveCell.Value?
Can I put a formula in a certain cell that will, on recalculation, update
that cell with the value of the current ActiveCell?
Don't think so. But this sub will do it. Paste it into the sheet module.
Change the location as necessary.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False ' prevent retriggering
Range("A1") = ActiveCell.Text
Application.EnableEvents = True
mvpearl omitthisword at verizon period net
"Ed" <Ed_Millis@NOSPAM.Ho...unsafe attachments in Windows XP-Outlook Express
I previously recvd some emails with attachments I was
unable to open, but I had always deleted them rather than
processing the update suggested. I could previously open
all other attachments, except the few with this error
message. About Dec.10 I decided to follow the
instructions to download (I'm not sure what), it was
going to allow me to open one of these attachments. I did
so, and since then have been receiving a message on ALL
emails with any attachment of "OE removed access to the
following unsafe attachments in your mail: "title of
email attachment".eml"...Cell issues
I'm having an issue getting everything that I have typed to show up i
the cell. I've checked everything I know to check but curious if ther
is a limit to how much you can put in a cell? Or is there somethin
else that I need to check
mysticray's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=527
View this thread: http://www.excelforum.com/showthread.php?threadid=26727
the max is 1,024 characters. you can extend this limit by manually
inserting linebreaks with aLT+eNT...External Distribution List(Group)
I am trying to create a DL with a few hundred members
(external). OL2003 is limited to about 150 or so. Someone
here (Neil I believe) suggested that I create a Dist.
Group in AD. When I looked into that it appears that you
can only do that for "internal" members, meaning I would
have to manually add each external member into my AD. Is
that right?? Because I wouldn't want to do that,,,,,,would
What is the best way for me, in Exchange, to create a DL
(group) whereby I can have external email addresses
(members) listed. I want my internal users to be able to
send out...Excel formatting of text-- one cell needed
I want to paste txt or doc text into one cell. Instead it populates the
spreadsheet. A colleague who does not know English tried using CNTRL+X and
was able to put the pasted text into one cell but could not duplicate it. Any
-- I want to take this list
-- Or group of statements
-- Into one field in Excel
But I get
A1 -- I want to take this list
A2 -- Or group of statements
A§ -- Into one field in Excel
Double click in the cell to enter Edit Mode (or select the Formula box
in the Formula bar) before pasting.
In article <1D341060-EB4F-41...can I create an "if" formula with an external list?
I'm doing an extract from our system & can only extract a 2 digit code.
There is a description that goes along with the code, but I'm not able to
pull that part out, so I need to duplicate it in Excel. Example - type of
account is defined by a 2 digit number--
I need to add a column to insert a description that matches up with the
code. In the past I've used an IF function, but because these can change, it
would be easier to maintain a separate list & add the description based on
Is this possible?