Entries in range that meet simple condition
I know this must be simple. But I simply cannot find information as
to what I really want to do. We are talking about a VBA macro.
I have single column range. (It is non-contiguous, 5 block of 10
rows. I'm not sure it matters.) I would like to search that range
for entries where the offset(0,1) contains a value of 500 or greater.
This for finding scouts that have sold $500+. I would like the
results returned as a range or an array.
Ultimately what will happen is that the results lookup will be
transposed to a two-columnar form created by BSA. That range will be
propagated by scrol...Detecting cell fill color
Is there a function, or some VBA code that will detect
that a user has applied a fill color to a cell? I want to
reference a cell, and with a =IF function, apply a
calculation to colored cells.
There isn't anything that comes with Excel.
However, have a look at this site for processing of coloured cells.
"Tony Rice" wrote:
> Is there a function, or some VBA code that will detect
> that a user has applied a fill color to a cell? I want to
> reference a cell, and with a =IF function, apply a
&...Counting Cells with Multiple Range Criteria (Excel 2003)
I'm trying to count the number of rows that matches multiple criteria in
multiple ranges. As an example, I want to count the number of rows where
both Column A and Column B have a date between 01-01-05 and 12-31-05. Where:
Column A Column B
So, in this instance, I want it to count only row 1 because both columns
match the criteria.
I've tried a couple of different Countif statements, but I can never get it
to count using the multiple criteria and ranges. Please a...return different values based on 4 criteria?
Need Formula or macro to allocate the "Scheduled hours" based on Group Counts:
If Group "A" and "C" are both greater than 1, then Scheduled "A" and "C"
should both be 6 hours
If Group "A" and "C" are equal to or less than 0, then Scheduled "A" and "C"
should both be 0 hours
If Group "A" greater than 1, and Group "C" is equal to 0, then Scheduled "A"
should 12 hours
If Group "C" greater than 1, and Group "A" is equal to 0, then Schedule...How I can combine cells of different pages?
I mean how can I add, divide, mutliply, and so on figures of different cells
for example, add a figure of the cell f4 of the page 1 with the cell g5 of
the page 2.
When you say page 1 & page 2 I assume you mean sheet 1 & sheet 2. You can
apply mathematic functions for a cell using different sheets but you have to
name the source i.e. =A1+Sheet2!A1. An easy way to do this is begin your
formula on sheet 1 = A1+ and then go to the cell in the sheet where it
resides, click on the cell and click on your active sheet. Excel will
automatically place the name reference of the cell...Data base Adventure Works
I have installed the CRM 3.0 in Portuguese, but I don´t have data base.
It exist this data base of "Adventure Works" in form of archive where I can
There's information in the Implementation Guide regarding installation of
the sample database "Adventure Works Cycle". See this url for the information:
Hope this helps,
Ronald Lemmen - MSCRM MVP
"Leandro Ruviere&q...If Conditioned Macro
Does anybody know if I can run a macro from inside an if
condition, such as if((A1 + B1)< 50, run macro)? Any help
or suggestions would be greatly appreciated.
no you can't. What you can do is use an event procedure. See:
> Does anybody know if I can run a macro from inside an if
> condition, such as if((A1 + B1)< 50, run macro)? Any help
> or suggestions would be greatly appreciated.
Ok. Thanks Frank!
>-----Original M...How do I get more than 1 Text Watermark on the page?
Please help me!!!!
I need lots of Text Watermarks to appear throughout the page.
Noeleen Conlon <Noeleen Conlon@discussions.microsoft.com> was very
recently heard to utter:
> I need lots of Text Watermarks to appear throughout the page.
Copy and paste?
Ed Bennett - MVP Microsoft Publisher
...Calculate cell reference
I have the following lookup which is working exactly the way I want:
The problem is, I need it to change it's lookup based on user input. If the
user types 2 in a certain cell I need this lookup to change to:
If the user types 3, it needs to change to:
I can calculate the cell numbers easily enough:
Which will give me the cell I need to reference, B10...How do I scan and insert into Outlook 2007?
I want to insert a scanned directly into OL7. It does not seem to be an
option in the insert menu to scan.
A scanned what?
State what you want to do in clear terms.
"John Hayden" <JohnHayden@discussions.microsoft.com> wrote in message
>I want to insert a scanned directly into OL7. It does not seem to be an
> option in the insert menu to scan.
John Hayden wrote:
> I want to insert a scanned directly into OL7. It does not seem to be an
> option in the insert menu to ...unable to change data in cell(s)
This file has about 20 sheets.
I have picked the first sheet, then did cntr and choose every other sheet.
I was able to type a location address in the first sheet, and it did appear
on all the other sheets in the corresponding cell. These cells were initially
When I tried to do the same with a cell that read "physician name" it would
not work. I would type in "smith" and enter, but it would revert back to
I checked the formating of the cells.
They are all set on general
They are all unlocked (the file is password protected)
HOW DO YOU FLIP THE TEXT FOR AN IRON ON TRANSFER TO PRINT CORRECTLY
Can your printer do a mirror image?
Might try WordArt.
Select the text box, copy, paste special as a .wmf, flip...
Mary Sauer MSFT MVP
"MIA" <MIA@discussions.microsoft.com> wrote in message
> HOW DO YOU FLIP THE TEXT FOR AN IRON ON TRANSFER TO PRINT CORRECTLY
On Fri, 10 Feb 2006 18:06:28 +0000, MIA wrote
(in article <EA27CE71-2642-4A76-850C-6EBE2AC31BB1@mi...Auto Generate text field
I have a from that users can inout ingredients for recipes. I want the user
to pick an ingredient from a drop down(which is already working). I also have
a field that has an item number. I want the item number to auto generate base
on the ingredient selected from the drop down.
You have an item number field already and you want to generate another one?
Also, if a new item number is generated every time a user selects an
ingredient it's going to make that item number field useless.
Or is your question how to populate a textbox with the already assigned item
number for ...http status code text message
How do you get a text version message that you can display to a user? For
example if it returns 404 "Not found." Etc.
I'm not gonna code a giant switch for this, there's gotta be something in
wininet or mfc that translates these into a message?
...Conditional formatting #4
Is it possible to use a table of results to determine the formatting results
in conditional formatting?
I am wanting to use more than the allowed 3 conditions to format a series of
Say for instance I wanted the cell to format if the conditions were :
and so forth
The list I have has 10 conditions in it and would like to use all 10 but as
I am only allowed to use 3 I am struggling.
Any help is appreciated.
Here is one I sent in response to a similar post. Modify to suit
right click on sheet tab>view code>insert this>SAVE
Private Sub Works...How do I to stop attachments turning to text?! Outlook2000 SR1
I am using microsoft outlook 2000 SR1.
It has suddenly started turning all attachments
it sends into text!
Anyone know how to stop it?
Someone said something about "MIME" but I cant
see any options that mention MIME...
PS They tend to arrive in multiple parts too...
"Shiperton Henethe" <firstname.lastname@example.org> wrote in message
> I am using microsoft outlook 2000 SR1.
> It has suddenly started turning all attachments
> it sends into text!
>...Merging Cells adding Carriage Returns
I've been sent a text file to import that contains (amongst othe
These addresses are split over 5 cells and I want to merge them al
into one cell per address so I used :-
This worked great, but turned the address into a sinlge line. I reall
want to add carriage returns at the end of each line to make it mor
Any ideas please?
Message posted from http://www.ExcelForum.com
> This worked great, but turned the address into a sin...How to set default cell formattiing to vertical alignment = top ??
How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default
format for all new worksheets ?
Thanks again for your help.
Ah, the miracle of computers!... someone also said "To error is human, but
to really screw up it takes a computer!"
Take a look at "default workbook" in XL Help.
In article <563D9BF8-D599-43E6-9383-AB68FC7CBF01@microsoft.com>,
akm <email@example.com> wrote:
> How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default
> format for...Answer: How to create pop-up text on drawings saved as HTML
I know many people have asked this question, and it has been partially
answered previously. Here is a more complete explanation.
You can add the User.visEquivTitle cell to your shape and provide a string
that will display as a tooltip in the web output. The shape must also have
at least one custom property for the tooltip to be visible.
1) Select the shape in your drawing that you want to add a web tooltip for
2) Go to Window > Show Shapesheet
3) Go to Insert > Section, check User-defined cells and click OK
4) In the newly created section, click on the row name Use...Inserting XML Data Into a New Table FROM VB.NET
Can anyone help me figure out how to insert data into SQL Server when
a table to hold the data does not yet exist. I am able to insert data
into a existing table in the following fashion. But what if the table
does not exist? Appreciate any help I can get.
Private Sub InsertData()
Dim objSQLConn As New
Dim objAdapter As SqlDataAdapter
Dim objDataRow As DataRow 'Dataset row
Dim objDBRow As DataRow 'SQL Server table row
Dim objDSXML As New DataSet
Dim objDSDBTable As...Autofit problem with merged cells
I'm using excel 97 and there apears to be a bug in which
Autofit does not work on any cell that has been merged wih
a cell that is adjacent to it, the only way to make all of
the text visible is to manually resize the row. I have
found a macro that solves this problem however i would
prefer not having to run a macro each time i type in a
merged cell. Does anyone know if microsoft has a patch or
download that resolves this issue?
Most people feel that merged cells create more problems than they solve. I think maybe you've
just provided more evidence for that argument.
On Mon, 1...Is it possible to display text in charts?
I am creating graphs for results from a survey. Part of this is to graph each
individual's response to every question.
If a person did not answer a question, I would like "N/A" to appear in the
data for the chart.
I am not using formulas -- the numbers are typed directly into the
spreadsheet. Is there any way to have the text "N/A" display in the chart
data? Currently, if I enter text in the corresponding cell, it displays as
"0" in the chart data.
You can try applying a custom format to those entries that are coming across
as zero....Insert Page Numbers on Worksheet in Excel 2007
In Excel 2003, if you wanted to put page numbers on multiple worksheets in a
workbook, you grouped the worksheets and then added a header or footer, using
the page number function. All of your grouped worksheets would shows its own
But in Excel 2007, only my first worksheet is numbered when I do this (as
Page 1). What's the problem? Do I actually have to put a page number, one
by one, on each worksheet?
I cannot replicate your problem with 2007.
Grouped sheets behave exactly as 2003 did.
After grouping and adding a header of Page 1 did you do a print p...Changing text to date format
I have imported a text file to an excel sheet and the date fields have been formated as text. I have not been able to convert the cells back to date format. When I do, the data turns into ###########
Any ideas as to why this is happening and what I can do to change the data to date?
One possibility - depending on what is actually in your cells.
Copy a blank unused cell.
Select your range and Edit / Paste Special / Add
"Ron B" <firstname.lastname@example.org> wrote in message
&...Changing the cell format doesn't change existing cell content
When I import data into Excel 2003, the numbers need to be reformatted so
that they can be calculated. But when I highlight the range and reformat it
to a number format, it doesn't register the change. I have to click inside
the cell contents (hit F2) for it to 'accept' the new format. This
complicates things when there is a lot of data.
Any ideas? Thanks for any help.
This could make things faster for you. After importing the data, choose
another cell that is formatted as General or a number and enter 1 (the number
Select the cell with the 1 in it and us...