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...Finding intersection point in rows and columns
I am trying to work a macro which will do the work for me (go figure).
Here is the easy example. I have a worksheet which has a 3 columns an
a bunch of rows: the column headings are " ", "total", "add-on"
the rows then consist of "mike","1,000","200"... then next ro
I would like a different worksheet to have a macro button that ca
take the data and put it into a new table and stuff.
I was thinking along the lines of creating labels on the top and left
and then referencing the ...help me set up a Event Macros
i am looking to use more than 3 colors in my spreadsheet
i can do the conditional formatting for 3 colors but need help
to use 5 colors.
I am new to this so please tell me how to do this
Message posted from http://www.ExcelForum.com
You could use a worksheet_change event:
rightclick on the worksheet tab that should have this behavior. Select View
code and paste this in the code window.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myColor As Long
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("a:a")) I...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?
...I need a Macro that will open workbooks and run a different Macro.
Is there a way for a macro to open all workbooks in a folder and then run
I have the 'other macro' written already, I just need a macro that will open
200 spreadsheets - (they are not in the same folder but I can move them if
needed, they are in the same directory) - , one at a time, then run my
macro, then save each spreadsheet.
I've asked a similar question of this forum (specifically dealing with txt
files - thank you Jim Cone.) and I've tried to modify that Macro so it will
open *.xls files but I can get it to work.
Any help with this will...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 <firstname.lastname@example.org> 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...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...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 | ...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...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 ...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...how can i get %. like 100+85+75+96=89.0%
I want the pecentage like 100+85+75+96=89.0%
Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 enter =SUM(B2:E2)/4. If you want it displayed as %,
devide by a further 100, format cell as percentage, 1 decimal point -
=SUM(B2:E2)/400, or =(100+85+75+96)/400, or else enter the values as
percentages 1, 0.85, 0.75 and 0.96, and then devide by 4 at the end
"Elvis Perez" wrote:
> I want the pecentage like 100+85+75+96=89.0%
Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 ...can IF leave a cell EMPTY ??
I'm attempting some simple (to me at least) data analysis and am running
into trouble with zero values in the data array (region). These zero
values (null string: "", actually) represent non-existant data that I'd
like the chart to ignore, but as the array actually contains formulas
the chart engine does not see an empty cell.
Is it possible to use IF to cause a cell to appear Empty (ie,
IsBlank(cell) == True) ?
Something like: " = if (condition, reference, Empty) "
My raw data consists of date shipped and date recieved; I have created
an array (Mon, Tue...The email@example.com account... how can I check these messages?
When I look in the exchange queue there are a few messages going to the
postmaster account. Some of them would be helpful too see... how can I
check these messages?
>When I look in the exchange queue there are a few messages going to the
>postmaster account. Some of them would be helpful too see... how can I
>check these messages?
If they're going *to* your postmster account you shouldn't see them in
any outbound queue. You might see outbound NDR's (or other DSN's) in
the outbound queu...restrict Distribution Groups so no everyone can send to them
How can I restrict a group so everyone can't send to it?
I have distribution groups, All Employees, for example, that we want to
limit the people who can send to it, so only 10 managers can send to it for
Where would I address this?
AD Users & Computers | Distribution Group -> properties | Exchange General
tab | select "Only from:" and add recipients who can send to the group.
MVP - Exchange
NEW blog location:
"Bryce" <firstname.lastname@example.org> wr...