Running the following code produces a type mismatch error when the
line with the ExecuteExcel4Macro is reached. But if the code is re-run
again with no changes the error does not occur.
I've done some web searching and found some suggestions that I've

I have the following vba code, but it seems I have to many or too little
"else" or "End If". Please help me..
The code is as follows:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As

I want to copy and paste some charts from Excel in to PowerPoint, first I
group the Chart and its title in Excel, then I want to open a specific
PowerPoint file, then select the page in the file I want the chart, then
paste it in as a picture. The problem I have is selecting the ...

I had posted a similar question a while ago, and I never got an answer that
made sense to me.  I am sure the experts did not understand my question.
Basically, I am trying to create a variable of type Range, dump some cells
into this variable, manipulate the contents (format, ...

I have a VBA Code Using the BeforeDoubleClick.
My Question is how do I refer to that Sub?
I want to make that if the user selects from a userform option 1 then
BeforeDoubleClick should one way, if user selects option 2 then

Hi, all,
I'm stuck and hope you can offer some help.
I know a bit about VBA programming but am having trouble writing
code to do the following: I wish to delete all date values in a column

I am trying to store todays date minus x amount of days.  So I get todays
date with Date Function, format it to YYMMDD.  Now my problem is, today is
the 12, so if I minus 2 weeks I get 80999, not 080929. So it drops my
leading zero and ignores the month

Hi,
There is this VBA program  in my excel sheet that tells excel to :
Function MATHEMATICS()
IF C14="C"

I have heard that "Excel is to game designers what Microsoft Visual
Studio is to programmers" -- and as a relative newbie, I'd like to
learn howso.
One common thing in game design is branching and recombining plots (or

I'm using the following subroutine to look at a specific autofiltered
cell, and if there are caret characters in it, to make the text in
between italic.  Then it is supposed to delete the carets (^).  It (or
a variation of it) worked in non-autofiltered cells.  Here, the

Why does the last message box return FALSE when testing a cell for a string?
I have the same problem checking for numeric values such as Double.
Sub Test()
   'The active cell contains the string "ABC"

Code works to :
List all unique values from column A in Column B, starting with row
12.
I need to know how to change the criteria in the code to do the

I'm trying to select a folder then on each worksheet in each book I would
like to clear the contents of hidden rows 1-4 and then run David McRitchie's
Trimall routine on column H.
Sub PrepClear_Trimall()

I have a worksheet with 16 columns and 54 rows.
Each row has a range D6 to S6, D7 to S7 ect.
I want to run a macro that checks each range to verify that only 6 columns
in each row have data entered.

I need to make the following code work for a variable number of rows
and stop when it reaches a #VALUE! error.
Public Sub ConcatenateEmail()
   Dim myString As String