recognize the cell
I have a workbook named Ever and a worksheet called Ton, like this:
Row/Column A B C D E F
1 Me 1 Abc 1.2 Etc
2 You 2 Def 1.4
3 2Me 3 Klm 1.3
4 2You 2 Opp 1.3
1. I’m wondering if it’s possible to write a code in VB that recognize the
cell the user are pointing/clicking at (with the mouse) no matter were in the
worksheet the user is pointing and mark the hole row?
2. If 1. is possible can a input...set a default value for a cell ?
I want to set a default value to a cell or set of cells which might be edited
by the user?
I have a column which is used by a person to enter values. But A default
value should appear.
Could you please help me?
see help on data validation or debra degliesh's page
"Jeethu" <Jeethu@discussions.microsoft.com> wrote in message
>I want to set a default value to a cell or set of cells which might be
> by the user?
> I have a column which is used by...View Excel Cells in Color
When a fill with a color an excel cell, the screen didnt show me the color
ive apply to cell. I have to click the preliminary presentation icon to see
the color i ve applyed. Is this an excell error? Why should i do to fix it?
The first thing I'd suggest is posting your question in the Excel newsgroup
instead of Publisher.
MVP Microsoft [Publisher]
"andres torres via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in
> When a fill with a color an excel cell, the screen didnt show me th...Tally chart cells exist in Excel!??
Hello I was wondering if for example there exists a way in which yo
have a cell which u put a line like ║ to represent "1" so fo
example if you have 5 of those lines in a cell, i want the cell besid
to display the number "5".
Is this possible, if so can anyone explain me how to do it
Thanks for your time
From John Woo
Neo1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3032
View this thread: http://www.excelforum.com/showthread.php?threadid=50618
H...VLookUp and DropDown List in the same cell
I know that this is possible but I'm not sure how to accomplish this.
In column E, I have a list of zip code.
In column I, I have the "Priority" category.
Priority will be based on the zip code in column E. This will be
accomplished by VLookUp formula, where I will have a separate sheet store all
the zip codes and the priorities (ie. Priority #1, Priority #2 and so on).
The challenge part is that column I "Priority" column needs to be able to
use as a Drop Down List as well, in case that the VLookUp formula needs to be
overridden for so...formatting cells to show time format
I wonder if you can help me with the following. I use
Office 97 Professional, and Excel 97 to do the following.
I have created a spreadsheet that will be used to
calculate times & results for Car Rallies. I have sorted
out the formatting of the cells so they show hours,
minutes, seconds, and down to thousands of a second,
using this time format hh:mm:ss.000. I have done the
formulas to work out the elapsed times and then total
times, by taking the finish time from the start time etc,
then adding elapsed times together to get total times.
The thing I am trying to sort out is wh...Combine cell totals from 5 sheets into summary in Excel
"milor" <email@example.com> wrote in message
...linking colored cell
I have a worksheet(A) with data linked to a second one(B); when I forma
any (A) cell with a selected color, I would like to transmit the ne
cell color to the linked one in (B); suggestions will be welcome
Gerbatin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1523
View this thread: http://www.excelforum.com/showthread.php?threadid=26867
Cannot be done unless Condtional Formatting is used on both cells to produce
OR VBA code.
Gord Dibben Excel MVP
On Tue, 12 Oct 2...sum cells
I am trying to total employee schedule so some cell have D/O day off, R/O
requested off, so when I try to total all associates by the day I get #VALUE!
in cell and total cell. Is there a way to total only numbers and ignore
Why not fix the formula that causes the error in the first place?
What is the formula that does this:
>when I try to total all associates by the day I get #VALUE!
"SteveD" <SteveD@discussions.microsoft.com> wrote in message
news:7D8BF85A-F76E-4F35-95AC-50B77B128304@microsoft.com....Typing in multiple row in a single cell
Is there a way to divide a cell in multiple rows?
I am not talking about the insert the Text Box or table.
The cell it self should be able to take text in multiple rows.
for example to type
Three rows in one cell
Then press Alt+Enter at each point you want to create a new row.
As an aside, entering data in this format is not the most useful way to
Very often, you want to pull out the City separate form other things, for
It would be better to store your data in separate ce...Edit Cell Contents
I want to hit F2 to edit a cells contents and keep what was on the
> I want to hit F2 to edit a cells contents and keep what was on the
Good for you! You should.
No dave, when you copy something and then hit F2 to enter a cell and
paste it it is not there. I guess the potential workaround is to hit
ctrl + C twice it brings up the contents of the clipboard and all is
not lost, however this still makes me reach for the mouse which I try
to avoid doing. So dave do you have anyother workaround other than
Ctrl + c twice?
davegb wr...Drag Formula cell to decrement the cells #2
I do thank you for your prompt assistance.
The solution you gave me works fine but with limited No. of cell
is there a way to do it in an unlimited No. of cells (e.g. 50 or 6
cells - BI till DP to be the mirror of A till BH )
Asher Zur's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1610
View this thread: http://www.excelforum.com/showthread.php?threadid=27554
Sure, just follow instructions as before and in BI1 put =A1 and copy across to
DP...Sheet name as cell value
Is there a formula, or "dynamic" method of taking the sheet name an
putting it as a value in the same sheet.
If the sheet name changes, the cell then updates with the new name.
Jon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=317
View this thread: http://www.excelforum.com/showthread.php?threadid=27051
"Jon" <Jon.1eds5z@excelforum-nospam....Sort Cells/Columns
I have three lists of items (numbering about 150) on a single sheet using
columns A, D & G.
I need to sort these in alphabetical order continuous across all three
columns. All I get at the moment is each column individually sorted, which
is no good to me.
Can anyone help?
Give us an example with 3 rows of 3 columns before and after the sort.
Bernard V Liengme
remove caps from email
"Ed O'Brien" <firstname.lastname@example.org> wrote in message
>I have t...Reference cell error
When I use the following formula, I get #REF error.
How can I fix it?
=SUM('Daily Sworn Status'!M8)
probably a misspelling of the sheet name
> When I use the following formula, I get #REF error.
> How can I fix it?
> Thank you
> =SUM('Daily Sworn Status'!M8)
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.ph...referencing a cell determined by name in another cell
How do I reference a cell within a formula based on the contents of another
For example if one cell contained a reference/address for a column array,
how could I refer to this cell (and hence the column array) within the
vlookup function instead of having to put in the actual table array. In
other words an external way of changing the table array rather than going
into the formula.
use INDIRECT for this
"ricardo wants answers" <ricardo wants
answers@discussion...combining cell entries
I remember having read a simple formula for combining the entries in
cells (be it text or numbers), so that the result shows in another
Example: cell A1 has Lotus and cell A2 has 123 The formula placed in
let us say cell C5 delivers me : Lotus123
It was very simple but i cannot find it anywhere
Use the concatenation operator:
=A1 & A2
another: use the Concatenation Function:
In article <email@example.com>,
> I remember having read a simple formula for combining ...How do I show info only in cells used
IF(X15="paid","",IF((TODAY()-C10)<14, "Overdue", "PAID"))
I have used the formula above to show if an invoice is out of date/unpaid,
however I have dragged the formula down into cells that are currently empty
and they are showing Overdue... How do I make these cells appear blank until
the cells have inf. in them.
I am not clear on your rules here. Clearly, If X15 says paid, then there is
nothing to output, but is C10 a due date? If so you will get Overdue when
the date is in the future, which seems perverse. This seems a better fit to
=IF(X1...Angled borders/text and filling in empty cells
Two quick questions:
1. If you've got a cell formatted with "angled" text
(say the orientation is 45 degrees) and you put a side
border on that cell, the border also angles. If you want
the cell above it, which may or may not have text in it,
to have/match the "angled" border like the one below it,
how do you do that?
2. If you have a cell range, say A1:G10 with some empty
cells and some with data in them, is there a way to fill
just the empty cells of that range with a * (or anything
for that matter) easily?
1. You can use the ...adjust cell width change font.
I'm doing a copy and paste of cell values, my question is, when I paste the
values into the cells, how do I get them to be all the same font, and some
of the cells are text string, so how do I have te cells adjust for width?
Currently I've got
For Each x In Range("c1:c100")
If Not IsEmpty(x) Then
Set rngFind = .Find(z)
If Not rngFind Is Nothing Then
x.Offset(0, 7) = rngFind.Offset(0, 1).Value
x.Offset(0, 8).Value = rngFind.Offset(0, 3).Value
x.Offset(0, 9).Value = rngF...Two formulas in one cell?
Is it possible to have two formulas in one cell? For example, here's what
I'm trying to do:
If cell A1 has the word HORSE in it, I want the formula in A2 to be x + z
If cell A1 has the word PIG in it, I want the formula in A2 to be x * z
Anyone know if that's possible?
If the lower upper case does not matter
if it matters
=IF(ISNUMBER(FIND("HORSE",A1)),x+z,IF(ISNUMBER(F...Is there a cell format for HEX numbers?
Is there a way to format cells for HEX numbers? I currently have to format
them as text. I would like to be able to automatically increment in HEX, as I
can with general numbers or dates. Is this possible without writing a macro?
>Is there a way to format cells for HEX numbers? I currently have to format
>them as text. I would like to be able to automatically increment in HEX, as I
>can with general numbers or dates. Is this possible without writing a macro?
To display a decimal number as hex use:
[ ] = DEC2HEX(A1,n)
If it...conditional formatting based on the value of another cell
I want to apply a conditional format to a cell based on the value of another
cell having nothing to do with the value of the cell I want the format to
effect. for example - if the value in cell m5<0 i want cell a5 to be italic
(regardless of the value in a5)
You need to use the CF/ Formula Is ... option, rather than CF/ Cell Value Is
then you can use Formula Is =M5<0
"bwilde" <firstname.lastname@example.org> wrote in message
>I want to apply a conditional format to...How do i get a formula for word recognition in cells
I am trying to create a worsheet that is linked to another(I know how to
link) but I am having difficulties as I can only link to set cells. i am
looking for a formula that will recognise the word and send it to the
specific spreed sheet.For example I have 435 items in one column but instead
of putting the items in selected cells I want the formula to pick up on the
word (THAT HAS BEEN RANDOMLY LISTED IN THE COLUMN) and sends it to the
specified sheet? I hope that does not sound confusing and someone can help
A formula cannot change the value of another...date doesn't get entered in cell
I give up, why is the "inputDate" variable not getting put in the "v5"
In "a4" cell the "f_FnameLname" variable is getting entered just fine.
Also, is there a way to format the date so that in the dialog box the
user will have to enter a date?
Public Sub SingleMonths()
'months macro rewritten
'used for a single patient sheet to be printed
Dim inputDate As Date
Dim i As Long
inputDate = InputBox("Enter a date:", "Date", Date)
'requires date input from the user in a dialog box
For i = 2 To Worksheets.Count...