How to identify a cell [format|category|number|scientific] for sea31264 (11/18/2009 10:29:02 PM) UtfI 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 ?51590 (11/18/2009 12:37:37 PM) VICTORHi,
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 cell41400 (11/18/2009 3:17:29 PM) AndreasHi!
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 question21271 (11/18/2009 10:24:15 PM) Cinci_ShawnHello,
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 code11218 (11/18/2009 4:42:15 PM) andre_29Dear 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 worksheet12797 (11/19/2009 2:30:03 AM) JuneI 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] Specif11280 (11/18/2009 8:23:01 PM) UtfI 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 Excel14802 (11/16/2009 10:27:23 PM) HankLI 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 responding22283 (11/18/2009 3:40:04 PM) UtfOn 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 message21344 (11/18/2009 10:41:26 AM) PaulDue 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 number32079 (11/17/2009 5:36:06 AM) UtfHi 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 task01182 (11/18/2009 12:04:36 PM) SnoopyHey 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 200301337 (11/17/2009 11:04:07 PM) RobHi,
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 me21761 (11/17/2009 8:39:54 PM) Damil4realTwo 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 Row21561 (11/17/2009 2:46:31 PM) SanCarlosCyclistIn 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 syntax11842 (11/17/2009 4:14:11 PM) DougIn 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:11272 (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 Automatically81414 (11/16/2009 7:17:55 PM) sswilcoxI'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 Times31360 (11/16/2009 6:48:33 PM) JimI 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.?12148 (11/16/2009 12:40:27 PM) VivienHi,
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...