Keep black parts black??
In 2002 I used this feature for a quick duotone. Colorize the photo, leaving
black parts black and it worked great. Now in 2003, this feature is grayed
out in spot color mode. What's up??
...make colour in rows stay
How can I lock the fill colours in a row even when I change around the data
or sort alphabetically?
Thanks and God Bless,
Regards Ron de Bruin
"Crowraine" <Crowraine@discussions.microsoft.com> wrote in message news:ED158D7D-62AB-4DA8-A948-2A6556D8047C@microsoft.com...
> How can I lock the fill colours in a row even when I change around the data
> or sort alphabetically?
> Thanks and God Bless,
...One Entry to Multiple Rows
I have data that looks like this:
X1 | Y1 Y2 Y3 Y4
X2 | Y4 Y5 Y6 Y7
And I need to get to:
X1 | Y1
X1 | Y2
X1 | Y3
X1 | Y4
X2 | Y4
I can change the 2nd row's entries to more columns, but that doesn't seem to
get me much closer to the needed format (and there are thousands of lines so
I'd rather not do it manually). Any ideas?
should do it. change mc to suit
Dim mc As Long
Dim mr As Long
Dim i As Long
Dim lc As Long
mc = 3 'col c
mr = 1
For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row
lc ...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...Word 2008 keeps crashing
I recently purchased a Macbook Pro and installed Office 2008. Whenever I type in Word or copy/paste from another document, I either get an error that says "Insufficient memory" or the application freezes and will not respond. Is there something I can do or just have to wait for an update?
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 2/7/08 10:37 AM, in article ee8c846.-1@web...exchange 5.5 will not keep new server name.
We have exchange 5.5 in enviroment where windows server
2003 is setup along with active directory and active
direcitory intergrated zone which is replicated to other
Problem: I enter the Exchange Server Name followed by
the mailbox name then I select the button [CHECK NAME]
In the exchange server name field after entering the new
exchange server name the old exchange server name is
displayed instead. This only happens in office 2003
professional and not in office 2000 professional
"old exchange server name"
How did you go about changing the name of the server...Create individual files from a row
I have an excel file with several thousand entries, which contain data
in several columns. I would like to be able to create an individual
xml or html file for each row, but with predifined formatting around
Mr A bloggs, A street, A town, AA1 1AA
Could become Abloggs.html
<name>Mr A bloggs</name>
Any other info here as well
etc. Is this possible and any suggestions how?
GrahamN's Profile: ...Determine number of rows with data
I am using the macro below to pull some data from an external workbook.
The 2 issues I need to sort are:
1. The number of rows in the external workbook can vary. How do I amend this
code to pull all of the rows with data?
2. The number of rows in the autofill also may vary. How do I autofill only
the number of rows required? i.e the number of rows in column A that contain
'Lookup Previous Month Sales
Selection.NumberFormat = "General"
Selection.FormulaArray = _
"=S...how to insert borders on flyer within Microsoft publisher?
Please help, I'm trying to insert a border around a flyer...I'm using
Is it a clipart border, Borderart or a simple rectangle? What problems are you
having? What version Publisher? Any border you insert should be sent to the back
so it does not interfere with your main design.
Mary Sauer MSFT MVP
"Harriet" <Harriet@discussions.microsoft.com> wrote in message
> Please help, I'm ...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...how do I keep email messages online and also go to outlook
When I open outlook my email messages go to outlook and if I am away from
home can no longer open my yahoo mail account or att mail acount and see my
messages because then downloaded into my outlook. Is there a way to have the
move ot outlook, but not leave my online account?
Set Outlook to leave messages on the server for the accounts in question.
"jann" <firstname.lastname@example.org> wrote in message
> When I open outlook my email messages go to outlook and if I am away from
&...underline in row not repeating
It seems as if my bottom of the cell outline is not repeating on subsequent
pages. I have a few header rows on a sheet. The bottom row has a bottom
line. I'm talking about cell outlines, not underlining of words in the cell.
Anyway, I've told the print option to repeat the first 3 rows on following
pages but the bottom outline does not seem to repeat. How can I fix this?
Never mind. This seems to be working. Not sure what was going on the first
"Keith G Hicks" <email@example.com> wrote in message
>...How to unhide Excel rows after they are automatily hidden
Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm
San Francisco, USA
(Excel Add-ins / Excel Programming)
wrote in message
...Altering the range that is plotted by a chart via VBA
Good morning all.
I haven't really done a huge amount on charting, so I'm sure you'll think
that these questions are a bit simplistic, but here goes!
I plot a chart from a worksheet that contains three columns of data - the X
axis contains week numbers, and is in B29:B54. Actual hours are entered in
F29:F24 and cumualtive hours in G29:G24. The cumulative formula is of the
So, each week, in order to plot another week's data, I have to copy this
cumulative formula down by one cell, which, considering I have a lot of these
reports, is a bit time cons...Equation Numbers, inserting field
I have a list of equations in a word document that I need to add a reference
(the first equation in the document will be equation A, the second will be
equation B, etc. When I get to equation 27 it needs to be AA, then 28 will
be AB...) next to. However, I will be adding other equations randomly
throughout the document and referring to the equation reference in text
paragraphs. I would like to have both the equation reference and the text
paragraphs to update if I add an equation to the middle of the document. I
know I should use a field code and cross reference it in the tex...Conditional formatting a date range
If I have a column of dates that are manual entered what is the formula to
conditionally format them based on a date range of three months before the
current date to the current date and another three months after the current
date to the current date?
Assume the dates are in column A, starting with A1. Highlight all the
dates, with A1 as the active cell, and click on Format | Conditional
Formatting. In the dialogue box you should select Formula Is rather
than Cell Value Is and then enter this formula:
Click on the Format button and choose the ...Want to modify this procedure to have a range of periods rather than a single period
This is a multi-part message in MIME format.
I have the procedure below
I want simply modify the periods procedure below to be -- perpost >=3D =
'201001' and <=3D '201012' so I want a range of periods rather than a =
single period as in the example below
I would really appreciate it if someone can help me out on this.
Declare @perpost nvarchar(8)
/* Do not edit Above=20
...How do I keep Outlook from downloading messages with attachments?
I use Outlook with dial-up and I'm trying to generate a rule that notifies me
of large (>1MB) attachments before it begins downloading them. However, all
rules by default seem to apply "after message arrives," i.e. when it's too
late. Any suggestions?
OL rules apply after download.
Use web access for your ISP to view mail, or mailwasher eg
Whether your ISP has any rules/options may be an option.
"DRRALF" <DRRALF@discussions.microsoft.com> wrote in message
> I use Outlook with dial-up and I...Help with Highlighting all duplicates in a row
I am trying to highlight duplicates in a row and am using the explanation:
Highlighting Duplicate Entries
Our first task is to highlight the cells in Range1 that are duplicates. We
use Excel's Conditional
Formatting tool to accomplish this. First, highlight the entire Range1.
Then, select the
Conditional Formatting tool from the Format menu: Format->Conditional
Change the "Cell Value Is" option to "Formula Is" and enter the following
formula in the
formula text box:
Where A5 is the first cell in Range1....Why can't I unhide rows 1 to 47 in a worksheet?
No matter what I try, I can't show the rows I hid. Please help.
Hold down the shift key and click in A48
> No matter what I try, I can't show the rows I hid. Please help.
Because you have freeze panes.
and scroll up and there you go.
> No matter what I try, I can't show the rows I hid. Please help.
"lcarr13" <firstname.lastname@example.org> wrote in message
news:9534BD16-F9BD-486F-9588-0DE35BB351AC@microso...Deleting every-other row in a spread sheet
I have a spreadsheet in excell that contains info imported from word. As a
result every-other row is blank. I would like to erase these empty rows so if
anyone knows how to go about this it would be gratefully appreciated!!
Thanks in advance
If you a familiar with VBA, you can delete the rows via code. For example,
this procedure deletes rows with empty cells in column A:
Dim lLastRow As Long
Dim Rng As Range
Application.ScreenUpdating = False
Range("A1").Value = "Temp"
....Return address of first item in a range
I'm sure there must be a simple solution for this I cannot
I am looking for a formula that will return the value of
the first item in an input range. For example, I want to
put a formula in cell A10 that will return the first item
that is input in the range Range A1:A9 (not nesessarily
the first cell). If A4=200, A7=150 and all other cells are
empty, the formula should return 200 (the first item in
Thanks for your assistance.
One way is to use the array formula (entered with Ctrl-Shift-Enter):
=INDIRECT("A"&MIN(IF(A1:A9<...how do i insert a comment in an endnote?
Been trying to do this for ages for an assignment I have. I can not work out
why I don't have the option of inserting a comment in my endnote?
On Tue, 2 Mar 2010 20:59:01 -0800, kympossible
> Been trying to do this for ages for an assignment I have. I can not =
> why I don't have the option of inserting a comment in my endnote?
Comments are not allowed in endnotes or footnotes. Neither are breaks,
page numbers, diagrams, or text boxes. I'm guessing here but it
probably has to do with the way that ...Update cell based on date range
Hey guys! I was wondering if I could get some help here. I would lik
to update a cell based on a date range. For example, I would like t
update the value of a cell to the value of another cell if the curren
date is between July 1st and July 10th. However, if the date i
outside the date range, I want the value for that cell to not b
updated, and be the previous value. Can anyone give me an example a
to how I would do this? Thanks!!
deversole's Profile: http://www.excelforum.com/member.php?action=geti...