|
|
Verify if Comment exist in a cell by
Tom LeBold
How do you verify if a comment exist in each cell in a worksheet using VBA
code.
The following VBA code works for a verifying comments in a range:...
|
|
2 |
166 |
|
|
Auto populate fields by
Mark
I have a form that asks for Name, Job Title, Employee ID number, etc. I can
create a drop down list using Validate no problem. However, I want to be able
to...
|
|
1 |
99 |
|
|
|
|
1 |
171 |
|
|
|
|
0 |
102 |
|
|
numbers to dates by
montana hogs
New excel user. I am trying to type a part #09-02 in a cell. When I enter It
automatically turns to Sept.2. Please Help. Thanks.
|
|
3 |
99 |
|
|
Assigning values to a Validation Menu by
AlwaysAAngel
I'm trying to do this thing on Excel where I have a list of values that
are being summed at the bottom of the page. Thats not a problem. The
problem I'm...
|
|
1 |
102 |
|
|
Automatic Shading of Cells by
kmmh
Isn't there a way to have Excel automatically color the cell for you based on
the equation. For example, if the variance is less than 5%, I need to the
cell to...
|
September 15th, 2005 08:04 PM
by Mark
|
1 |
88 |
|
|
Blank cell after evaluation by
JC
I am using the formula, =IF(ISNUMBER(Analysis!O6),Analysis!O6," ") but have a
problem. If there is a value in Analysis!O6 then the file works...
|
|
2 |
88 |
|
|
Vertical Scroll Bar not responding by
bruner
I have a workbook that is shared. When the user logs in she can see the data
on screen fine. However, when she tries to scroll down, the view does...
|
|
4 |
98 |
|
|
xls header all sheets by
BullvBear
How do I apply a header and footer in excel to all of the sheets in the
workbook without manualy retyping them into each sheet?
|
September 15th, 2005 07:54 PM
by Paul B
|
1 |
100 |
|
|
select by color by
Kristin N
How can I select specific cells that have been colorized. Once selected I
want to move these to a different column.
|
|
1 |
88 |
|
|
|
September 15th, 2005 07:51 PM
by Gilescis
|
6 |
512 |
|
|
Why can't I see all the text in a cell? by
woody
I am entering text into a cell. It is a rather large string of sentences. I
can not view the entire content of the cell unless I strike F2 to edit. I
have...
|
|
3 |
96 |
|
|
|
|
4 |
95 |
|
|
|
September 15th, 2005 07:29 PM
by Themis
|
4 |
121 |
|
|
Pivot table column duplicates by
Kerry
I have a simple pivot table referencing three columns of data: store name,
item number, quantity sold. When I convert this to a pivot table, showing
store...
|
|
3 |
141 |
|
|
This almost works, but... by
Mr. Smiley
Please review the code below. It works. The only probelm is instead of
printing out the value of each cell, one line at a time, I wondered if anyone
knew how...
|
|
2 |
104 |
|
|
|
|
1 |
129 |
|
|
|
|
1 |
103 |
|
|
|
|
1 |
92 |