|
|
Automatic removal of rows by
Peter
/ Hi,
If I have worksheet where I want to delete all the rows that have (say) 0 in column C is there an automatic / formula way to do it. I've tried filter and...
|
|
1 |
196 |
|
|
|
August 4th, 2004 02:43 PM
by Dave O
|
2 |
316 |
|
|
Comments by
felix
Is it possible to copy a value in a cell and add it as a
comment? How would such a macro look like? Preferably the
comment box should be resized to just reveal...
|
|
4 |
208 |
|
|
Counting cells based on color by
djm
I am looking for a "counting" formula that will count cells in a range
based on their color, so that if I color a series of dates (to show
'vacation) the...
|
|
1 |
364 |
|
|
Reversed-out text by
Wendall Oakes
I would like to use the "reversed-out" text.
However when I change my background color to blue "example" and I
print, the background will print dark or in...
|
|
1 |
95 |
|
|
Excel 2003 Maps by
A Zolna
I have recently upgraded from Office 2000 to office 2003.
I have Excel worksheets containing VBA macros which maps create maps from the data. These worked fine...
|
|
2 |
631 |
|
|
Validation by
Denise
I have a workbook that is used by multiple people. There are 5 cells where times are entered. There seems to be a problem that people can't enter the right...
|
|
1 |
81 |
|
|
worksheetfunction by
nyn04
I try to use the following
CountPosS = WorksheetFunction.CountIf(TradesDiff, "0")
and I get an error messege type mismatch when I run
CountPosS =...
|
|
1 |
136 |
|
|
Opening a unicode CSV file from Excel by
Chris Williamson
Hi,
I'm currently working on an application that can export data in "CSV"
format, and then launches Excel to view the CSV data. This works
perfectly ok for...
|
|
1 |
267 |
|
|
Automatic creation of Hyperlinks by
Zunaid
Hi there
Wondering if someone has a macro which scans through all cells in all
worksheets and if it finds a cell which has the same value of one of
the sheet...
|
|
1 |
74 |
|
|
|
|
1 |
337 |
|
|
calculating dates by
jimzybray
i work at a tow company and have to calculate dates and charges a lot of times.i wiould like to have excel do it in a spread sheet.for instance
date in ...
|
|
2 |
97 |
|
|
|
|
16 |
866 |
|
|
Conditional sum by
Deepwater
I am looking for a formula that will add cells based on
condition. Ex. If i have ten cells with different values
(130, 131, 143, 142, 144,130,...
|
|
7 |
136 |
|
|
override a cell by
shlomop
The whole column A begin with SP, and I wont to add different numbers
on each row after the SP. how do I do that with out I should have to go
in to each...
|
August 4th, 2004 05:53 PM
by shlomop
|
3 |
127 |
|
|
make 2 cell in once by
yoem
in cell a1 john in cell b1 smith, i want to have in cell c1 both names
how do i make it?
---
Message posted from http://www.ExcelForum.com/
|
August 4th, 2004 06:01 PM
by JulieD
|
1 |
237 |
|
|
Syntax error text in VBA by
R Ormerod
Why are the following lines of code not highlighted (in red) to indicate a syntax error when they are clearly...
|
|
4 |
434 |
|
|
Validation - Another ? by
Denise
Can you put more than one validation in a cell?
Here are my column headings:
Arrived Triaged Registraion To ED Saw MD Discharged
I want a...
|
August 4th, 2004 06:12 PM
by Alan
|
3 |
84 |
|
|
making 2 cell in one by
yoem
in A1 it says John 1n B1 it says Smith, how can i poot both wards in c1
with a space
---
Message posted from http://www.ExcelForum.com/
|
|
2 |
158 |
|
|
Workbooks do not open by
Ewest
When I double click any Excel Workbook Icon, only Excel
opens.
The workbook is not loaded.
The only way I can open up workbooks is though the File -
Open...
|
August 4th, 2004 06:21 PM
by
|
3 |
120 |