Map characters to their relative positions in a cell
I've been using an Excel 2003 macro to loop through text cells in a
spreadsheet that is sent to me from another office. My macro loops until
column H (formatted as text) is empty; that is ="" (equal to a null string).
It's been worked just fine until recently when the macro seems to end
prematurely. It returns a normal end but clearly there are additional rows
yet to be processed.
The row that causes the macro to finish prematurely always contains many
clearly visible character comments, sometimes 5-6,000 characters in length.
My hunch is that one or more...IDD identifier range
Is there a predefined range of dialog resource identifiers or can one
use any value from 0 to 65535?
If a more specific range exists, is it a MFC implied restriction?
>Is there a predefined range of dialog resource identifiers or can one
>use any value from 0 to 65535?
>If a more specific range exists, is it a MFC implied restriction?
It's an MFC restriction, see "TN020: ID Naming and Numbering
Conventions" in your MSDN documentation.
MVP VC++ FAQ: http://www.mvps.org/vcfaq
>It's an MFC restriction, see "TN020: ID Naming ...How to copy a cell to another sheet having more than 255 characte.
It is copying only first 255 character.. How to resolve this problem to copy
entire cell content
...Sort by Categories in Task
Is there a way to sort the Task list by Categories. When
we click on the column for Categories it says that you
can't but is there a work around? I know that the Group
By feature works, but the user would like to sort.
...Sheet name from cell
Is it possible to assign the sheet a name which is entered in a cell.
I know how to do this with VBA but would like to know if this is
possibile with the help of formula.
Row: A1 has name (Bill). I want that second sheet in the workbook
should have the name entered in row A1.
It can't be done without VBA.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
(email address is on the web site)
"navin" <email@example.com> wrote in message
Can you help with this formula to enter in MS query? Using ODBC t
connect to data source but need query data to be restricted to dat
range shown in two cells given on worksheet. Eg. A1 = 01/04/04 and A2
Query should only return records with dates 01-20/04/04
Message posted from http://www.ExcelForum.com
...Condition Format #1
I have enclosed a chart with this explanation below. I am needing
automate this chart according to the following rules.
See chart also, if necessary. Thank you.
Whenever, a 3 digit numeric combination is entered into B, C and D
cells and if each of the 3 digits are different (ie.3,7,2), then find
the 3 cells on the same row between O and BG that have the
corresponding boxed the 2 digit pairs. (O=01, P=02, Q=03, R=04, S=05,
T=06, U=07, V=08, W=09, X=12, Y=13, Z=14, AA=15, AB=16, AC=17, AD=18,
AE=19, AF=23, AG=24, AH=25, AI=26, AJ=27, AK=28, AL=29, AM=34, AN=35,
AO=36, AP=37, AQ=38, AR=39...Cells to columns
Easy I know, but i just can't get.
I have a list of names, A1:A100, and i want these to run across the
top of my sheet as column titles. i.e. A1:CV1
can any one help.
Select B1 (can't use A1)
Delete column A if you don't need it.
> Easy I know, but i just can't get.
> I have a list of names, A1:A100, and i want these to run across the
> top of my sheet as column titles. i.e. A1:CV1
> can any one help.
> ...I want to copy a cell (A) to another cell. But, only if I peg (A)
(A) is not a valid cell reference.
What does "peg (A)" mean.
Use the large piece of white space in the body part of your message to fill in
some descriptions please.
Gord Dibben MS Excel MVP
On Thu, 1 May 2008 14:10:11 -0700, Rv <Rv@discussions.microsoft.com> wrote:
...How to count Number of cells holding a particular value.
In my table there are 3 columns. Each cell in the last column holds
either 1 or 0. I want to get the sum of the cells of the last column
on top of the column name. I used the sum function to do this and
works fine. But my requirement is to get the sum of the cells in the
last column when i Filter using 1st and 2nd columns. e.g. Filter using
the first column would give 10 rows from 30 rows. I need the sum of
the cells of the third row only for those 10 rows.
How can I achieve this using functions?
Thank You in advance.
Use SUBTOTAL(9, range)
____________________________...What formula will take a name in one cell (last name,first name) .
I have a name in a cell, last name first then a comma then first name, and I
want to seperate them into two cells. I know there is a formula to do that,
but I don't know what it is, can anyone help me?
Use the menu option Data:Test To Columns to parse the one field into two fields
> I have a name in a cell, last name first then a comma then first name, and I
> want to seperate them into two cells. I know there is a formula to do that,
> but I don't know what it is, can anyone help me?
You could use Data > Text to colum...Calculation to replace the cell contents
Sorry to ask such basic questions but I only use Excel once a year for end
of term marks.
I have a column with results /82 eg; 56, 27, 49 (all out of 82)
I want to convert the mark to /20 (out of 20) and for the results to replace
the marks out of /82.
So the formula should be mark/82 x 20 = mark out of 20
Could sm tell me apply this formula so that Excel will recalculate the
column for me?
Thanks in advance
You want to scale numbers in place:
1. in an un-used cell enter =20/82
2. copy this cell
3. select all the cells in the column you wish to re-scale
...split color in cell...
A user just asked me if she could put a diagonal line in a
cell, and then color the upper block one color, and the
lower block another.
The diagonal line is easy enough... format-cells-border
and add the line.
is it possible to split the background color in a cell???
(not that i've heard of, but sometimes things that I
haven't heard of are possible)
AFAIK not possible
interesting user request you get :-)
> A user just asked me if she could put a diagonal line in a
> cell, and then color the upper block one color,...Pasting conditional cell formatting onto other cells
Suppose you have a matrix of cells, say in C11:D12 for simplicity, upon
which you have imposed a conditional formatting scheme, so that, for
example, cell C11 is shaded yellow and D12 is shaded cyan. Also suppose that
the matrix in C11:D12 was derived from a matrix in A1:B2. Is there a simple
way to impose the shading in the C11:D12 matrix onto the matrix in A1:B2,
even though the conditional formatting imposed on C11:D12 is not applicable
Example: Here is C11:D12:
We impose on this matrix the conditional formatting scheme that all values
between 0.50 an...Maximum number of pcs connected to access
I need to know hoy many simultaneous pc's connected to an access
client/server MDB can it be?
Can access 2003 handle 50+ connections?
How about access 2007?
Thanx a lot!
I've had 53 connections to a well-designed Access 2000 format Jet database.
Most were actively editing the 105+ MB database. It also depends upon record
structure and quality of the network. I know of a database in Texas with 75
concurrent users. Officially Access/Jet can handle 255 users, but I believe
that's pushing it. If you original spec call for 50 + users, you might
Not sure if this is the easiest way to do this but I am wanting to create a series of cells
Is there an easy method of doing this perhaps with a Format function or will I have to create a sum to work out the
last cell plus .0.1?
Any help is appreciated.
Give this a try in any starting cell, eg in A1:
"@Homeonthe...Identifying the Active Fill Color
I have a routine that adds a shape to a selected cell and I would like
to have the color of that shape be the last selected "fill" color (or
the default fill color if no change made since Excel was started). How
can I determine the active fill color from the "Fill Color" toolbar
using VBA? Seems like there should be a way to get that color value.
No one having answered this so far I thought I'd have a go..
I couldn't find anything in the object model to look at for this, but that's
because I don't have an extensive excel object model to loo...cells that have dates
I have a spreadsheet with dates in several columns
I need to know if a date in column H is past the date in column D and if it
is, format the date is column H to color RED
Let's say you have a date in H1 and you want to check it against the
date in D1.
1. Select H1
2. Go to Format Menu, Conditional Formatting
3. Select "Formula Is" and type =$H$1>$D$1
4. Hit "Format" button, Patterns tab and choose an appropriate color
5. Hit OK twice
Now whenever you enter a date in H1 that is later than the date in D1,
H1 will turn whatever color you specified.
On No...Testing cell value for greater than 0
The value in a cell is derived from a formula and can be one of the
I need TRUE to be returned when the cell value is greater than 0. This
test fails as an error is returned when the cell value is an error How
do I fix this?
Thanks in advance for all the help.
"Raj" <firstname.lastname@example.org> wrote:
> I need TRUE to be returned when the cell value
> is greater than 0. This test fails as an error
> is returned when the cell value is an error How
> do I fix this?
=IF(ISNUMBER(A1), A1>0, FALSE)
...Transfering information to the next free cell in a column
I'm trying to set up a worksheets to track the spending of two people by
amount and category. Since it's the shared expenses of two people I'm trying
to keep track of who each purchase was made by (so a person 1 total, person 2
Is there a way for an expense that is in a certain category to be transfered
to the next available cell in a column?
I set it up by making one sheet for input and one to display the
information. The input having columns for person/category/amount and the
display showing columns for categories and each person's total...Locking cells
Is it possible to lock and unlock cells on one sheet based on certain
criteria in a certain cell on another sheet ?
If you are prepared to use VBA
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Duplatt" <Duplatt@discussions.microsoft.com> wrote in message
> Is it possible to lock and unlock cells on one sheet based on certain
> criteria in a certain cell on another sheet ?
I would like to try, with your assistance.
My goal is to Lock cells $B...use VLookup to copy more than 1 cell
I have been using VLookup in Excel 2003 for some time but I would like to
expand the VLookup results. Instead of just copying one cell to paste as the
result of the formula, can I have VLookup copy and paste a series of cells
from same row of the found item?
Thanks and have a great day!!! :)
You can change the result of the VLOOKUP function by changing the 3rd
arguement in the function, which determines which column from the table to
If you want to copy and paste this and have it adapt/change, u...Cell flashing
Does anyone know how to format a cell so it will flash or blink ?
It's possible to do so with code but its a bad idea, you'll find such (bad)
code by searching Google.
There is no built in function like Word in Excel and if you do use such code
the results are usually jumpy and erratic, plus the processor is unavailable
to do anything else until the code is stopped from running, ie the machine
is virtually locked up,
"Skioregon" <Skioregon@discussions.microsoft.com> wrote in message
> D...Report: Account Numbers and Phone Numbers?
My wife had a brief scare this morning; she thought she lost her
wallet which had all her credit cards, etc. She soon found it but
that got us to talking about the need to keep a readily-accessible
list of credit card account and phone numbers in case they should
indeed ever get lost.
Since account numbers and contact info are already contained in Money,
I looked for a report or a screen that lists this information.
However I could not find one. Does such a single-screen report exist,
or does no other option exist in Money for finding this information
but to click into each account one at a...Go to cell #
Is there a way to force a worksheet to always open in cell A1 regardless of
what cell was active when the worksheet was saved. Sometimes different
people save this worksheet with the cursor resting in different places, so
it's annoying when it opens in some odd blank area. Any help on this is
You need to write a macro basically
Private Sub Workbook_Open()
This needs to be put in the ThisWorkbook object of the VBA Editor for your
If this helps, pl...