Clearing contents beyond the "Z" column
Mon, 15 Feb 2010 10:42:24 -0800 (PST)
Hello,
Below is the code I am using for a button on my sheet.
All works well, but it is not clearing the contents of the new row
beyond column "Z". If I make the k value larger (instead of 1 to 25, I
put 1 to 37 as I want it till column AN) then I get an error and
beyond column "Z" no contents are cleared i ...
|
MOVE or COPY not Functioned..
Mon, 15 Feb 2010 09:59:17 -0800 (PST)
I have two excel worksheets in one workbook. I tried to move one
worksheet, to another opened workbook.
usually we find another workbook in the menu when we tried to move..
instead i'm seeing only this workbook and new workbook options..
how to enable to see another workbook...? ...
|
How to format in a cell that has both text and a formula
Mon, 15 Feb 2010 09:23:08 -0800
I have a cell with this formula
="James Cedric V. Sebua ("& ((TODAY()-B14)/365) & ")"
The display is this
James Cedric V. Sebua (5.55890410958904)
And I want it to be this:
James Cedric V. Sebua (5)
Thanks
Dave ...
|
Conditional Formatting
Mon, 15 Feb 2010 08:13:52 -0800
I have a date field (birthdates) in column B
In column A I do math on that date field to arrive at age
(Today()-C3)/365) - (Not very accurate but works for my needs)
I would like Column A to be conditionally formatted based on the Date (month
and day) in Column B.
I want the text to turn RED if we are approac ...
|
Open HTML file in VBA using workbooks.open
Mon, 15 Feb 2010 06:04:45 -0800 (PST)
If I open an html file from VBA, for example.:-
Set WB = Workbooks.Open(sFullFile, 0, True) ' 0=do not updatelinks,
true=readonly
a new workbook opens with the html file in it as expected, but some
text is automatically converted to date format.
For example 03-4703 becomes 01/03/4703 or 03-Mar.
Can I open ...
|
How do I display an empty cell and calculate on it
Mon, 15 Feb 2010 05:48:01 -0800
I am using a reference on one sheet to fill the values in another. If a cell
has not value it I want it to be blank. But I also what it to be used in a
calculation when it is populated.
I have tried nothing, but it enters a 0, I have tried
=IF(Data!C2>0,Data!C2,""), =IF(Data!C2>0,Data!C2,null),
=IF(Data ...
|
Excel 2007 Filtering Options
Mon, 15 Feb 2010 04:07:02 -0800
I am running Excel 2007 and when i filter a list and then highlight the
filtered results to cut and paste into another application, it also paste's
the hidden information from the filtered list, so i am getting everything
instead of just the filtered results.
Does anyone know if there is a setting i need to s ...
|
|
|
refer to a range / block of data on the same sheet
Mon, 15 Feb 2010 09:40:04 -0000
Hi all
I wonder if someone could please help me solve this issue, i have done
examples files to help someone look at this issue
***********************************************************************
Example files :
2003
http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xls
2007
http://www.b ...
|
Work at Home- Earn $4,000 Weekly With Email Reading Jobs
Sun, 14 Feb 2010 23:19:45 -0800 (PST)
Work at Home- Earn $4,000 Weekly With Email Reading Jobs
Get Paid $5 For Each New Sign Ups - Easy To make Money
Make More Than $200 A Day , Register Now To Start earning At
http://moourl.com/lvi7k ...
|
Conditional Formatting formula (one cell matching another with tex
Sun, 14 Feb 2010 14:19:01 -0800
I NEED A FORMULA TO DO THIS:
IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7("DAYS") OR
H7("HALF")
MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN
D18 WILL TURN RED ...
|
