|
|
excel sorting by
Adnerb
I have a text spreadsheet of 5,000 names and addresses. Column B needs to
restricted to only 16 characters in that column. How do I send the records
to...
|
March 28th, 2010 11:20 PM
by tompl
|
1 |
149 |
|
|
Split Windows by
dhstein
How can I split the worksheet - columns A - C in left pane and the rest in
the right pane - and freeze the left pane while allowing scrolling in the
right...
|
|
2 |
202 |
|
|
ActiveCell.FormulaR1C1 by
Rick
I need help....
The following statement is being used in a do loop.
ActiveCell.FormulaR1C1 = "=IF(" & TagNmeMe & "!RC="""",""""," & TagNmeMe & "!RC)"
What I...
|
March 28th, 2010 10:36 PM
by FSt1
|
3 |
184 |
|
|
Track Changes Colour by
bubbles
Hi
Can anyone please tell me how I change the colour that track changes
displays in in Excel 2003? Mine is currently displaying changes in Navy
which is...
|
March 28th, 2010 10:08 PM
by bubbles
|
0 |
146 |
|
|
|
|
3 |
172 |
|
|
|
March 28th, 2010 07:33 PM
by Carolyn
|
0 |
173 |
|
|
|
|
0 |
143 |
|
|
|
March 28th, 2010 05:55 PM
by dhstein
|
3 |
281 |
|
|
|
|
0 |
165 |
|
|
|
|
1 |
239 |
|
|
Why do I get VLookup error 1004 by
KenG
After defining a new Name ("_year") in my worksheet, I find that my makro
code (Private Sub cmdNewEntry744_Click()
With NewEntries
..Show
End With
End...
|
|
2 |
177 |
|
|
Making Zeros look like no entry by
DeeDeeCee
I have a spreadsheet that makes some calculation in a column, based on
multiplying numbers entered in 2 other columns. However, for some of the
rows, there...
|
March 28th, 2010 12:01 PM
by JLatham
|
5 |
215 |
|
|
help to reduce size of my file by
Ben
I have a large file that somehow has pictures in it that are not visible
(they seem to be sized down to 0) but are causeing the file to be too big.
When I...
|
March 28th, 2010 10:45 AM
by Ben
|
2 |
216 |
|
|
|
March 28th, 2010 09:44 AM
by FSt1
|
2 |
168 |
|
|
|
|
2 |
181 |
|
|
If Formula to Identify Cell by
Khalid A. Al-Otaibi[_2_]
0 Valid
0 Expired
Enrolled Valid
0 Expired
Enrolled Expired
If the Cell in Column (1) is the Word (Enrolled), the Result will be
enrolled. If not the Word...
|
|
1 |
164 |
|
|
Worksheet name variables by
ThunderBlade
I have a project that requires me to copy mutiple worksheets to one hub
worksheet. Is there a way to make the worksheet name a variable?
This is what i have...
|
|
3 |
158 |
|
|
dotted blue lines in a cell by
newto2007
I am copying an excel spreadsheet to Word. I get a bordered dotted blue line
area in a merged cell for comments and can't delete the blue lined araea. I
also...
|
|
0 |
138 |
|
|
|
March 27th, 2010 11:11 PM
by JLatham
|
1 |
192 |
|
|
selecting a cell by
Pat
I seem unable to select a single cell, or a single row--click on one in the
normal manner, and the two below also highlight, then delete or whatever
command...
|
March 27th, 2010 09:28 PM
by Mike H
|
1 |
166 |