Compile Error: Expected: list separator or)

[reharris2]

I am trying to create a self-cleaning pivot table that automatically deletes unwanted drill down tables. I have found some code through google; however, I keep getting a Compile Error: Expected: list separator or). Below, is the section that keeps producing the error:


Private Sub Workbook_SheetBeforeDoubleClick( _
ByVal Sh As Object, ByVal Target
As Range, _
Cancel As Boolean)

 

[VoG]

Try

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

 

[jasmith4]

You're missing line continuation on the second line, ending with Target:

Private Sub Workbook_SheetBeforeDoubleClick( _
ByVal Sh As Object, ByVal Target _
As Range, _
Cancel As Boolean)
​

 

[reharris2]

It worked. Thank you!

 

[coolvij]

Hi ...

Im a newbie to VBA ..

While trying the following code, m getting <Expected:list separatr or )> error:


Private Sub CommandButton1_Click()
Range(“A1:A10").Value= ”Visual Basic“
Range(“C11”).Value = Range(“A11”).Value + Range(“B11”).Value
End Sub


Please help on this ...

 

[VoG]

You have some strange " marks. Try copying and pasting this

Private Sub CommandButton1_Click()
Range("A1:A10").Value = "Visual Basic"
Range("C11").Value = Range("A11").Value + Range("B11").Value
End Sub

 

[coolvij]

Thnx a Ton Mr.Excel .... It is basic and will take care of such tings goin forward .... Thnx again ...