I have a spreadsheet that goes from column A to HK.  I have code written that
prints out a specific cell range based upon a drop down list choice.  Since
the information in Column C is the same all across the spreadsheet, I have
frozen the sheet to scroll across.

I am getting a Compile error: Ambigious name detected: Worksheet_Change
message when processing my code.

Worksheet_Change process once.

I'm using Excel 2000 sp3, and i have some code that tries to do this (and
generally succeeds):
       With rngTarget.FormatConditions.Add( _
           Type:=xlExpression, _

I need help with the transpose function. Currently I have 2000 columns
with data of people's names. For example
Jane Doe
Partner

I am trying to write some code in order to download data off the
internet. It involves going to a website, running a query, exporting
the query to a .csv file, and downloading the file. I am experiencing a
problem when trying to export the query.

This should be easy for somebody here ... I just can't remember
I have code written to go to various cell locations on a worksheet.
What is the code to have each of these cell locations to show up on the
top of the page?  For example, if I'm on cell A1 and then direct it to

I have the below code which rins really slow and i think it would be
better as a for range = 1 to 500 and then using next
Please could someone help me adapt it to do just that
Basically it looks in column a between rows 1 to 500 and for each cell

I am trying to set up a macro to run for a data file that will not have a
consistent number of lines each month.  This seems like it should be simple,
however I am struggling.  I tried using relative references but either I
didn't set it up right or it won't work.  I also tried ...

I have a column that has the following numbers:
     1400BAL630
     1400CN2400
     1400CN2500

Are these possible?
I've got the following formula to work out how many instances there are
of "Apples" and "COM" occuring at the same time
{=COUNT(IF((leasetracker!$E$2:$E$2000="Apples")*(leasetracker!$H$2:$H$2000="COM"),leasetracker!$A$2:$A$20000))}

I have some data organised as follows:
Date            Value
1/1/2006        12.45  <-- font color black
1/2/2006        13.21   <--font color black

I have made a pie chart using a macro... the problem is i also want to
display the percentage with the chart.
Now for some reports there are times when there are many small values....so
the chart gets messy with all the values overlapping........ i have to make

Can anyone out there tell me how I can link data between sheets so my
sheet w/ the pivot table is updated everytime my master is changed?
I'm very green w/ pivot tables so please dumb it down  :)
Thanks!!

I need the ability to allow the user to change the cursor to a cross hair
that covers the entire form that detected the mouse event.  This is needed so
user can read values along sides and bottom of form as he/she moves mouse
over the form. I have been unable to find any vba code ...

Hopefully someone out there can make this happen for me. I have data
coming from SQL into Excel that includes dates (in column "a", for
ex.), and then two additional data elements (columns "b" and "c" for
ex.) of data. I need to sort through column "b", and where a value