Help with code

[edwardpestian]

The following code is returning a Compile Error: Automation type no
supported in visual basic. The underlined portion of the code is wha
is highlighted when I get the error message.

Regards,

EP

Sub Button9_Click()

Dim _Answer_As_VbMsgBoxResult_
Dim blnCopy As Boolean
If Sheets("Data").Range("Y3").Value
Sheets("Input").Range("G9").Value Then
CopyData:
********Sheets("Input").Range("G15:H29").Copy
********Sheets("Data").Range("D114").PasteSpecial Paste:=xlValues
SkipBlanks:=True
********Sheets("Input").Range("G15:H29").ClearContents
********Sheets("Input").Range("L15:M24").Copy
********Sheets("Data").Range("D130").PasteSpecial Paste:=xlValues
********Sheets("Input").Range("L15:M24").ClearContents
If blnCopy = True Then GoTo ResumeHere
**blnCopy = True
End If
If Range("C15").Value <> Range("F15").Value = False Then
********Answer = MsgBox("These dates have already been entered. Do yo
want to continue?", vbYesNo)
End If
If Answer = vbYes Then
*GoTo CopyData
ResumeHere:
ElseIf Answer = vbNo Then
** 'Do Nothing
End If
Continue:
****Application.CutCopyMode = False
End Su

 

[Bob Phillips]

Just declare it as Long.

 

[edwardpestian]

I'm new to VBA, so this is a learing experience for me. Can you tell me
how to declare it as long.

Regards,

EP

 

[Dave Peterson]

Dim Answer As Long

I'm new to VBA, so this is a learing experience for me. Can you tell me
how to declare it as long.

Regards,

EP

 

[Guest]

Sorry to break the rule of not asking a question here;
but how do I start a new thread?
Clicked on New, then ? new question, then nothing happened.
Could not type in the box. Notihing in Help.

 

[Dave Peterson]

You're posting through the Microsoft Communities web site, right?

There's a New button/icon to the left of the "Show" (all threads, etc) that you
can click on.