I have multiple names stored in a cell. I want to extract individual
names out of the cell. Appreciate any help in this regard.
The cell contains "AAA  BBB  CCC  DDD"
I want to extract this into an array:

Have a IR (Hyperion) worksheet with data and need to be able to press button
and have the data exported into excel spreadsheet via VBA Code. Can someone
direct me in the right direction on how to start this processes? Hyperion
uses Javascript but feel this can be done via VBA by ...

Is there a way to use MS Query to lookup a range of values from a
spreadsheet?  Currently we use an excel front end to let users query
an access db - ms query allows them to enter a value into the
parameter window.  I'd like to  be able to pass a list of values -

I have a workbook that I built that has macros in it. I recently
posted it to the web, but each time its opened by someone it asks
twice if they want to save the changes, and once if they want to run
the macros etc.

I have a form with a calendar control and when I load this file onto another
computer it can not load the calendar control.  I have found out that I can
add it in on the toolbox of User Form and have done this on my computer
(windows XP Excel 2003) but when I go to add it to my ...

Is there a way to use non contiguous cells with the slope function?
Specifically, if y's and x's contain non contiguous values.
SLOPE(known_y's,known_x's)
A simple example...

I've entered the following code with the view to change the page setup
settings across all the selected worksheets.  However, I'm only seeing the
settings on the first worksheet.  Any ideas re if/how I can incorporate page
settings across the board without selecting individual ...

i have the code below which i would like to use to move computers from one
place to another in active directory.
the erro is  'there is no object on the server'
i have set refrence to the active ds type lib

I have a macro that assembles a series of user workbooks from a template
library, and some cells have hyperlinks that are constructed based on user
data entries.  I now have a need to give the user a choice of hyperlink from
certain cells, and my plan is to provide a userform to ...

I have some really large and complicated IF statements (formula type, not
VBA) that I need to review.
I seem to recall a VBA tool someone created to do this, but I can't find a
link in my favorites.

Recently I’m working on creating an Excel worksheet which users need to
insert row(s) under each record (row) in order to enter further information.
The number of row(s) inserted equals to the round up value of, for example,
column C (i.e. 2.1 becomes 3, 2.6 becomes 3, etc). ...

Can sorting go up to 6 keys? Key1, key2, key3, key4 …key6
I am trying to sorting 6 different column/row in ascending order.
if so, i need hep with the code.
Thanks

Code Needed to do this from a macro,
Sheet1 cell A1, the value in this cell changes.
How can I get the content of this cell and put it in a Find Macro,
Then goto Sheet2 Column A, and find down that column for what was in sheet1

I saw lots of posts so am fairly sure this is possible, but want to verify
and maybe get pointers to some good how-to articles.
Starting from an Excel spreadsheet with 20 columns of data, take the values
from three columns and use them as criteria to query an Access database.  For ...

I am tyring to write some error handling around a the Find Method in VBA.  I
am using the code below to return the address of a cell based on a search
term.  If a cell address is not found I do not want the code to fail.  How do
I do this?  I have done this before by using a ...