I am trying to have a check box control whether certain columns, rows and
worksheets are hidden or unhidden.  Over at the newusers forum someone gave
me a macro that I have tried to modify to make this happen.
Private Sub CheckBox1_Click()

I have 3 workbooks(Service Techs 1-3) I keep records in. I have a 4th
workbook (RECAP)that I want to retrieve from. The three workbooks  each
have worksheets that are labeled January - December.
In the Recap Workbook I have a worksheet where I keep the information

Via VBA i filtered a sheet. Basically i should have as result only 1 row.
How can i know what is the rowindex (figure in the grey column margin
e.g : 873, or 34245,...) ?
thanks a lot,

Hello.  I am trying to use visual c++ 2005 express to create xll files so I
can use my existing code for custom excel functions.  I have seen one thread
where there was a discussion of the issues using xlcall.h and xlcall32.lib
from the excel 97 sdk even with 2003 .NET C ...

I'm having a bit of trouble (OK, a lot of trouble) writing some code.
Here's my situation.
My Workbook has many Worksheets with names like L1-3, F2-6, L2-3, R4-10,
etc.   I  need to write code that will do the following: (I'll use a button

I've used boxes that only deal with one item request.  Is there a way
to request to user input items?  If so, can anyone point me to an
example on the net?
Thanks.

I have a log that has a user input box for a start DATE.  I'd like to
do the same thing for the start DAY NUMBER.
I tried modifying a date macro to input this number, but no luck so
far with any attempts.  The macro below should request a number

I've read and read on the archives but I'm obviously not plugging in
right search terms as I'm not familiar with the required syntax to
begin with <g>.  Same with the help file.
In box code below, there is a simple error handling "On Error GoTo 0".

I recvd the fabulous code below some time back for prompting users for
dates which then gets dumped into the sheet.  I've modified it several
times and use it throughout several workbooks now and it usu. works
perfectly.

I wish to copy data (values only) fro
Workbooks("A").Worksheets("A").Range("A") int
Workbooks("B").Worksheets("B").Range("B") without opening Workbook A.
Is  this possible?

Hi I have a defined cell range(called simon) which currently covers cell
A35 to A40.  The size of the range can expand / contract depending on
whether rows ae inserted / deleted.  The cell the range starts can also
alter.  

Howdy,
Have a worksheet for entry, with a macro that copies filtered ranges to
another sheet.
Is there any way to have code to highlite only the cells in the pasted

I want to create a combo box with  sheetnames of w/book.how?

I am trying to put 1 of 4 footers into the center footnote via a macro. Which
footer that goes in depends on the scenario selected by the end user.
The longest of the 4 footnotes is 198 characters. The left footnote is 56
characters. The right footnote is today's date and should ...

Im trying to add the name of each worksheet to a combobox but so far I'm
having little luck, I want it to be done in this style:
sub userform_initialize()
For x = 1 to 30