Can someone help me with how to designate multiple sets of rows to hide?  I
have the following code, but it errors out with 'Invalid use of property' or
'Unable to set the hidden property'; there is no protection set.  I've used
the following variations and nothing works; I'm ...

Hello all, I got some fantastic help on this problem yesterday and wanted to
see if someone could take a look at my code and possibly offer some
suggestions.
What I have is a sheet that users access to pull up customer information

My spreadsheet contains all dynamic information that is either being
copied or created at runtime (objects).  The user clicks and gets more
columns to put info in.  They save in the end as a regular spreadsheet.
It's only one sheet.

Follow-up question to the post "Determine if a workbook is already open":
Given:
- At least two excel instances running. Only two are of interest, call them
A and B

I have some information on an Excel spreadsheet that I successfully copy to
an Public Array. I use another procedure to extract this same data from the
Public Array but there is no data. How can I maintain data in the array. I've
used the Static keyword but still no luck. What am ...

I am exporting data from Access 2002 to Excel.  Unfortunately, I am
exporting a sub report that produces blank cells in columns A thru M for the
sub report data.  For example my ONE relationship of Customer is on row 1.  
The many relationship ORDERS is on rows 2 thru 5, but the ...

I am trying to write a macro that will format a spreadsheet (containing data
downloaded from a Borland database) and perform quartile analysis on several
data blocks in the spreadsheet. The problem is that size of the data blocks
varies depending on the original query that was ...

I have a set of 4 numbers.  I need to go to each row in the spreadsheet,
search for 4 cells whose values matched these 4 numbers and then copy the
value of the cell right after these 4 cells to a table.
For example:  the 4 numbers are 1, 2, 3, 4

Good day,
I have a function in a module, in which I would like to state that the
current visible worksheet should be treated as the active one, because I do
not know during execution what the sheet name will be. In the example below

I have two groups of radio buttons.. but they are working as 4 button
and not 2 sets of 2.
How do I fix that?
Thank you,

I am making a macro to copy data from a cell in one workbook and pastin
it into another workbook.  Unfortunatly I don't know VB too well, I'
more use to writing formulas in excel cells.
I'm trying to write an IF, THEN, ELSE statement in which the progra

I have a column. I need to know how many time a particular 'text'
appears in this column.
This is not a problem if I use COUNTIF, or If I check any single row
with some counters. In this way when I find the desired 'text' I

Okay I guess my question sounded confusing before so I revised it.
Below is the code thats supposed to take the start date and the end date and
list all the trading days in between and including the start and end dates.
The macro is taking the trading days data from DVS Reporter ...

I have the following:
Named ranges within columns A & C (ie A1:A10 is named "Calc" and C1:C10 is
named "Total").  Column A contains a formula that calculates a value based on
fixed data and data entered into column B by a user.

In the original version of my quote module I was using the INDEX/MATCH
formula below in combination with a drop down box to populate several
other cells. I am now working in a multi-page user form, and I would to
do a similar action with text boxes.