text to operator
Tue, 07 Oct 2008 14:13:28 -0400
Have fields that look, for example, like "2A5".
I know I can use the REPLACE function to get to "2*5" by replacing the
letter with the asterisk.
At this point the 2*5 is a text string.
Is there a way to get it to be 2 times 5 so that it gives a result of 10?
Thanx in advance! ...
|
Click Me
Tue, 7 Oct 2008 18:42:25 +0200
I've drawn a command button - ClickMe - on a work sheet
and written a little code for it.
[I am used to vb code in the Access environment]
NOW!! how do I make the button user clickable please?
--
Jim Bunton
...
|
order of conditional formatting rules
Tue, 7 Oct 2008 09:22:04 -0700 (PDT)
I have a sheet that has some cells with multiple conditional
formatting rules. These rules are arranged in some order, so that it
stops executing the conditional formats once a certain condition has
been met.
My problem is that when I make a copy of this sheet, the order of
conditional formatting rules is not ...
|
Nothing in cell only in formula bar
Tue, 07 Oct 2008 08:32:43 -0700
Why is it (2007) that sometimes when I type a formula (or anything for
that matter) into a cell nothing shows up in the cell, but it will
show up in the formula bar? ...
|
Excel 2002 debug prompt for all macros
Tue, 7 Oct 2008 07:55:02 -0700
We have 5 PCs in our department that should all be configured alike. When we
run any macro (includes VBS script) in Excel 2002 on one of the PCs, there is
a debug prompt. On the other 4 PCs the macros work fine. Is there a setting
that could have been turned on that is causing the debug prompt on this
comput ...
|
Re: Help spotting a Birthday!
Tue, 7 Oct 2008 07:07:02 -0700
Here's one play to achieve it ..
Assume source data in Sheet1,
DOBs in K3:K300, corresponding names in J3:J300
In another sheet,
Assume the desired DOB will be input in A1
In B1:
=IF($A$1="","",IF(Sheet1!K3=$A$1,ROWS($1:1),""))
In C1:
=IF(ROWS($1:1)>COUNT(B:B),"",INDEX(Sheet1!$J$3:$J$300,SMALL(B:B,RO ...
|
Macro Question
Tue, 7 Oct 2008 05:44:47 -0700 (PDT)
Hi:
I have a group of several files with a simple macro that automatically
goes to a specific worksheet at the time the file is opened. The code
is as follows:
Private Sub Workbook_Open()
Worksheets ("TITLE").Select
Range ("a1").Select
End Sub
The macro works properly when a single file is opened, ...
|
|
|
Linking cells containing text from one worksheet to a cell with text
in another worksheet
Tue, 7 Oct 2008 05:40:23 -0700 (PDT)
I have a workbook with two pages, the first page has cells that
contain the main description heading of the cells on the second page.
The second page has the heading in one cell and then the breakdown of
each section under that, and repeated as there are about 11 sections.
When I paste a link or use a hyperl ...
|
Value Error
Tue, 07 Oct 2008 04:35:36 -0700
I copied some data from a web page and pasted it into a spread sheet.
It looks like the following:
10/12/2008 BALTIMORE RAVENS 39 39
13:00 EST INDIANAPOLIS COLTS -6 -4.5
Simple enough. when I try to subtract (or add) -6 and -4.5 into a new
cell I get a value error. If I retype the -4.5 to -4.5 (I can't ...
|
Adding comma seperated values within a single cell
Tue, 07 Oct 2008 20:39:01 +1100
I need to come up with a custom function that will add up comma seperated
numerals contained within a single cell.
For example if the the cell A1 contains:
4,5,3
I want the result of the fuction (say in a2) to display the result of 12
Any help greatly appreciated.
Regards
Mike
...
|
