(0.04 seconds) Articles (39890) |<First << Prev /1995 How to identify a cell [format|category|number|scientific] for sea 3 1221 (11/18/2009 10:29:02 PM) Utf I currently have a project in which I need to identify a cell if it is formatted with scientific and to ignore the data value. Similar to: If objExcel.Cells(intRow,Column).xxxxx = scientific Then Else int... How do i format this time ? 5 1556 (11/18/2009 12:37:37 PM) VICTOR Hi, i have a column with times in this format, i.e.: 433 10433 190433 which respectively mean the follwoing times: 00 h: 04 min: 33 s 01 h: 04 min: 33 s 19 h: 04 min: 33 s how can i s... Conditional formatting depending on sub string content i cell 4 1370 (11/18/2009 3:17:29 PM) Andreas Hi! This has been eluded me all afternoon, I just want to mark out cells in Excel that contains a specific sub string. I have thousands of rows all containing small text strings. I would like to mark th... simple formula formatting question 2 1242 (11/18/2009 10:24:15 PM) Cinci_Shawn Hello, My boss puts plus signs (+) in front of her cell references on financial reporting. For example: a summing formula would look like =+SUM(E10:E40) or when she adds two cells she'll precede the... How to create a "dynamic" sql code 1 1182 (11/18/2009 4:42:15 PM) andre_29 Dear all, I am trying to bring some data from ms access to ms excel and I need to create a "dynamic" sql code . I have a form in excel with 4 checkbox: so se user can select: entity, division, scenario,... extracting multiple rows of data from another worksheet 1 2770 (11/19/2009 2:30:03 AM) June I have one worksheet, full of data. In another worksheet, I would like to search through the data individuals who belong to a certain group and then extract the entire row of information for that particular in... Searching for Excel Cells with [Format|Category|Scientific] Specif 1 1247 (11/18/2009 8:23:01 PM) Utf I am currently writting a VBScript that needs to search for Cells in Excel that have been formatted in Scientific. I need to exclude these specific Cells to obtain output recommended for my project. Can som... Error Message When opening Excel 1 4739 (11/16/2009 10:27:23 PM) HankL I am using Windows VISTA 64 bit O/S with Office Professional 2003 All of a sudden I started to get the following error message: 'One of your object libraries (Stdole32.tlb) is missing or damaged. Please ... Excel 2007 stops responding 2 2254 (11/18/2009 3:40:04 PM) Utf On several machines we have an issue that Excel 2007 stops responding when we fill or drag cells or use the autosum function or change the number of decimals of a selection of cells. In the eventlog we s... Excel licence message 2 1312 (11/18/2009 10:41:26 AM) Paul Due to a system crash, I had to install Vista over my old XP, and while I've reinstalled MS Excel (2003) OK, and activated it with no problem, I still get the 'read/agree to licence' message every time I run... Macro to take to last line and insert new row with number 3 2050 (11/17/2009 5:36:06 AM) Utf Hi all, I'm looking to get a macro to take me to the last active row in column A and then insert a new row, with the next number then appearing in the first cell of the newly inserted row (for example c... Macro: Save and update/replace comments in a list - tricky task 0 1154 (11/18/2009 12:04:36 PM) Snoopy Hey guys My macro makes a list (in sheet "BOARD") of all files in a folder given as variable path. To each file my macro generates an hyperlink / "open-file funktion" as well. This file-list is placed in r... Upgrade to 2003 0 1310 (11/17/2009 11:04:07 PM) Rob Hi, I have just been upgraded to Excel 2003 at work and everytime I start Excel, I see a Book 1 file load and immediately close and then Book 2 opens and remains open. I have checked both my XLStart dir... VBA Worksheet Event Change or Selection Question, please assist me 2 1734 (11/17/2009 8:39:54 PM) Damil4real Two fantastic people were kind enough to provide me these two codes below, and now I'm trying to see if I can expand it to include other columns and data in a worksheet. Code 1: Private Sub Worksheet_Ch... Most Right Value in a Row 2 1532 (11/17/2009 2:46:31 PM) SanCarlosCyclist In another post, I was taught how to populate a cell with the last value of a column. How do I populate a cell with the last value of a selected row? I appreciate your help. ... data lookup/validation syntax 1 1812 (11/17/2009 4:14:11 PM) Doug In Excel 2007 I have a sheet "sheet1" which has a part number in a cell. (A5) I want cell (D5) to have a data validation drop down menu which is populated from "sheet2". Sheet2 data looks something like t... Quick VBA Worksheet Change Event or Selection Question: 1 1238 (11/17/2009 5:10:54 PM) Damil4real Quick VBA Worksheet Change Event or Selection Question: I have a workbook that has a sheet named "Formatted Prices". I enter data starting from row 7 & from column A to S all the way down on a daily basi... Run Routine Automatically 8 1381 (11/16/2009 7:17:55 PM) sswilcox I've searched previous threads and have not found a solution. Cell H40 contains the results of a calculation. If the value of H40 is greater than 0.05 (5%), I want a message box to pop up to warn the user.... Chart of Times 3 1319 (11/16/2009 6:48:33 PM) Jim I am working with a simple data set comprised of two columns and 24 rows. In column ("A"), I have the numbers 1-24. In column B, I have these random times: 4:57 5:16 2:17 1:20 1:11 1:21 1:19 1:1... ActiveDocument.Variables / ActiveWorkbook.? 1 2096 (11/16/2009 12:40:27 PM) Vivien Hi, While trying to save a string in an Excel Workbook, but NOT in any cell, I discovered something exists to do that in Word, "ActiveDocument.Variables". Is there a similar way to store data in Excel, ex...