Need Syntax for "AND" to Evaluate 2 Cells
I need to evaluate 2 cells while inside an "Private Sub
Worksheet_SelectionChange(ByVal Target As Range)". I thought AND would work
but I cannot get it to work; I receive a syntax error on the AND(Range...
Can someone please provide me the proper syntax to evaluate the 2 cells?
Here's my code...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Name = "Sheet1" Then
And(Range("I3") <> "", Range("K4") = "") Then
Range("K4") = Range("K3")
End...Deleting "mail to:" email address links
I have a relativly straight forward spreadsheet where I
am maintaining a large address list. It contains a
homeowner's lot number, name, address, telephone #, and e-
mail address. When attempting to select random cells for
data entry/modification, I receive and automated
message " mailto: (a random e-mail address) - click once
to follow. Click and hold to select this cell."
I have no idea where/how this message/feature/function is
being attached to these cells but would like to eliminate
it. Since seeing these messages, the size of the
worksheet has been increasing in ...Enter "1", cell show ".01". Why?
Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct.
What caused this and how can I fix it?
Try this ..
Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
Things should be back to normal now ..
(it's a fixed decimal setting !)
"Yonian" <Yonian@discussions.microsoft.com> wrote in message
> Any number typed into a cell is divided by 100.
> If p...Adding Contacts Folder as Address Book in Exchange Server
I am trying to add my contacts folder to my address book in Outlook XP and
don't see the Tools, Options I used to see in Outlook 2000. How can I add
this folder to my address book? Is that an option you can turn on or off
for a profile in Exchange Server?
Remove 'spam' from email address to contact me directly
Right click on your Contacts folder, go to properties, outlook address book.
Can you tick the box there?
If not, go to tools, e-mail accounts, view/change address books, and make
sure you have the Outlook Address Book option there. Then try right-clicking...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
news:OjVc...How to install Exchange in an "Administrative Group"
I am running Windows 2003 and Exchange 2003 on a DC in my lab. Exchange is
installed in the "First Administrative Group".
Now I want to install a second Exchange 2003 Server in another
"Administrative Group" called "Midwest". This is what I did:
1. Installed the second Exchange 2003 server in the "First Administrative
2. Created the second "Administrative Group" called "Midwest".
3. Tried to move the second Exchange 2003 server into the "Midwest"
The problem was that I was not able to &q...VBA Error Message "Compile Error...."
I used a macro from Ron's website to mail each worksheet to the email
address in cell a1. I ran this macro and it worked perfectly for one
workbook BUT... when I tried to use it for another workbook I got the
follwing error message "Microsoft Visual Basic Compile Error Can't find
project or library Ok Help".
Help me please... do I have to check some more references in the VBA tools?
Have you set the reference to Outlook in that other workbook also ?
You must do that in every workbook or you can use Late binding.
See my site for a example
--...Public folder issue, "messaging interface has returned an unknown error"
I'm running a SBS2003 domain and just added a public folder and a
customized form for entry into the public folder. All of our clients
(all XP Pro, Outlook 2003 with all updates) can get to that folder and
use the form without any difficulty except for one. On one computer I
get the classic "The messaging interface has returned an unknown error.
If the problem persists, restart Outlook." error message.
I have tried a repair install, no change.
I have tried making a new profile, no change.
I have tried adding / removing his PST file (currently he's not even
using a pst file...Adding an "I'm out of the Office" Message
Re Outlook Express. I can't find anywhere on the index
about how to send one of those "I will be out of the
office from July blah blah to August blah blah." Anyone
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program, despite its similar name..
You will probably get a faster and more expert answer if you post this to an
Outlook Express news group.
Try posting in one of these newsgroups:
microsoft.public.windows.inetexplorer.ie5.outlookexp...Online Quotes don't work anymore
Online quotes stopped working yesterday. I'm using MS
Money 2001 standard. Any clues?
There was a glitch for a bit that seems to be cleared up now...
"Robert" <firstname.lastname@example.org> wrote in message
> Online quotes stopped working yesterday. I'm using MS
> Money 2001 standard. Any clues?
>Online quotes stopped working yesterday. I'm using MS
>Money 2001 standard. Any clues?
>I have the same issue. It worked the first time but not
since. Big problem for m...[ANN] "Bend Word to your Will" -- April 2005 edition free download
THIS ANNOUNCEMENT IS ABOUT A *NON-COMMERCIAL* RESOURCE BASED IN PART ON
ACCUMULATED ADVICE FROM THIS NEWSGROUP
The latest version of my notes on Word -- titled "Bend Word to Your Will" --
is now available for downloading from the Word MVPs' site,
WHAT IS "BEND WORD TO YOUR WILL"?
"Bend Word to Your Will" is not a commercial product for sale -- it's free.
It's a dictionary-style (mainly) set of notes on Word that I've been
continually adding to and polishing for the past four year..."could not fetch new headers " ERROR
i get the error " could not fetch new headers in the inbox of IMA
server.The operation was cancelled ", while using my outlook 2000 o
config: smtp/imap thro internet mail a/c option
pl try to provide solutions to it.
the error message pops up say every 5 min whenever outlook is on.
thnks n regards
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
aggiridharan <email@example.com> wrote:
> i get the error " coul..."This May Be Spam!"
We have an End User who, when sending to an individual at another company,
has his email flagged "This May Be Spam!". (It's not Spam by any means - it
is legit email). I vaguely recall this as being Exchange's way of marking
what it feels is potential Spam and I believe the recipients organization is
using Exchange. Can anyone confirm this? Thank you.
> We have an End User who, when sending to an individual at another
> company, has his email flagged "This May Be Spam!". (It's not Spam by
> any means - it is legit email). I vaguely recal...Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.
How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?
There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...Saving MY Calendar into "Publication-Calendar"
My problem is that I have to make a certain type of calendar in every month. It would save lots of time forme if I could find a way that I could save my "calendar setting" and also be able to apply the new month's settings. There is any way that I could save my "home-made" calendar into "Publications-Calendar" and call it up just like the other calendars? Thanks.
If you have repeating items you just use the Merge for those items every
"If you don't know where you are going,
any road will take you there!"
I do not understand ho..."Can't copy the items. You don't have permission ..."
I use OL 2003, latest service pack,etc. My PST file is about 1.2 GB
and is Unicode-compatible.
Lately Outlook shuts down suddenly without warning, and I have left
checked the box to restart Outlook automatically. This is a big
annoyance. However, in the last 2-3 days, I'm seeing a new kind of
problem. I can't delete or move messages from mail folders.
I get the message that is in the subject line, and the balance of this
... to create an entry in this folder. Right-click the folder and then
click Properties to check your permissions for the folder. See the
folder o..."Archive all messages sent or received by mailboxes on this store" option problem
I want to backup the all message sent or received by mailboxes, I find that
there is an option "Archive all messages sent or received by mailboxes on
this store " in Exchanger 2003.
I had selected this option and forward to public folder. But I found that
not all message will be archived.
- All message sent by mailboxes can be archived
- Some Messages come from mailboxes will not be archived
Eg: yahoo, hotmail, and other company
Is this option not archive this message ?
Any other setting need to configure ?
...Quotes, orders and invoices all crash CRM!
I have a post update callout process which I have attached to the
update event on the quote, order and invoice. Having attached the
process whenever I attempt to read an existing quote, order or invoice
or to save a new quote, order or invoice CRM presents its 'an error
has occurred please contact your system administrator' message.
Normally in this case I would check the event viewer but in this case
it is completely empty! The callout process as it's first action logs
a message to a file just so that I can monitor the progress and this
is not happening so it appears that the pro...Are there MFC subclasses that give a different "look and feel" to the UI?
I was wondering if there are free implementations of MFC subclasses of
windows and controls that give you a different look and feel? I like
the Windows 2000 look, but it's quite a bit dated now, and the XP look
is hideous for my taste, so I'm looking for something new, more modern
looking, sleek. Thanks in advance for any suggestions.
See if this has something your looking for.
"Franco" <firstname.lastname@example.org> wrote in message
>I was wondering if there are free implementa...ntbackup job terminates with "media failed to mount" message
ntbackup on Win Server 2003 running Exchange 2003, backup to 4mm DDS
We run two nightly backup jobs, one for the Information Store which (
operates correctly (with or without the /um switch), and one for files
backup which doesn't complete correctly and ejects the tape on the
last or 2nd to last job (there are 8 jobs, usually error occurs in job
7 or 8) The backups total about 23 Gb but we are using 20/40 Gb tapes
with hardware compression enabled.
Report pasted below. Our previous backup schedule consisted of only 1
job, and this error was corrected by appending the /um switch t..."Enabel / Disable macros" message box appears no matter which .xls file the user opens....
"Enabel / Disable macros" message box appears no matter which .xls
file I open... I can't find any hidden/empty code in the xls files...
Has someone got any experience with this?
Nils Egil Lie
Stolt Offshore AS
you also have to remove the (empty) modules in the VBA editor. Also
check that there're no statements left in the worksheet modules and in
the workbook module
Nils Egil Lie wrote:
> "Enabel / Disable macros" message box appears no matter which .xls
> file I open... I can't find any hidden/emp...Adding GAL users into a custom form
I have created a custom form, and am required to add a series of approvers.
What I am trying to achieve is:
* Add users from my GAL into a text field, so that when the form is sent,
they do not get initially CC'ed the form.
Is this achievable, and if so, how do I do it (if you could help by
including any appropriate code, that would be great).
...Track registered products and trigger event
I have a very simple spreadsheet that has a column of serial numbers
and next to it a column with a yes/no tracking whether a serial number
has been registered or not. I want my sales team calling into an
account once 50% of the serials are registered so I created a pivot
table that simply has the yes/no field on the top and a count of each
in the data. Then I created a pivot chart with the yes and no next to
each other and the data labels displayed. So far so good and this
does accomplish what I want at it's most simple level.
What I would love to do though is:
1) change the count (a...Non AD emails going to 1 user
I have an Exchange 2003 server running on SBS 2003 the issues is one user is
getting all the emails sent to him that look like they are coming from his
domain. For example his email is email@example.com but in his inbox he is
getting XYZ@mydomain.com but XYZ is not in the AD or has a email box set up
on this server. Why is getting this non AD email and how can I stop it.
Thanks in advance
Are you sure it's not a SPAM where the spammer may have simply put in
firstname.lastname@example.org and BCC it to all possible conceivable names
"LaOVis" <LaOVis@discuss...Create an "alias" address to send from, for a user's mailbox
We have an Exchange 2003 server
One of the users address is: email@example.com
The problem is that some SPAM engines, don't like the "admin" part.
We need to create an alias, let say "response" and use this as the REPLY
address. Mail will then be send from admin@domain, and will be received, as
it was sent from admin@domain. ONLY the reply address should be
I know Outlook with normal POP3 mail can do this. Anyway in Exchange to set
On Wed, 23 Nov 2005 01:28:02 -0800, Rupert