Hi, just wanted to find out if it is possible to set several integer or
string variables to the same value all at once?  I know that they can
be declared on one line and was wondering if it is possible to do the
same with assigning a value, e.g. Zero.

Is there any way to lock a Calendar control in such a way that someone could
only select a Thursday? Ideally the last Thursday of the month.

I am using Excel 2000 and I want some event to triger whenever my user
form is loaded.
Ex: I have a user form with 6 edit boxes and I want to enable only few
edit boxes depending on the situation at which the user form is

Dear Sir/ Madam
When iI open my excel a box message is appearing Compile error in hidden
module: Autoexcel new can you please give me how can I solve this problem.
With regards;

HI VB gurus!
Is there a way to write a macro to hide and show (with one control
button) that will hide and then show a group of worksheets.
i.e. I have a report that links markets to sub-regions and regions up

Thanks for taking the time to read my question.
I would like to have a button in my workbook that when clicked opens up an
explorer window and allows the user to select a folder.  When the folder is
selected, it would paste the path into a cell on one of the worksheets.  I

I want to summarize a 180 MB Excel workbook that has 8 seperate worksheets
for each product we sell in our company. The Excel workbook is fed through
queries from Microsoft Navision. Each sheet has (almost) the same format:
Colum A Date

From a blank Excel application (toolbar), I am opening one workbook
("oldSheet"), and then opening another workbook ("newSheet"), and copying
values from the old to the new.  I need help identfying each workbook.
I want to declare range objects (i.e. oldSheet and newSheet), but ...

I have a question concerning a cell, I want the cell to lookup the date if
it is between jan 1 and june 30 I want it to show "yes" and no for the rest
of the year.  I need it to be volitile and not just for this year.
Any ideas

I have a macro which when it runs cycle through all the worksheets in my
workbook. When it finishes it leaves me on the last worksheet of the
workbook. I would like to be returned to the worksheet that was active when
the macro was started.

How do I temporarily turn off messages in Excel, i.e. "Do you want to save
changes?".  I'm running a macro that opens other workbooks and copies data to
my current file and then closes the other workbooks.  I need to turn off
warning messages, and then turn them back on at the ...

Here is some code from XL help.
With Worksheets("Sheet1")
   .Range("C1:C5").Copy
   .Range("D1:D5").PasteSpecial _

I created a listbox from a range of cells.  I need to identify the cell that
contains the value of the item in the listbox that was selected, and copy the
entire row.
I'd appreciate any help in:

I want the user to give a "start" and "end" date on an xl SS, then query an
Access DB for specific data.  I've created another Access database that does
a link-query (is that correct name?) to the 'Main' database, but would rather
go the Excel SS route since this is where the ...

I'm having trouble getting the syntax right for passing a 3-dimensional
array to a subroutine.
The array in question in originally defined as
dim variable() as single