I have a list of values in a column on an spreadsheet which i want to use to
populate a dropdown. The problem is that there are duplicate values in the
column and I only want to use unique values. I can transfer this informatin
to an Array but have become stuck on how to remove ...

On a specific worksheet, I would like to prevent users from "deleting"
anything, e.g., rows, columns, or cells.  They should be able to clear data
but just not delete.  Is it possible to prevent users from deleting on a
specific sheet?  Thanks.

Hi I have five check boxes from the control menu, these are named Checkbox1
through to 5.
When checkbox1 is unchecked I would like checkbox2 through to 5 to become
unchecked and grayed out.

I am trying to find some vba code / method of calculating the
confidence intervals for the mean of the dependent y and the
prediction interval for the dependent y in multiple linear regression
models.  I want to calculate these in excel rather than a stats

I've done a fair amount of Visio VBA but very little with Excel and need
assistance.
I've written an Excel auto_open() macro that works fine. Among other things
it checks whether the user has a license to perform certain functions. I

Hello,
I tried to use this code to make it easy. But the macro failed at colorindex.
With Range("A:BF")
       .Formula = Workbooks(ReforecastWorkbook).Sheets("ReForecast -

I have a sheet with a series of figures with which I want to make
combinations.
Approximately 200 lines
Sheet named Base

Is there a command that will force the workbook to recalcualte that I
can put at the beginning of my macro?

am a novice and am trying to setup 3 print Macro's in one workbook.
The work book contains 4 sheets, PRODUCTION, INVOICE, ORDER, DELIVERY NOTE.
PRODUCTION is the master sheet. using VLOOKUP I have successfully put all
necessary data on the other 3 sheets. I now want to put  3 ...

I wish to search a selected range of cells containing dates for any desired
date.  If the date I'm looking for is found, I want to run certain code.  If
it's not found, then I'll run different code.
For example, if I'm searching for 3/15/08 and a match is found among the

What I have is workbook that has two worksheets with one cell that could be
the same in both worksheets.  If that cell has the same information in both
worksheets I would like to create a third worksheet and copy the information
from both of the other two worksheets into the new ...

I'm trying to pass data array to Excel.
If the data is an array of (short?) strings, it works.
If the data is an array of (long?) strings it fails.
If I pass each item from the array of (long?) strings separately, it

Why a public sub (defined in a sheet module ) can not be called in code
behind another sheet ?
Clara

Advice needed: I have 2 MS Access db’s which are the data source for 2 Excel
workbooks. These workbooks contain about 30 pivot tables in each book. Each
pivot table is linked via MSQuery to an Access query. These pivot table links
are hard coded behind the scenes. How can I use ...

I am trying to develop a routine for hiding rows that can be used on all
sheets. In Sheet 1, which is the Master sheet, I count the number of rows
that I can hide. The code when applied to Sheet 1 works.
When I try to apply it to sheet 2 it fails. It fails because the "