For example: 156 SQFT x $10.00. Where 156 SQFT is all in a single cell.

Is there a way to ignore the alpha characters and only look at the numerical

characters in the formula? (Excell 2000)

Thanks,

Is there a way to ignore the alpha characters and only look at the numerical

characters in the formula? (Excell 2000)

Thanks,

- How do I format a cell to display measurement units with symbols .
- How do I format a cell to display measurement units with symbols .
- How do i multiply hours:minutes by a cash value?
- How do I multiply Column G Totals by a number and display the res.
- How do I multiply a whole column by a number?
- How do i multiply hours:minutes by a cash value?
- How do i multiply a cell by %
- How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o.
- How do I multiply either column 1 or column 2 by same multiplier?
- VBA : how do i add a combo box
- VBA: How do I create a level 3 Menu in the Excel toolbar ?
- How do I create a command button in Excel
- How do I link a Workbook with 20 sheets to a Summary Page, a
- How do I use a command button to close a spreadsheet and exit Excel?
- How do I insert a piece of text next to a formula
- How do I "freeze" a formula?
- How do I assign a Name to Current Selection?
- How do I add a text box to my macro
- How do I make a formula that is conditional
- How do I convert a excel 2007 worksheet to a memory stream?
- How do I call a Web Service from Excel 2007?
- How do I save a sheet from the macro workbook to a new file?
- How Do I interrupt a Macro?
- How do I find a numeric in a text string?
- How do I search a sheet for an *

(ie. " for inch, etc.)

Thanks,

Mandy

(ie. " for inch, etc.)

Thanks,

Mandy

hours.

Problem 1 - volunteers who have contributed > 24 hours return the wrong

answer when hours totalled )i.e. seems to go back to zero when 24 hours

reached)

problem 2 how do I multiply the totla individual hours by the individual

hourly rates to obtain a total value?

results (sum) in Column H?

Thank you for the help

from last year that need to be changed. Last years payroll numbers need to

be multiplied by a 1.015 and replace last years #'s. How do I muliply the

whole column by 1.015 and have this show as the new numbers?

hours.

Problem 1 - volunteers who have contributed > 24 hours return the wrong

answer when hours totalled )i.e. seems to go back to zero when 24 hours

reached)

problem 2 how do I multiply the totla individual hours by the individual

hourly rates to obtain a total value?

i would like to know, how i multiply a cell by %?

ex: 8.41% x $134.70? ( i want to use a formula)

ex: 8.41% x $134.70? ( i want to use a formula)

in order to multiply the duration with an amount or rate to give me a cost?

total). How do I multiply number of units by either old work price, or new

work price, based on column where data is entered?

I know i can insert one through the control tool box but i dont want to do that i want to insert a combobox onto my spreadsheet when a button is clicked? How do i do this and if so how do i get a control of where it is put... please help its urgent!

I would like to save my all assigned macros in a New Menu in an Excel toolbar. In stead of saving the macros

under Level 1 menu, I would like to save them under a Level 3 menu.

How do I create a level 3 Menu in the toolbar ?

Appreciate any help on this matter.

Thanks in advance.

Please Help!

Thanks!

I have used the hyperlink but it reverts to the one last accessed!!

how do I insert a piece of text next to a formula result in the same cell?

Example:

I want to write "date of" in the cell but then have another word after that which is dependant on a VLOOKUP result, all in the one cell.

Just as a primitive example:

In cell A1 is the formula =B1

In cell B1 I write the word cat.

Now A1 will show the word cat.

So far, so good.

However, if I insert a column between A and B

the formula in A1 now shows =C1.

I want the formula in cell A1 to stay and continue saying =B1 after I insert a column.

Is it possible to "freeze" a formula.

selection.name="zebra"

Also, how would I Assign a Range Name to the active cell?

I see statements such as:

ActiveWorkbook.Names.Add Name:="zebra", RefersToR1C1:= _

"=Donations.tab!R3C100"

But that hard codes the address.

Poked around alot before posting this question.

Thanks.

The macro is:

Sub Lockquote()

Worksheets("quote formula").EnableCalculation = False

' Lockquote Macro

' Macro recorded 8/24/2008 by Mike Frank

'

'

End Sub

To run the macro you click on a command button labeled " Lock this Quote"

Once the macro has been run I want a text box to apprear that shows "Quote is locked", than I want that text box to go away when I run the macro to unlock the quote.

"Only Microsoft can make me feel this stupid!"

For Example:

Totals hours spent on administration: =D7 if C7 = administration

I don't know if this is possible, but I hope so! If I'm confusing, I apologize because I'm not well versed in computer terminology.

Thanks,

or

How do I convert a excel 2007 worksheet to an array of bytes?

Thanks in advance.

Does anyone has a sample Web Service call from Excel 2007?

Thanks in advance,

Mark

My code runs, the last thing I want to do it to move sheet named "Summary" to another work book, save it as XLS in the same directory as the macro, with the name being "Pivot Table" &myStartDate& myEndDate&".xls"

I'm under what to put after...

Sheets("Summary").Select

Sheets("Summary").Move

Thanks!

Lets say I have a text string consisting of "CASTLE HILL 2154 SYDNEY NSW AUSTRALIA", this can change, its position can change, sometimes it will not even exist.

How do I get just the 2154 from that string?

Thanks

Dan