Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
group : microsoft.public.excel      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



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 ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us