I have a set of values in Sheet1 that I need to pull data for each
value from Sheet2.  I've tried a simple VLOOKUP, and it will not work,
no way, no how.   Yes, the lookup table is sorted ascendingly.   I get
errors on about 85% of my rows when I copy the formula down.

I can access most of a files attributes and info using FSO commands but
this does not give me acces to the Comments properties.
Can anyone help? Ideally I want to be able to modify the Comments as
well.

I'm not sure if this is a VBA question, an Excel question, or an XP
question, but is there a way to limit how much CPU Excel burns?
I've written a macro that will endlessly run a Monte Carlo solution.
Normally I run it overnight and all is well.  Sometimes however I run it

I have the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect Password:="test"
If Target.Address = "$C$65" Then

Hey all,
When clicking a checkbox in a userform, I'd like that checkbox to place
two X's in two different cells.  I'm sure this is basic, but isn't
there an "AND" statement in VBA??  Something like:

What is the appropriate channel through which to find Excel/VB
developers?
I am looking for a Excel/VB developer with the necessary experience to
do tasks like the following:

I've been trying to write a macro to copy and paste data from a column
in one spreadsheet over to a column in another spreadsheet.  The
problem is that the first spreadsheet has several hidden rows of data
that I do not need in the second spreadsheet scattered within.  Is

I want to captalize the first letter of the FIRST word in each cell of
a column.
The cell contains something like this:
a anterior view

simple macro help. in my macro i have this line :
entry2 = InputBox("What kind of modem is it?")
If entry2 = "" Then entry2=
but i'm stuck on the last part. what i am trying to accomplish here is if

I have a large list in which I want the user to select an entire row.  I
then want them to click on a button which is tied to a Macro that copies
and inserts the row on the line below.  Can someone help me on this
please?

I have a worksheet that uses macros to pull data from other sheets within the
workbook. One of the macros deletes any rows with a zero value after the data
is pulled in - the number of rows varies each time. I need to subtotal and
then total the $$ amount from three sections ...

Hi all,
I need to compare two worksheets. It should be checked in such a way
that all the data in the first ROWin sheet 1 should be the same when
compared with the data in the range of sheet 2. It should not happen

Hi, I have this macro which essentially hides all rows with a value of
"0" however it takes way too long to get through its task. I think it
maybe due to hiding each row one at a time and not all at once??
Would appreciate any advice or changes to make it all happen for me

I have the following in a spreadsheet:
                A                                     B              C      
   D         E
1  Enter the # of models per year      

I have defined the following value for a cell within my macro
Range("K" & i).Select
     ActiveCell.FormulaR1C1 = _
         "=((YEAR(RC[-1])-YEAR(RC[-2]))*12)+(MONTH(RC[-1])-MONTH(RC[-2]))"