Need to count the number of rows that contain data - ignoring formats.  

=INDEX(Sheet1!$A$1:$C$44,MATCH(I2,Sheet1!$A$1:$A$44,0),2)
=INDEX(Sheet1!$A$1:$C$44,MATCH(I2,Sheet1!$A$1:$A$44,0),3)
How can I dynamically choose which column ie;2 or 3 this formula returns
data from based on the assigned installer in CELL C2?

I'm very new to this.  So please bare with me:
I created three combo boxs, each with several entries in it.  I woulld like
a command button to be used to read these entries to fill out a table.  I
then would like to reference this table.

I have a macro that opens the Edit Find.
Sub MacroFind()
  Application.SendKeys Keys:="%ef", Wait:=False
  Application.SendKeys Keys:="%t", Wait:=True

I need to interact with a web page to select certain dates then import
the data into excel!!
Does anyone have a code for this??
Kevin Gunn

I am trying to get a macro to open a file in the same directory as the xl
file being launched.  The code I am using is:
   Workbooks.Open Filename:="DB-Data.xls"
For some reason it doesn't want to find it [although the help file says that

I have a spreadsheet that I need to have the columns sorted by instead of
rows.
I have data like
Store Name            ABC Store   DEF Store   GHI Store   etc  etc

Can the system variables like %HOMEPATH% be used inside of Excel? If so then
how?

I want to come up with an easy to have my Excel file (on open) evaluate the
first row of data and hide the columns where there is none yet (future
months of data will fill in later and then auto unhide).
If possible it would be even better to evaluate the column and make sure Max

I have the following code in an excel spreadhseet so when the user clicks the
button a pop up box will appear for them to enter the B# of the user they
would like to send it to.  what I would like to add is in the Body another
pop up box feature that will allow the user to input ...

Good afternoon all,
    I have a list of names on a worksheet named Lists. On the Main
worksheet, I have a drop down field that references the range of names
(called Names).

Hello,
I am trying to show some values using msgbox after using FIND. But when I
try to find a value that does not exist in the sheet I get an error:
Run_time: "91"

Im getting a run time error 13 for the code below!! it says Type
Mismatch.
can anyone see why, i cant!!
Sub getit()

Is there a way to turn off the Undo Feature for a worksheet?
I can not seem to find it in the help.
I have to consolodate 50 columns(12,000 rows each).  After I calc I wish to
delete the 50x12,000 matrix by using selection.clearcontents but it does not

Hi, I am trying to save a file to directory.  I want the saveas dialogue box
to pop up with the file name and pathe I specify, but I want the user to be
able to change the path given that it changes on a monthly basis.
With Sheets("MissingSTAvg_Corp")