Hello;
I am working on an excel ( Office 2003 ) spread sheet to develope a golf
tournamant scoring sheet. One of the functions that I am trying to achieve is
to sort the gross and net scores in order. Currently I have a Macro set up to

I have a spreadsheet that has 6 columns of data -- 1 record ID and 5
pieces of associated data.  these rows of data are intermittently
interspereced with group identification rows like so:
(first ID starts in cell(14, 2))

Dear Dave ,
You always seem respond to most of the queries on this forum. Your
solutions are always very elegant. They show depth of your knowledge,
your understanding of the subject and above all, your helpfulness. You

Need formula to look up the zip codes listed in H2 thru K1522 when an
address is entered.  For example:
In Cell B2 the following is entered:
2005 Airline Rd

I need to import GIF images as buttons in my workbook. I then want to
control their behaviour in my procedures. To identify these button
objects I recorded a micro and saw that they are identified as some
Picture No eg. Shapes("Picture15"), shapes("Picture 23"). I have no

The code below works without selecting the worksheet "Monthly" & copies data
from "Data" across.
Sub Transfer_Data_to_Monthly_Sheet()
Dim wsWig As Worksheet

I need to know the command(s) to change the backround color of a cell
from a VBA marco.
Not Important but I feel like typing
I'm writing code into the change event of a spreed sheet to automaticly

What would be the syntx for the variable, dtFileDate to contain only the
date (not the time) from the FileDateTime function?  For example put
1/21/2006 in the variable dtFileDate when FileDateTime is 1/21/2006
11:57:16 AM?

I have multiple worksheets in a single workbook and I want to have a
button that will publish the workbook to a single file web page (*.mht)
without leaving .xls spreadsheet.  I have 2 problems, well 3.  The code
works on one of my sheets but when I copy the code to an IDENTICAL

I receive a 'type mismatch' when trying to use the following line of code to
check the contents of cells and then assign a constant to the variable 'item'.
If Range("n1").Value <> "" And Range("n2:n50").Value = "" Then item = 1

I want to disable 30 commandbuttons on a sheet. At the moment I'm using
the following code which works, but I'm sure there must be a better
way.
Sheet7.CommandButton1.Enabled = False

i want to select(focus) 'adjustment' tab in cell format dialog(ctrl+1)
using sendkey method only.

I have a workbook w/ 10 or so sheets and I  want to put in an event handler
to call different macros if different cells are changed by the user. For
testing I've tried putting the following routine in one and all of Modules
1-5 of the workbook project, but can't seem to get it ...

I know you can open a web page into Excel by simply entering a web
address.  But is there a way to tell Excel to import the source code
instead?
Thx

It's quite a stupid question...
how do i get to run a sub as the form loads?
smth like
sub myform_initialize()