I want to unhide row x.
Is there any difference between result of A and that of B?
A:  Rows(x).Hidden = False
B:  Rows(x).EntireRow.Hidden = False

I have a file I save weekly to several different names. I open the
workbook read only and after some modifications.  I then copy the
worksheet to a new book.  Tell the new workbook it's new name, then
save it to the same location every time.  I want to keep the yes / no /

I am making a house price estimateing program for my friend, with 2 files: a
list of materials and thier size, and a price list. I don't know were to
start. Can you help me?

I am looking for a function that that can be used to replace the COUNTIF
worksheet function, but works on non-contiguous cells. Can someone point me
in the right direction.
Thanks

Is there any way to pass an object (created from a custom Class) by
Value in VBA..?  I have tried using the ByVal keyword in my procedure
but the object is still being passed by reference (the original object
is modified in the procedure code).  Here's my code:

So I am new to VB Macros in Excel and I swear I came across some method
called .contains where if a cell contained the string or regular
expression you were searching for it returned a boolean of True or
false if it didn't find it.

I'm not sure what background is needed here so I'm going to
probably over post ...
I have a macro that inserts checkboxes directly to a worksheet. The
worksheets are created programmatically in a separate module prior to

Martin wrote this code a while back and I'm trying to manipulate it so
that it returns the highest value in column 4 only, not a concatenation
of all the values in column 4.
Basically the code does this:

My VBA code has a line where it populates an array with the results of an
array formula:
Selection.FormulaArray = MyFirstFormula
and, then another,

I'm writing an Excel 2003 macro to generate a calendar planner with
coloured worksheet cells forming horizontal bars that show where a
project falls within the year.
However I can't seem to get the logic right to determine whether a

Hi there, I'm a bit of a newbie with macros so was hoping someone might
be able to help me out with this one:
I have a master spreadsheet (master.xls) that has a header row and then
a series or rows containing data in columns A thru G. Each row

I am making a "wizard" and one part has 5 checkboxes (of the same
groupname).  I want to prevent the user from clicking my next button
unless he/she has clicked at least one checkbox.
Is there a way to go through each checkbox in this group without having

Is there a VB or VBA math function which will calculate the factors of
a number?
i.e. for 24 the factors could be 1,2,3,4,8,6,12
I need to find the lowest common denominator for a macro that I am

Can anybody please help.
I have the following scenario and i can't figure the vba out...!!!
I have the following columns in 'Sheet1' in cols A, B, C
COL A- Planned Date

If cell A1=1, A1=3 or A1=5, I want the existing contents of B1 to be
deleted.  However, if A1=2 or A1=4, I want to be able to enter input
into B1.  Can someone suggest a macro for this?  Thanks.
Michael