I am using this VBA code (created by Bob Phillips - Thank You Bob). I am
trying to use it an a 4000 row column. It appears to have a limit of 75 rows.
Is there a way to modify the code to handle the larger task ?
Thank you in advance...

I am trying to reference other worksheet to be in the value of the lookup but
get #REF error.  Is it not possible to reference other cells in multiple
worksheets
ie:  =IF(Recipient1:Recipient3!E2="Partner", "yes","no")

highlight the lowest number in each column, only if it is a uniqu
value... in other words, only if it doesn't match any other number i
that column. I'd also like that number somehow paired up with it'

I have a spreadsheet that i am trying to filter. I have tried auto filter but
it is not working. What I have is a coumn with a part number and then 4
columns with other numbers. I am trying to pull out the part numbers that
have a 1 in any of the other 4 columns. below is a ...

When I copy a formula down my spreadsheet, it returns the same results as the
top row even though it isn't justified anywhere.  The only way I can get it
to work is F2 enter on each line!!  Please Help! I have lengthy files and
this happens on and off for no reason that I know of ...

can somone tell me why the attached code will not work it works for the first
range only but when others added it fails also how do you clear outline of
copied cells, i used  range ("D9").Select but no good.Could someone help
please

When Windows users create a worksheet that uses the WORKDAY function from
the analysis toolpak for VBA, that document frequently returns the #NAME
error in the cells referencing the function when the document is opened by
Mac users. Our Macs are running Office 2004 under OS X 10.3.9 ...

I wish to sum the count of a numeric criterion across and down numerous non-
consecutive Rows. The Rows of Data to be counted and summed is on every 3rd
Row; starting at Row 46 - D46:AZ46, D49:AZ49, D52:AZ52 etc. Over 30 Rows to
count and sum.

If I have a list of dates, how can I choose the beg or ending date within
this range?

How do I enter comments into a protected worksheet?  I just want comments in
one column on the worksheet, but it doesn't appear to be enabled unless I
take the protection off which I don't want to do.

I want to put future dates in various cells.  Does Excel have a calendar
where future months can be selected, the date selected, and then have that
date entered into a cell?  If not, does it have the calendar?
Thanks, Phil

Everytime I try to move one cell to the right using my TAB key on the
keyboard, the highlighted cell ends up being a whole screen view over.  I'm
not completely computer or microsoft illiterate, but for the life of me I
can't figure out how to fix that setting.  Anyone have an ...

the formula that I am trying does not return the results that I need.
=IF(C16<="14-Sep-05",SUM(F16*$S$1),IF(C16>="15-Sep-05",SUM(F16*$S$2)))
Cell C16= date
Cell F16= Kilometers

I am using two spreadsheets.  Both spreadsheets have last name and first
names of students from our school.  I am trying to lookup the student numbers
from one spreadsheet and populate to the other.  I can do it just fine except
when there are duplicate last names.  Does anyone ...

I have a cell that contains the Median of 5 cells w/percentages in them.  
Then I have a cell that adds the Median result with 100%. (Median result
4.87%, formula result 104.87%).  Then I'm trying to multiply a cell that
contains 377,615 by the cell that contains the result 104 ...