My name is Mike and i have a question about microsoft excel macro's.
Attached is a copy of the excel sheet im working on. Below the excel
sheet is the macro I built. Some of the cells contain given values and
some cells are calculated from formulas. Cell (G4) is my given

The arrows displayed by Tools / Formula Auditing / Trace Precedents/
Dependents point to a formula's precedent/dependent cells in the SAME
SHEET as the formula only.
Precedents/dependents in other sheets in the workbook are not

I have an excel file I want all text that will be typed in the empty
cells should be upper case.  So I have the formula in them and when I
type "msft" and hit enter it should give me "MSFT"

I have a cell in a worksheet that is hyperlinked to another cell in that same
worksheet.  (Let's say that A1 is hyperlinked to F7).
If I move the text that is in F7 to another row and column, how can I get
the A1 hyperlink reference to move to the new location. (Let's say that the ...

 I want to use formula in condition syntax, but I don't know how to
reference the value being tested.
Like:
   SUMIF(A1:A10;">10 AND <20")

I have a column with different values like this and so on I want to
calculate =Min(B1:B20) but I do not want to have 0 as minimum value.
I this function not to calculate 0 and tell me 2 as minimum value.
here is the example:

ExcelMedic.com can provide a full  range of
Excel solutions to fit your needs.
ExcelMedic.com charges an hourly rate that is
guaranteed to be 15 percent less than other

If i use Widnows search of the CONTENTS of files (not file names), i find in
Excel, that for cells that contain text, they can be found.  But, it does
not appear to me that numbers can be found.  Of course the number as Excel
stores it may differ from how it is displayed.  But, ...

Sample of what I am trying to achieve:
Worksheet1: (column A, B, C, D, E) - source data
id,primary region, secondary region, tertiary region, status
111,americas,new york, NA, increase

I have been handed a list that I need to convert and I am stumped.
The worksheet contains three columns of addresses. The addresses are
generally in one of three formats:
Company

Does anyone have a simple solution on how to change the size of a checkbox
from either the control or forms toolsbars?
I've seen this called a bug in doing web searches, so maybe Microsoft has
yet to address this.

I am trying to find a text book on excel 2003 that will show me how to use
Excel and give me the data to put into the spread sheet.  Some of the
features I am looking for are, Amortization, Creating Macros and The function
and Chart Wizard.  If you could please include an ISBN# ...

I have a simple question:  I am entering amounts for invoices and in
some cases, the invoices may have multiple account numbers and
associated dollar amounts.  What I have been doing is pressing ALT
+ENTER to have the cursor return down one row, and then I enter the

Excel 2002 SP3
Win XP HE
*Follow-up to: microsoft.public.excel.charting*
Hi,

HYCH
Am looking for some assistance with the following,
i use a form to enter details about individuals, this enters the info
into a column at the end of the line and then sorts into alphabetical