Wrap Text and Blank Lines
I have a VBA script in Excel that fills data from one spreadsheet to
another. In the output file some of the cells are having the
formatting .WrapText = True. Now I have the strange situation that
some cells display half a line or an entire line of white spaces at
the end, even though in the text no blank or special characters are
I'd like to get rid of the white space or at least understand why this
is happening. I have looked at the size of the cells, the number of
characters but I have not yet found the trigger for the phenomenon.
I have been searching quite some time now and...default format new message
How do I change the default format on the new message to
have left orientation rather than center? The appropriate
theme comes but only with center orientation. I am using
Outlook 2003, Word 2003 editor and Windows XP.
Edit your theme.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Vivian asked:
| How do I change the default format on the new message to
| have l...Not seeing new mailboxes
I am all of the sudden having a problem creating a mailbox for a user. When I
go to the Exchange 2003 server and go to Exchange tasks on the user account
and select "Create Mailbox" it looks like the mailbox get created but I dont
see it in the Global address list. I then run Recipient update service on the
Exchange server and still nothing. I have tried to delete the mailbox and
recreate it but still I dont see anything. What could be going wrong?? Thanks
On Wed, 25 Oct 2006 14:15:02 -0700, Chad Guiney
>...Installing Office 2004 on a new Mac
I've used my three Home/Student Edition Office 2004 licenses on installations
on two desktop Macs and a laptop. Now, I'm replacing the laptop with a new
one. I understand how to move my Office data over to the new laptop by
copying the Microsoft User Data file but am concerned about the basic
installation of Office 2004. Can I use one of the three licenses over again
or somehow transfer the license from my old laptop to my new one or must I
buy another three licenses for Office 2004?
You can use your old license again. Mac Office does not require activation,
unlike Win Office...sum of blank and non blank
Hi, How do I count blank cells in a range which contains text and separately
how do I count cells that are not blank?
I used =countblank(range) which works but how do I do the opposite, count
cells WITH text in range?
will count all cells that are not empty in "range".
will count only cells that contain text.
>Hi, How do I count blank cells in a range which contains
text and separately
>how do I count cells that are not blank?
>I used =countblank(range) which work...Where did the new look go?
Everything was working fine in O2007 B2TR until I saved in the old O2003
format and since then, O2007 opens with the old O2003 Publisher windows. I
would reallly like to have the new look back so that I can get used to them.
Pub is one of my favs. I have several templates that I had saved in O2003.
Any help is greatly appreciated.
nevermind and oops (pop up said that this one did not post)
> Everything was working fine in O2007 B2TR until I saved in the old O2003
> format and since then, O2007 opens with the old O20...Blank email?
Help! I can't read email. For some reason, when I get an
email, and I open it to read it, there's nothing there. I
know everyone is not sending me blank emails. Any ideas?
...Blank Performance report
I mentioned about the problem earlier without solution unfortunately.
I can not see full Performance Report in sbs console.
When server starting I had information that a service could not be started.
I run once again configuration connect with internet.
Now information is gone but in application log appeared this:
Event Type: Error
Event Source: ServerStatusReports
Event Category: None
Event ID: 1
Time: 11:14:30 AM
Server Status Report:
Error Message: General ...how tp print SOP Blank Options Order Form
I'M trying to print the SOP Blank Options Order Form but i keep getting the
SOP Blank Order Form where am i going wrong?
Besides doing a quick print?
> I'M trying to print the SOP Blank Options Order Form but i keep getting the
> SOP Blank Order Form where am i going wrong?
To set your SOP default to always print the SOP Blank Options Order form as
the default format, you can set this option on the Document ID setup screen
for that particular document ID.
Leslie Vail, CPA, MCT, MVP
MCBSP-Application for Microsoft Dynamics GP
MCBSP-Installa...Custom Form Problem
I am not an expert at all, but have created a custom Task form using
OL 2007 (we use exchange 2003 too).
I have created a form that basically has a tab called "review sheet".
We assign tasks around our small office, and everyone signs off on a
particular line on the review sheet as they complete steps.
I created the form, saved it to the Organizational Forms Library.
Then, I went around to everyone's computer, and in the Forms Manager,
copied it from the Org Library to everyone's task folder under their
personal mail box. To create a new task, highlight our tasks folder,
t...changing font color for new text
i have column of information. the font color is currently black. When i
update the date within the column, i want just the cells i've updated to show
in a different font color. How can i do this?
Try this, Dan:
"DanDavis" <DanDavis@discussions.microsoft.com> wrote in message
> i have column of information. the font color is currently black. When i
> update the date within the colum...Unable to install 2000 Publisher upgrade on new computer
I have a new computer with office xp professional, but
the publisher application that came with xp does not have
the same functionality of the office 2000 professional
publisher that i created most of my publications with. I
can not get the "2000 upgrade" that I purchased to
install on my new computer. It says that there is not a
valid product to update. Is there some way around this?
Do you have any old Microsoft product disks that you can install? Works, Excel,
Access, PowerPoint, Lotus 1-2-3, Microsoft Project or Word.
Publisher 2002 is superior to 2000. What features ...Deleting blank records when aform is closed or a button is click.
We are have a somewhat of an annoying problem with one of our database forms.
Everytime we open the form it creates a new record, even if you close the
form or cancelled it. We are trying to figure out a way to not create a blank
record in our database everytime the form is opened. I tried:
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "Invoice Database Launch", acNormal
but the blank record is still showing up. So, is there a way to tell access
not to create a record if the form is close or the cancel button is clicked.
"Ayo&qu...E-Mail Addresses to New Computer..?
Hi.., how does one transfer e-mail addresses from one laptop computer to a
new laptop. I'm using Outlook Express on both..!! Thanks..!!
Mike Harding, you wrote on Sat, 10 Mar 2007 17:08:08 GMT:
> Hi.., how does one transfer e-mail addresses from one laptop computer to a
> new laptop. I'm using Outlook Express on both..!! Thanks..!!
Search for a *.wab (it's your addressbook) file on the old computer.
Copy it on your new one and import the addressbook:
File | Import | Addressbook
Mike Harding <rest...Faster way to fill down, when blanks in rows exist
Is there possibly a faster way to fill down (e.g., drag a formula from
row 1 to fill all the way through row 33,000) , when there are blanks
in the rows throughout the data.
It takes forever to drag it down to the bottom of row 33,000.
Is there a better way to accomplish this?
Thanks for any suggestions.
You are dragging your formula down *over your data* thus replacing it?
Rick (MVP - Excel)
"Mike C" <email@example.com> wrote in message
> Is there possibly a faster way to fill down (e.g., ...outlook 2007 does not open
I downloaded the trial version of outlook 2007. I had the previous version
outlook on my computer. I run windows xp on a dell. When I click on the
for outlook it opens for a moment then the windows disappear. Outlook 2007
seems to be accessible through other programs, but I cannot get it to open by
itself. I have run the repair
wizard on all both outlook programs and I even reinstalled the previous
outlook version from the disc that came with my computer. I can't seem to
fine that version on my computer at all. I use Firefox as my browser and
outlook...If formula current/expired/blank
I'm using this formula to return a 'current' or 'expired' value depending on
the date in column B (expiry after one year). Because I want to autofill
rows that don't yet have data, I require some extra criteria so that no value
is returned if B is still blank. Comprehend??
=IF((TODAY()-B4>365), "EXPIRED", "CURRENT")
It may be a bit clumsy, so comments on this base formula would also be
> I'm using this formula to return a 'current' or 'expired' value depending=
> the date in column B (...Synching main form ->subform1->subform2
I have a Main form displaying two subforms where subform1->>subform2. I do
this using a nonstandard link field in the main form per recent directions
from this group. The current() method of subform1 sets the link field and
subform2 syncs itself accordingly.
This works ok except in one case: when arriving on a Main record for which
subform1 is empty, evidently the current() method of subform1 does not fire
and therefore subform2 does not change to empty as well.
I have been unable to fix this, probably because I'm still unsure of the
event stream. Does anybody have any sugges...Insert a new page into a document, but from a template
I have created a front page template for my reports. I have also created a
template that I will be using for pages
is there anyway I can keep inserting new pages to my report using this
template? Anytime I want to insert a new page, my only option is to add a
blank page only!
Create a two page template that includes the cover page and one of the
remaining pages. If the elements included in the "template" are just
header/footer-type content, you can enable "Different first page," create
the conte...Finding blank cells
I want to find the first and second blank cells in a column and return both
their values as variables I can then program with. Anyone know how? I got as
If ActiveSheet.UsedRange.Count < 2 Then
MsgBox Columns("A:A").Find(What:="", LookAt:=xlWhole).Row
which returns just the first blank cell but as a messagebox.
Any help much appreciated
A way that works if there are actually two blank cells...
Dim rOne As Range
Dim rTwo As Range
Dim rng As Ra...a brand new query tool is out on beta, we need feedback, so you get a free copy #3
We at Nob Hill Software are working on a new query tool:
You can read all about it on the above web page, but basically, its a
very ambitious project to create what we call 'the query tool to end
all query tools': everything you ever wanted, desired, dreamed about
in a query tool, and then some.
For that, we need people who will download it, use it, tell us what
they think, what's good and what's not, and what they would like to
see in the future. This program has been going on since winter 2009,
and so far we've m...bitblt in a new cdc
Hi, its not a hard question im sure, but i have very little experience
working with graphics other than directx.. so its probably better to ask you
So what im doing right now (and it isnt working) looks something like:
dcTemp.BitBlt(from an image);
dcMySystemDC.BitBlt(from dcTemp); // just doing this to test if it was
copied to dcTemp
Nothing ever gets copied to my window. This works no problem if i copy it
straight to dcMySystemDC, but i need to do some operations that i don't want
the user to see.
Any suggestions? Do you g...How do I provide new sample spreadsheets to office online
I searched for a sample worksheet, could not find it, created my own, and
would like to share with with the community so that someone else can use it
to (and in case I need it in the future, it will be there-or someone will
improve it and it will be even better).
Here is a link to the Microsoft Office Online Templates page. On the
left-hand side you'll see a 'Community' section, with links to Submit a
Template and other helpful links.
I searched for a sample worksheet, could...Zeros if cell is blank
I would like to be able to select a portion of my spread sheet and then have
a macro that would search every cell in the selected area: if the cell is
blank I would want a ZERO to be placed in that cell but if the cell contains
a number/text that cell would be left as is.
You can record a macro when you do this:
Select the range
Edit|Goto (or hit F5 or ctrl-g)|Special|check blanks|ok
and ctrl-enter to fill all those empty (really empty) cells with 0's.
Or you could record a macro when you:
select the range
what: (leave blank)
Either o...new thing to me
dear all . i went to a website to remove the spamming and they asking me to
make the following e-mail acceptable on my server here is the e-mail
postmaster@[My Domain's IP]
this is my server's ip
how can i add it??
What version of Exchange?
"Tony Zabaneh" <firstname.lastname@example.org> wrote in message
> dear all . i went to a website to remove the spamming and they asking me
> make the following e-mail acceptable on my server here ...