Can I use "find / replace" to automatically "Insert Rows" in a do.
Have a long column of numbers
Every time I see the number 5, I need to insert two rows. Doing this by
hand is tedious. Can you help me find a shortcut?
The IF function does not do this, right?
Not 25, 35, 5351, just plain old 5?
Dim FirstRow As Long
Dim LastRow As Long
Dim iRow As Long
FirstRow = 1
LastRow = .Cells(.Rows.Count, "C").End(xlUp).Row
For iRow = LastRow To FirstRow Step -1
If .Cells(iRow, "C").Value = 5 Then
...Outlook and message rules- can't get one to work?
I have set up message rules to divert mail from my inbox to various sub
folders or new folders. I use these:-
Check messages when they arrive\ from people or distribution list \ with
specific words in the senders address \ with specific words in the subject or
Now the problem is that some of the messages are recieved from people in my
address book and when they send a message sometimes their name and address is
in the 'from' and other times it is just their name and so the ones with just
their name do not get moved across to the folder I want. I have added their
name or...Disaster Recovery Test Documentation
We are using Dynamics CRM 4.0.
I am looking for documentation on how to do a Disaster Recovery test, while
keeping the Live/Production environment intact.
We have our Live/Production environment that is actively used. In our DR,
we have a second installation of CRM, using a differnet OU, accounts, and SQL
We would like to test our DR functionality without impacting our
Live/Production environment. The test would involve copying the data from
Live/Production to DR and having a user test the functionality and confirm
data is properly restored.
Anybody have any documentation...Can I make my Contacts Folder my Default
Does anyone know if I can make my contact folder the default folder rather
than the Global Address List?
On 3/8/2010 7:36 PM, Wendy wrote:
> Does anyone know if I can make my contact folder the default folder rather
> than the Global Address List?
Ctrl-Shift-B (or just click the Address Book icon)
Tools -> Options
Leonid S. Knyshov
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
...How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.
One option is to select the area to be printed on each sheet and go to
File>Print Area>Set Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.
...Can't repair CRM
When I try to repair CRM on a few laptops, I get the following message:
Setup failed to locate binary file microsoft.crm.metadatahelper.dll verify
that the source folder is configured with Everyone Read Access.
I am trying to do a repair off the original CRM CD.
Any ideas why this is happening?
...Where is Read All Unread Mail ?
Using Outlook 2003, had to re-create my profile due to corruption. And now
I no longer have a Folder title to display ALL UNREAD MAIL. Does this need
to be created somehow, so that it will display all unread mail spread out in
all the folders?
if the folder is not in the search folders, right click on Search Folders
and choose New. Its one of the predefined options.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by...Can't find outlook archive.pst
I'm constantly getting "can't find Outlook archive.pst"
error message when I launch Outlook XP. Does anyone know
how to get rid of this error message?
Richard <email@example.com> wrote:
> I'm constantly getting "can't find Outlook archive.pst"
> error message when I launch Outlook XP. Does anyone know
> how to get rid of this error message?
Either create an Archive PST or disable archiving (Tools>Options>Other)
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...Can a user's Worlplace be defaulted to a standard one
Is it possible to set a standard Workplace that users will see based on
either their role or team?
We have a client who wants to set standard worplaces for respective
Ian Watson had a good method--
"simply click on Workplace bar, then just above click on "personalize
Workplace" then tick on or off what you need"
This could also be done through changing the security role to allow
certain privaleges. You cant change a system security role, you have
to copy it and rename it. Settings | Security Roles | highlight the
role you want to copy | ...97: How can I find duplicate entries in a column?
Hello and thanks in advance for any help. This is a very basic question
from an even more basic user. I have a spread sheet with a long list of
ID numbers for skips. Sometimes duplicate numbers arise from paper work
from elsewhere and I get a false total of skips in hand. How can I
organise that column to highlight a duplicate entry please?
Message posted from http://www.ExcelForum.com/
Insert a helper column:
(adjust the range to suit.)
then the formulas that evaluate to more than 1 will be duplicated.
Chip Pearson has some other techniques at:
http://ww...whihc microsoft office can i use to determine loan amortization
I am looking for programs wherein I can determine loan amortization
"Justin Reyes" <JustinReyes@discussions.microsoft.com> wrote in message
|I am looking for programs wherein I can determine loan amortization
You need Excel, not Access
remove nothing for valid email address.
...Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
"JCC" <JCC@discussions.microsoft.com> wrote in message
news:9CAD1748-1D5C...How to 1. Jump to a specific page (in a massive document) based on a search then 2. Copy and paste an string of characters a few lines above it.
I am working from a very large word document, approximately 1000 pages
long. Each page has one 'article' on it.
I am currently doing something manually, which I would love to do
using a macro.
I am populating a table (which happens to be in an Excel spreadsheet)
One column is the Article number 'xxxxx'. One of the other columns is
a 'Topic' which is typically three alphanumeric characters (like AA1,
AD4, BB4 DO6 etc.)
This is what i have to do
Step 1 - Jump to the page with the article number. Achieved by
p...I have to re setup word?
I'did have problems with my computer, I inserted the Fix disk and know he's
asking me to re setup Word, excel.......
I put in the original CD and still he can not recognise my.
"Microsoft office word is not installed for the this user- set up word to
I tryed also with the C:\ drive, but still gives me the same error.
Hope someone can give me a usefull solution.
Thanks in Advance
You will probably have to run Windows as an Administrator for the setup to
Microsoft Word MVP
"Ann" <Ann@discussio...Chart turns gray.. can anyone help
Hi, I am working with a large file.. but not as big as
others. This one has a few charts. When I add another
it starts acting weird... turning totally gray unless I
click on it...? its it the fact that its not embedded or
not in front or in back of the worksheet? Thanks for any
helpful ideas on correcting this.
Go to Options on the Tools menu, click on the View tab, and under
Objects, select View All.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Steve Kay wrote:
> Hi, I am working with a large file.. but ...EndNot Web plug-in prevents closing MS Word 2007
When I try to close MS Word2007 I get an EndNoteWeb error message "an
unknown error occured" and after clicking the ok button, the Word stops
responding and restarts the program. This means that the Word is always
running in the computer.
MS diagnostics does not detect any probelms in the Word.
Any advice how to fix the problem?
Thanks in advance
Sorry, but you've been misdirected to the group for Word for Macintosh...
You can find the Win Office groups here:
Good Luck |...Can't link a graphic?
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Email Client: pop
I've been told on this forums several times that one cannot have a graphic with live link in your email signature. <br>
Still, I've recently received a few email with small buttons that link to facebook and myspace in Entourage. How are these folks achieving this? thanks.
> Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power
> PC Email Client: pop I've been told on this forums several times that
> one cannot ha...In POwer POint 2003 can I gradually add text in the same slide?
I want to gradually add text in my presentation within the same slide. For
ex: The beginning of an equation and click the mouse to complete the equation
as I explain it.
Read the instruction here:
Bart: "According to creationism, there were no cavemen."
Homer: "Well good riddance, their drawings sucked and they all looked like
"PP HELP" <PP HELP@discussions.microsoft.com> wrote in message
> I want to gradually add text in ...Can not see Public Folders in OWA after upgrading Front-End Server
We just performed an in-place upgrade of one of our Exchange front-end
servers. Everything was upgraded successfully, but now our users are getting
the following error when launching OWA and trying to access their folder list
as Public Folders are not showing: Microsoft Internet Explorer / An internal
server error occurred. If you click OK, it will let you continue working,
but you can not access Public Folders. Has anyone seen this type of issue
and if so, how can we correct it? THANKS!
...forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view.
All the tables, queries, and macros are there.
When I open up the database to add data, all the forms are there and can be
used. The data is stored. So, it seems that the forms are still there, but
just cannot be seen in design view.
The database, when I open it up in design view, says Access 2000 file object
even though I am using Access 2003 - could that be the problem?
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...How many recordset can be opened simultaneously for a MS-Access 2000 Database for adding /editing records
Can someone please suggest how many recordset can be opened
simultaneously for a MS-Access 2000 for adding /editing records.
I also want a comparison with MSDE for the same.
> Hey Friends
> Can someone please suggest how many recordset can be opened
> simultaneously for a MS-Access 2000 for adding /editing records.
> I also want a comparison with MSDE for the same.
Uhm... If I remember correctly that would be max. 20 connections.
Successive CRecordset::Open(...) requests would fail.
I don't know this parameter for MSDE. There's a limit in...can't move chart to new worksheet
I am creating a an embedded chart and then move it to another worksheet that
would contain all my charts.
After I create the chart I want to move it to another sheet. here is my code:
ActiveWindow.Visible = False
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlMaximized
ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)",
It gives me an...Document Status Problem After GP9 Upgrade
Last week we upgraded from GP8 to GP9. Everything seemed to be going well
until today when we tried to run a Cross-reference by source document report.
None of our payables checks are shown in this list. I went into SmartList
and it shows all of our check transactions as Document Status = Work which
means they have not posted, but we have not changed our process from GP8.
Are we missing something that changed in the upgrade?
I verified it is not a report issue, if I pull the same report for dates
before the upgrade it is correct but everything after the upgrade is shown as
not post...How do I set up Auto complete for common words
I am new to outlook 2007. in outlook 2003 i had many words, such as regards,
yours faithfully, etc that would auto complete when i started typing them. in
2007 i can not seem to get this working.
Any help would be appreciated.