I have macro that sets up a validation list on a cell. When the macro
is called by the Worksheet_Change event it works fine, but when I call
the macro from another macro in a standard module I get Run-time error
'1004' Application-Defined or Object-Defined error. Is there anyone

What function can be used to test if there is data in a cell or not?

EnableEvents = false and EnableEvents = true need to be paired ? Similiar
issue are ScreenUpdating,DisplayAlerts.
Clara

I have a list of hire dates that I need to group by month. I've included in
the macro to convert the dates from text > column using the "\" as a
delimiter (ex: 1\1\2007 would be split into three columns...the month column
now houses a 1, the day column houses a 1, and the year ...

I have a 'menu sheet' in my workbook that contains several buttons which do
no more than select another sheet in the workbook.  I am having to write a 1
line macro that selects the correct sheet for each button.  The button labels
are the same as the sheet Tab names.

I have tried running a nested IF statement with 15 IF clauses. We all
know that excel accepts upto a maximum of 7. I need a way to work
around this problem.
I am sure there is a VLOOKUP solution to this problem.

I have a rather long IF statement, and as we all know that Excel only
accepts upto 7 IFs statments within the nest.
IF(ISNUMBER(SEARCH("#",D2)),"COUNTRYSTOCK",IF(ISNUMBER(SEARCH("404-
BU",D2)),"PACIFIC",IF(ISNUMBER(SEARCH("404-

I have a text string I need to split into seperate cells for each
word.
For example, if this was the value of A4;
The fat cat jumped over the mat

is there a way to avoid repeating yourself in an excel if formula?
for example:
=IF(ROUND(+E4/4,-3)>10000,ROUND(+E4/4,-3),0)
when excel evaluates the expression as true, you need to type in and

I want my VB to find a value, and then put the left 3 characters of
the value into another cell. However all I am achieving is putting the
formula
=left((rngfound.address),3)

The intent of the macro was to force information into cell(s) once, but allow
the user to change the information if they had better numbers.
The macro - works correctly the first time - but it overrides any changes
entered by the user.

Can I use a placeholder in code to execute a find statement?
My code currently looks like this;
Set rngFound = rngToSearch.find("G25KT")
Yet the 25 is a variable number so wanted to express it something like

Getting error at .FileType = msoFileTypeExcelWorkbooks.  I know I need MO
12.0 Object Library, but don't know about how to go about late binding it.  
Is there somewhere that describes late binding formats for instances other
than Excel, Word....for the more specialized ...

I've provided a macro in a spreadsheet to others that automates some things
including putting up the email header using "mailenvelope".  It works fine
for all but one user.  The error that he receives says "Run-time error
'-2147319779 (8002801d)':  Method 'MailEnvelope' of object ...

I would like to know if there is a way to make my macro's execution faster.
It follows that during its execution I work in 2 different worksheets in
parallel. So it shows me in the screen each active sheet every line the macro
runs. I tried occulting the sheets (in which the ...