Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...Outlook 0x800ccc0d error when Norton e-mail protect enabled: see hosts
This post is made to help others solve this issue, based on my
- Outlook works perfectly well when Norton Anti-Virus e-mail
protection is disabled
- Outlook cannot retrieve incoming messages when NAV e-mail protection
is enabled, message being: pop3 server not found, error 0x800ccc0d
This symptom, and possible solutions, are exactly the object of
Symantec support note:
Please read this note first ! The object of this post is to add
another possible solution to this problem.
NAV email protection sets up...Stop My Documents from opening all the time?
Is there anyway to stop My Documents from opening everytimg I start a
Windows Explorer session?
I guess there's no future in trying to delete it, because so many products
try to put stuff there. Right?
> Is there anyway to stop My Documents from opening everytimg I start a
> Windows Explorer session?
If you want Explorer to open somewhere else, simply modify the
properties of the shortcut you're using to open it. All you need do is
create/modify the target field of your Windows Explorer shortcut to
point where you want it.
Co...Cannot open Outlook, keep getting Send error report of Microsoft.
We are having problems with Outlook 2003. Everytime we
try to open, we get this: Send error report to Microsoft.
Any ideas why? All windows and office update have been
...How do I see when new messages without outlook running?
Without Outlook 2003 constantly running, how do I send mail or know when I
have new mail?
two possible answers...
1) you don't or
2) you acquired a 3rd party app to occasionally poll your pop3/imap account
"Leslie Adams" <Leslie Adams@discussions.microsoft.com> wrote in message
> Without Outlook 2003 constantly running, how do I send mail or know when I
> have new mail?
...Document Viewer installer error
I recently ran CHKDSK /F as this was prompted when I attempted to run defrag
etc. Since the chkdsk was run, when I turn my PC on, I receive the following
"document viewier - installed encountered an unexpected error - error code
2908". I click run, the same error just repeats and loops. The only was I can
remove it is to end task via task manager.
Any ideas how I can correct this error?
...CSV Files and VLOOKUP error
Does anyone know why VLOOKUP and Compare formulas don't work o
information originating from a CSV file? I've tried copying an
pasting values only (to leave behind any formatting), but it doesn'
Through countless tests, I've narrowed it down to the CSV file bein
the only possible cause
Message posted from http://www.ExcelForum.com
Just a guess but the imported data may have leading or trailing spaces or
are numbers stored as text. You could use the formula =A1=D1 to see if you
get a true or false, where A1 is the lookup value and D1 ia the CVS valu...Uninstall of mappoint has caused errors with excel
I am running Office 2003 on the terminal server (windows 2003) and had a
copy of mappoint as well. This is a mapping program. We ininstalled
mappoint which has caused an error message with Excel and other office
products. The error says "Cd:\documents and
settings\administrator.ocrdc1\application data\microsoft\addins c:\Program
files\common files\microsoft shared\geography\mpoai9.dll is not a valid
add-in." I then click OK and excel opens up and everything is fine. The
problem is that we are using other programs as well such as Quickbooks that
export to excel and t...Over Time Pay rate 1.51?
Its that time of year again, Audit time.
The auditors have come across a very strange problem it seems that around
October of last year random employees have had there OT pay rates increased
to 1.51 (instead of the standard 1.50), I cant for the life of me figure out
how this has come to be. Has anyone come across this problem before? And is
there something I can do to fix or prevent this from reoccurring? It’s just
not feasible to check each employee every week before payroll. Im certain
that the employees were setup correctly initially.
I have seen this and have not been ab...Show date, time & day of week in one cell
Can I show the date, time and day of week in one cell.
09/03/07 8:30 AM
in one cell using the format (Format/Cells/Custom):
[$-409]mm/dd/yy h:mm AM/PM;@
Excel refuses to accept ddd for Mon or dddd Monday at the end of the format
I want it to read:
09/03/07 8:30 AM Monday in 1 cell.
I have Excel 2003.
mm/dd/yy h:mm AM/PM dddd;@
In article <Xns99B8A3CAF9130pencilunlistedcom@22.214.171.124>,
Burp <firstname.lastname@example.orgINVALID> wrote:
> Can I show the date, time and day of week in one cell.
> I have:
> 09/03/07 8:30 AM
> in one cell using the for...Unknown error from CFtpConnection::GetFile()...
I'm having intermittent problems with CFtpConnection::GetFile()...
99% of the time GetFile() succeeds but occasionally it fails and returns
FALSE with a GetLastError of 0x2EFF (12031) which I can't find
Anyone know what this error means...? Where it is defined...?
A bit of searching on on the web seems to suggest; "The connection with the
server has been reset."
Can anyone confirm this...?
Andrew Kilgore wrote:
> Hi all,
> I'm having intermittent problems with CFtpConnection::GetFile()...
> 99%...default values in a cell
Hello, can you help me please
Cell B1 contains a complex mathematical formula which requires (in several
places) a number from cell A1.
Cell A1 can contain any integer number, but it is usually the same (30).
I would like to be able to leave cell A1 empty, and only enter a number when
it is not 30 ,
ie the default value of A1 is 30, unless specified.
How do I go about this ?
Should I look at conditional formatting, or put lots of IF functions into an
already complex formula?
Thank as always
Use 2 cells
Modify the complex formula to use B1 rather than A1 ( or any other un-u...unable to paste Excel 2003 chart into Outlook 2003
(This was posted on "excel.charting" group.)
I have a user who's unable to paste an Excel 2003 chart into Outlook 2003
email message. In Outlook options, the checkbox is selected for "Use
Microsoft Office Word 2003 to edit e-mail messages".
When I tested this on my own computer running the same version of Office, if
the box is check, I have no problem pasting; if this box is cleared, I
cannot paste. But on his computer, it doesn't work regardless.
Thanks and regards,
...Setting a dynamic range in a formula
I have a column of numbers and I always want the following arra
formula to use the last 12 entries:
Phillycheese5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2419
View this thread: http://www.excelforum.com/showthread.php?threadid=37809
Assuming that Column D contains no blanks, try...
...confirmed with CONTROL+SHIFT+ENTER.
Hope th...Error 550 Relaying denied
I get this nearly every time I try to send information
using MS Outlook email. Any suggestions?
You probably need to turn on authentication to your outgoing server. You
can do so on the "Outgoing Server" tab for your mail account.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
Dick Brenneke wrote:
> I get this nearly every time I try to send information
> using MS Outlook email. Any suggestions?
Th...random number generator
Hey is there a way to generate random numbers like you would for a
draft. In other words, i have numbers 1 through 10 and generate a
random order for those?
Use the RAND() function. If 1-10 are in A1:A10, enter =RAND() in cell B1 and
copy it down through B10. Recalc (F9), then sort by column B.
Hope this helps,
> Hey is there a way to generate random numbers like you would for a
> draft. In other words, i have numbers 1 through 10 and generate a
> random order for those?
You would have to generate 10 random numbers ...mail queues for long on Exchange 2000 server time before being sent
I have a situation where all outgoing mail sits in a queues on the Exchange
2000 server (one per domain) for about 45 minutes before being sent. The
queues in question have a status of ready. There are also other queues of
that are retries (mostly NDRs from junk mail). We are only a small company
and the amount of mail is not great. What might Exchange be waiting for
before sending this mail? Is there something I can tweak to make it send
Thanks for any help,
Where does the mail go after it leaves your Exchange server, does it go to a
smarthost/isp or d...I cannot get Outlook to send/receive. Error says object not found
I just installed Outlook2007. I cannot get the send/receive to work. That is
when the error says Object not found. If I go to accounts and properties, I
run the two tests and they complete fine. What should I try next? Outlook
2007 is the only new program, all the rest are from Office 2003
IMK <IMK@discussions.microsoft.com> wrote:
> I just installed Outlook2007. I cannot get the send/receive to work.
> That is when the error says Object not found. If I go to accounts and
> properties, I run the two tests and they complete fine. What should I
> try next? Outlook 2007 is ...ERROR: 5.1.2 or other punctuation after the recipient's email address.
I am trying to send a email to a group address I created with 58 addresses
When I try to send the email to this group I get the following Error:
"5.1.2 or other punctuation after the recipient's email address. "
I have gone back to the original contact cards and made sure the addresses
were all legal.
I have re-created the list, same problem
I have re-booted, same thing.
Any thoughts out there?
My wife and I have MBP's and are both running MS Office for Mac's, Entourage
Both of us have messages cued up in the out boxes th...how do I add error bars to a 3D chart in excel?
The help states you can only add error bars to data series in 2D area. Is
there a way to add them to a 3D chart?
I would not have thought so. Obviously as it is not a built-in option
the only way would be a work around perhaps using dummy series.
Unfortunately you can create 3d combination charts.
Stick with the 2d view.
> The help states you can only add error bars to data series in 2D area. Is
> there a way to add them to a 3D chart?
Andy Pope, Microsoft MVP - Excel
I checked, and error bars are not offered for 3D ch...Call & Place Graphic Based on Cell Value?
Is there any way to call & place a graphic image based upon a cell value?
Maybe you can look at J.E. McGimpsey's page:
> Is there any way to call & place a graphic image based upon a cell value?
...Let me use the Line Color icon on charts
It would speed up a lot of my work if I could use the Line Color icon on
Excel charts, the same way I am able to use the Fill Color and Font Color
However, when I highlight any chart object, like the Plot Area, Chart Area,
or a Series, the Line Color icon is disabled.
Stuart Bratesman, Jr., MPP
Muskie School of Public Service
Univ. of Southern Maine
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If ...Error 130
Hope someone can point me in the right direction.
OSX 10.63, MacOffice 2008 12.2.4
When I try to connect to the following news server ( that doesn't require a
user name or password ) I get the following error when attempting to
download the List of Newsgroups:
"Too many connections in your class - Could not receive the Newsgroup List -
ERROR 130 "
Any pointers much appreciated.
Using Msnews servers works fine.
Remove usual to reply direct.
On 4/27/10 10:49 PM, in article 59bb7979.-1@webcrossing.JaKIaxP2ac0,
"We...Is there a way to cut off unused cells on a sheet
It seems there are an infinite number of cells on a sheet. As I really dont
have much info to enter on each sheet I was hoping there was a way I could
somehow cut off all the extra stuff to the sides and bottoms. It is a hassle
because everytime I scroll, it will scroll off the side or bottom way past
what I was looking for.
A manual way is to goto the last used row and delete all rows below. Do the
same with columns. SAVE
"newbie" <email@example.com> wrote in message
news:469AABE7-8D17-4B72-91C1-...Reference / Copy Dynamic Data
Have a worksheet listing products and prices for numerous suppliers.
This worksheet will change often.
What I would like is to reference this information on other worksheets.
I would also split the info onto a worksheet for each supplier.
Therefore i will have a worksheet for ABC and for XYZ, and the info in
these worksheets will change as the main "index" worksheet changes.
Worksheet ABC contains: