I have a spreadsheet that has 250 rows, I have to add a blank row after
every fifth row, is there a formula to apply to my spreadsheet. Manually is
quite a hassle.
Thank you, all
counter = 6
Do Until Cells(counter, "a") = ""
counter = counter + 6
Microsoft MVP Excel
"israel" <firstname.lastname@example.org> wrote in message
> I have a spread...Can I create a macro in Outlook 2007?
I started to get 3000 to 4000 spam a day. I set up a rule marked it
priority, etc, made it first on the list and it does not run. I have to run
it manually . I thought if I could make a macro, make a button on the
toolbar, then click instead of going through al the 'rulles and alerts"
clicks to run the rule. ANy thoughts?
I see macro but only runs ones that are already created. If I create a macro
in Word or Excel, it does not have "rules and alerts" in it so I can't
create it. I tried help, but there is no info , just blocking, etc of macros
What...Excel Template #3
In Excel 2000, after saving a new spreadsheet as XLT type,
opening that file again doesn't create a new file but the
Please let me know what I'm missing.
Did you perhaps open it from the MRU list from the <File> menu ?
If you saved it correctly (choose template in the "Save As Type" box of the
"Save AS" window) then you must open it from <File> <New> <General> tab, in
order to have a COPY opened, and not the original.
The MRU list will point to the original in the Templates folder and open the
original....Stop REMOVING previous features
before IE7 you allowed collapsed, heirarchical folders in the Add to
favorites function; then in IE7, in your typical anti-user anti-wisdom, you
now, in IE8, you have somehow decided NOT to keep the previous folder
reference... instead you ALWAYS display the top level... so if I'm doing a
search and saving URL's for the same topic, I have to waste considerable
time, ONCE AGAIN finding and selecting the folder I want...
Who makes these user interface decisions anyway... JEESH... why I hate
This post is a suggestion for ...Can I add Java Data types in Microsoft Visio?
I want to design a UML diagram of a java application.
Can i add Java data types in Microsoft Visio 2003?
...What happened to Help/"Send Feedback on Entourage (Word, Excel.)?
One of the lovely features of Office 2004 used to be (past tense) being able
to go under the Help pulldown menu on any sub-program (Entourage, Word,
Excel) and click on "Send Feedback on__________ (name of Office 2004
sub-program on which you wish to submit feedback)."
The website page that now comes up makes it more cumbersome to send a Mac
product suggestion to Microsoft via the Help/Send Feedback route. Clicking
on that pulldown menu item takes you to:
I made the mistake of clicking on "Select a Product" at the top of th...add days and shade help
i would like to add 90 days to a date and have it stay green, and trun red on
the 80th day can this be done.
thanks this works/////
> You can use conditional formatting to achieve your goal. If you have the
> original date in A1, and in B1 you have a formula =A1+90, then onditionally
> format B1. Iso Cell Value is, use Formula Is, and insert the following
> formula: =TODAY()<A1+80
> Click on Format, select Patterns, choose Red, and OK out. Set the Cell
> Background to Green, and it will remian green till 80 days af...2007 Not Ready for Prime Time
Just a quick note that, IMHO, Excel 2007 is not ready for normal usage, particularly on XP (where it behaves oddly, e.g., fails to
open up XLS files when you double-click them; it works better in Vista).
But the biggest problem is that Excel 2007 interoperates very poorly with previous versions of Excel. I have some moderately large
2007 models (e.g., about 1MB on disk), and when I try to Save As to downrev them so that users of earlier versions of Excel can
access them, it takes bloody darn forever. In fact, I don't know how long it takes because I've yet to actually let it finish (a...XP can't open Excel file created on win98se
I create an excel file using XL97sr2 running under win98se
and email it to my wife.
She is running XP-home(using a limited acct) and gets
the following XL97sr2 error message when trying to open
(In a MS Visual Basic window)
Permission to use object denied
[hitting Help shows error 419]
I don't know if this is relevant but, Tools-Options is
greyed out on the XL menu.
Other friends with XP and XL(I don't know the versions)
have no trouble opening it.
What are we doing wrong and how do I fix it?
Does the error also say "End" and "D...add attribute to businessunit
is there ANY way to add a custom attribute to the entity businessunit? i
don't even have to show it on the main form. i only have to store some
thanks in advance,
For all I know, normally the answer to your question would be NO. But since
you've put ANY in capitals i'm going to give you a really really UNSUPPORTED
way to accomplish what you want (not taking any responsibility for any
consequences of this customization!!!).
Maybe there's someone else who knows a good way to do this.
So this is what you could do if you decide...How excel can prepare automatically sales book
I prepared a template of invoice for my company only just for pre printed
invoice printing. Can it be possible that from invoice what product we sold
that can entered in sales book for the current month with detailed tax
information and product name and number with cost.
If possible that How can it be?
Thanks in advance.
Rao Ratan Singh
...outlook says i am organiser but i am not (ol 2007 sp2)
Someone made an meeting requets with me as a member
He changes the request and i want to delete the old request but its says
that i cannot delete the reqeust because i am the organizer
...I cannot add subproject
I'm using Project Server 2007 Enterprise Edt. with Project Pro 2007. I
create and publish 2 or 3 projects. i want to create Master Project. When i
add Subproject from Project Server, screen is flash but Project do nothing. I
cannot add a subproject.
Anyone see this problem before?
I am afraid you have to be a bit more specific.
Are you trying to insert a (sub)project into another (master)project?
In Project, open the Masterproject and choose Insert Project.
Should work, never failed me....
"Özcan ELMALI" ...Add up contents of column, if nothing in that column add up contents of other column
I'll try to explain this dilemma in simple terms:
| beer | beer |
| gin | beer |
| beer | |
| beer | gin |
| gin | |
| water | gin |
Basically, say I want to have a total of what was drunk most recently -
so it will look in november, add up whats there, but if there is
nothing in that column it will look down october and use whatever value
is in that column,
Thus I should get the following results:
Beer = 3
Gin = 3
Message posted from http://ww...Excel application keeps growing
I have a rather robust excel document with macros. When the applicatio
was first created it was about 5 Mb. Over time it has grown to about 1
Mb. There have been updates to the macros but not 9Mb worth. It seem
like even when I delete worksheets and sections of macro's the siz
doesn't get any smaller.
Is there a way to release unused space with excel.
cparsons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1286
View this thread: http://www.exc...Cannot add new account Money 2005
When trying to add an account I get the message that I must be online to
pick it from the list.
I am online, signed in.
If I add the account by using the not on the list dialog I still cannot take
advantage of the account downloads.
I get the same result if I go back and try to set up online services later
Any ideas ?
I just started getting the same thing. In fact I can't get any on-line
updates at all with Money 2005. I have no problem with any other internet
This morning I finally started getting bank and credit card updates after a
month or more of ...Excel Opens 2 files, I only created one?
I have been working on a spreadsheet for the past 6 months with no
issues. The file size is 3.66mb, Excel 2000, Windows 2000. Everytime
I open the file "abc" I get two Excel files open named "abc:1" and
Does anyone have any idea why this is and what I can do to rectify it?
All other files open OK.
Thanks in advance.
You get these by clicking on: Window > New Window
To get rid of excess windows, click on "Close Window" (that's the cross in
the top-right of the screen underneath the "Close" cross).
Andy W...need to use the PerformAddItem fireevent within a VB6 add-in?
I have an add-in that brings up a userform in RMS - the userform prompts the
user to select some options, and then based on what they selected for
options, it populates a combobox with certain itemlookupcodes. this part
works fine so far. the combobox populates with the correct data just as it's
supposed to. now what i need to do is take whatever itemlookup code the
user has selected in the combobox, and add that as a new entry to the
transaction when they press ok on the userform. this is what i have right
now for my command button click event:
Private Sub cmdOK_Click()
If c...Add new line in a cell
I must be suffering from oldtimerers disease but I can't remember how to
to add a new line inside a cell.
I have tried various combinations of alt, shift, ctrl, enter but I can't
Did you try alt-enter?
(Remember to toggle the wraptext setting: Format|cells|alignment tab)
> I must be suffering from oldtimerers disease but I can't remember how to
> to add a new line inside a cell.
> I have tried various combinations of alt, shift, ctrl, enter but I can't
> get it.
Dave Peterson wrote:...Managing an Access Database from Excel
I am trying to manage an Access 2000 database from Excel 2000. My intention
is to enter Excel data into the "Test" table of Access. The table has been
created and is visible. The online documentation is incomplete because of
the installation and I cannot find what is wrong.
Dim Acc As Object, RS As Object, DB As Object
Set Acc = CreateObject("Access.Application.9")
On Error Resume Next
On Error GoTo 0
Set DB = Acc.currentDB
One of our employees has been getting a message that I have never seen
before, and after doing a Google search I have come up with no results
whatsoever. The error message is:
The system you are saving to does not have enough memory to remove
personal information from file properties. All personal information
may not be removed
The computer has 2 GB of RAM and Windows controlled page file, running
Windows XP. It does it when saving a particular file and as far as he
says, no other files.
I also noticed a few minutes ago that he was moving some cells around
in a single file, the ce...How do I add a total to a stacked bar graph in Excel
I am using Excel for some graphs in Powerpoint and we are using stacked bar
graphs. Does anyone know how to add a total on a stcaked graph? I can add
individual values but I am looking for total per bar.
the simplest way is to copy the data with the totals into the chart.
select the section of the bar equal to the totals and change the axis to
add the series values and in paterns select none for fill and line. in th
elegehgend select the line for the totals and clar all.
"Greg L" wrote:
> I am using Excel for some graphs in Powerpoint and we are using stacked bar...CAN WORKS READ EXCEL
Can Microsoft Works import an Excel Work Sheet.
I do not care about preserving formulas.
I don't think so. But the Excel Viewer can.
Hope it helps!
"Louis Miller" <email@example.com> wrote in message
> Can Microsoft Works import an Excel Work Sheet.
> I do not care about preserving formulas.
In Microsoft Works, choose File > Open
From the Files of Type dropdown, choose Excel SS (.xl*)
Selec...Solver Add-In for Excel
Where can I download the Solver Add-In?
"cram" <firstname.lastname@example.org> wrote in message
> Where can I download the Solver Add-In?
With Excel 2003 it's on the cd: Tools - Add-Ins then select the Solver
you can't download it. It should be on your installation CDs
> Where can I download the Solver Add-In?
With all versions of Excel it is on the CD. You can purchase an
enhanced version at
J...Excel Slow after print setup??
Hello I am using Excel 2003. When I open a spread sheet I can d
anything at a very quick response. But, as soon as I go into prin
setup and update ANYTHING in the print setup - then excel becomes ver
slow. Anyone have any ideas whats going on here
cbecker's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2586
View this thread: http://www.excelforum.com/showthread.php?threadid=39249
Possibly a few thoughts.
Save your file(s), shut-down and re-boot. Better?
Have you be...