Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Please help..with a formula. I don't know code.
I have a long list of numbers - values in a file X, and I want to fin
and replace those values in a even larger list in a file Z an
highlight those values in Z
Message posted from http://www.ExcelForum.com
not really sure what you're trying to achieve. What do you
want to replace, etc. You may give an example (plain text -
no attachment please)
>I have a long list of numbers - values in a file X, and I
want to find
>and replace those values in a even larger list in a file
>highlight those values in Z.
>Message...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...Microsoft Money 2007 Deluxe Canadian version?
I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
cannot find it. Where can I get one?
There isn't one. See http://money.mvps.org/faq/article/422.aspx
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"masai" <email@example.com> wrote in message
>I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
>ca...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Office 2007 trial is very slow. Is this because it's a trial
I just started using the trial version of Office 2007. It takes forever for
it to open on my computer but Office 2003 opens just fine. Is this just
because it's a trial or is it naturally slow because of the additional
It's likely due to the expanded feature set and increased hardware
requirement over Office 2003.
> I just started using the trial version of Office 2007. It takes forever for
> it to open on my computer but Office 2003 opens just fine. Is this just
> because it's a trial or is it naturally slow because of the ad...Need help with formula 01-13-10
I am trying to adapt a formula in I2 from another spreadsheet that works
well, but won't in mine. I've traced the error, but I would need help to
understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be
advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a
list of non-workdays, and defined the column of dates with the name "NWD".
What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb.
5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb.
5, and Feb. 6 and...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
Southampton...Need a default email account for all users, need help.
I have a tablet PC running WinXP Tablet with Outlook 2003. This tablet
connect to our exchange server via VPN. How can I set it up so that
that logs onto their account can access one (the same) email account.
problem is that I dont know at this point all of the users however
using the tablet will use one generic email account. So how can I set
Outlook to default to this account so that no matter who logs on they
use this account?
...When launching Outlook I recieve the following error... please he
When launching Outlook 2003 I recieve the following error:
The add-in "C:\PROGRAM~1\SPAMBL~1\Bin\461~1.0\SBOLExt.dll" could not be
installed or loaded. This problem may be resolved by using Detect and Repair
on the Help menu.
I ran the Detect and Repair and that didn't work. I ran the repair option
from Add and Remove Program in Control Panel and that didn't work. I also
un-installed and then re-installed Outlook 2003 and that didn't work. I'm
running Windows 2000.
Did you have something possibly called SpamBlocker installed at some point?...DEADLINE... PLEASE HELP! Stacked Bar chart?
I'm not even sure how to ask the question so here's what I have...
2003 2004 2005
Actual/Goal Actual/Goal Actual/Goal
Me 1009/1061 591/866 658/897
Comp. A 966/1012 633/811 624/808
Comp. B 699/744 450/593 480/607
Comp. C 957/1005 642/821 665/838
I wanto to show a bar for each competitor, for each year, so there will be 4
bars for each year. Each bar showing Actual performance & Performance Goal...Office 2007 SP2
Has anyone else lost the little check box which is usually found next to
each task in the task list in Outlook today? I'm assuming it's a bug?
"Carmen Gauvin-O'Donnell" <firstname.lastname@example.org> wrote in message
> Has anyone else lost the little check box which is usually found next to
> each task in the task list in Outlook today? I'm assuming it's a bug?
Nope - still there...
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level...please help with this query
Ost Ocity Dstate Dcity Carrier Price Rank Diff
A B C D X 1200 1 100
A B C D Y 1300 2 100
A B C D Z 1350 3 100
A B C D W 1789 4 100
A1 B1 C1 D1 X1 785 1
A1 B1 C1 D1 Y1 789 2
The rank for every carrier is based on the price . If rank1
is not a pariticular carrier(say if it is not X1 or
Y1 or Z1), then i want to calculate the difference be...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Send from Word
When I hit the send button in Word or Excell I get a pop
up that say choose profile with Outlook in the drop down.
That is the only name in the drop down. If I hit OK I get
the following Message.
The MAPI Spooler could not be started. Close and then
restartall mail-enabled applications.MAPI 103 (0000004C7)
If I choose to set up a new profile I get a Microsoft
Exchange Setup Wizard. As I try to setup a new profile I
come to the following,
The following unrecoverable error has occured:
The .DLL file for this service is either damaged or could
not be found.
What versi...Embedding worksheet into Word
Has anyone had the experience where when they embed a worksheet into
Microsoft Word, a portion of the worksheet gets cut off?
Is there an easy fix to this?
...Unable to repy using word editor
When repyling to an e-mail I receive the following
message, "This form requires Word as your e-mail editor,
but Word is either busy, or cannot be found. The form
will be opened in the Outlook editor instead". I found
article 284900, that states you may get this message when
you have office 2000 and office xp installed on the same
computer. This is not the case on my computer, Office
2000 does not exist, only office xp.
Can anyone help me?
There appear to be a whole host of causes for this error message. Most have
no solution. Here are a few that do:
http://support.microsoft...Fewer normal template problems with Word 2000 or 2002?
I have enjoyed some things about Word 2007, but I keep having problems
with macros and templates. I am wondering if (a) macros increase the
likelihood of corrupting the normal template in 2007, or (b) if the
older versions of Word had as many template problems. I have used Word
in 2000, with Office 2003, and now with Office 2007 and I don't ever
recall having as many problems as I've had with 2007.
What I'm thinking is that if it is simply a macro problem causing
corruption, I would simply use 2007 without the macros (they're nice
but I can live without them). On the...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 126.96.36.199 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that
link to a file on our server. I am needing to test to see if the file exists
and if it does, copy the file to a folder in my documents called
(CapturedFiles) and if it doesn't format the cell color to red. Can VBA do
this and if so how? Any help would be greatly appreciated.
Thanks in advance.
Fileserver or webserver ?
On Nov 23, 7:20=A0am, Aaron <Aa...@discussions.microsoft.com> wrote:
> I am needing some major help. =A0I have a file with hyperlinks in column =
> l...Help please user not showing in 5.5 GAL but is in exchange 2003 GA
Up until today I have been bable to add users fine and their address would
appear in both the 5.5 GAL and the exchange 2003 GAL.
Is a single site with 2 5.5 servers and 1 exchange 2003 server.
When I add a new user now through users and computers and put the mailbox on
the new exchange 2003 server the user gets his email addresses and appears in
the GAL on the 2003 server but people connected the the old 5.5 servers
cannot see it.
When I open the 5.5 exchange admin tool again if connected to one of the old
5.5 server I cannot see the person I just created but when connected the the
20...Outlook 2007: is there a way to use it as a Diary
I'd like to keep a daily journal of important notes, etc. In other
words , I would like to keep a Diary. Does Outlook 2007 have this
Sure - Ctrl+8 to view the journal or you can create a Mail and Post folder
type and post to it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH...Upgrade Path from DPM 2007 to DPM 2010
Is there going to be an upgrade path from DPM 2007 to 2010?
Yes. Look at the following DPM 2010 documentation:
"DPM supports upgrading from DPM 2007 SP1 on a Windows Server 2008 x64-bit
operating system to DPM 2010. If DPM 2007 SP1 is installed on a Windows
Server 2003 x64-bit operating system, you must upgrade to Windows Server
2008 before upgrading to DPM 2010".
Also, here are my notes on DPM 2007 to DPM 2010 upgrade:
http://santhoshsivarajan.blogspot.com/2009/09/dpm-2007-t...help with a sub
can anybody tell me why the following code fails at FormatConditions.Add
Private Sub CommandButton1_Click()
Dim Sh As Worksheet
Dim lngLastRow As Long
Set Sh = ActiveWorkbook.ActiveSheet
lngLastRow = Sh.Cells(Cells.Rows.Count, "A").End(xlUp).Row
Range("A4:E" & lngLastRow).Activate
Selection.FormatConditions(1).Interior.ColorIndex = 24
Traa Dy Liooar
You have an extra open paren just before MOD: