delecting specific cells Vba code

[papare]

I am using the below code but cannt understand the error (bold code). The main of the code is to select a range of cells data, paste it on SD (sheet) acts a database and then reset all the relevant cells/delect/clear. Kindly assist

Sub uploadsinf()
Application.ScreenUpdating = False
Dim bottomV As Long
bottomH = Sheets("SD").Range("L" & Rows.Count).End(xlUp).Row
Sheets("Info").Range("D25:D46").Copy
Sheets("SD").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial _
Paste:=xlPasteValues, Transpose:=True
Sheets("Info").Range("D8,D10,D12,D15,D16,D17,F6,F8,F10,F12,F15,F16,F17,J6,J8,J10,M8").ClearContents
Application.CutCopyMode = False
Sheets("SD").Select
Sheets("SD").Range("A2:V" & bottomV).Select
Sheets("SD").Sort.SortFields.Clear
Sheets("SD").Sort.SortFields.Add Key:=Range("A2:A" & bottomH), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With Sheets("SD").Sort
.SetRange Range("A1:V" & bottomV)
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Application.ScreenUpdating = True
Sheets("Info").Select
End Sub

 

[Chris Mack]

What's the error message?

 

[papare]

the code just breaks at Sheets("Info").Range("D8,D10,D12,D15,D16,D17,F6,F8,F10,F12,F15,F16,F17,J6,J8,J10,M8").ClearContents

 

[Chris Mack]

You don't get a message?

 

[papare]

no message, the code just breaks

 

[Peter_SSs]

Certainly the error message should shed some light on the problem. Still, a couple of possible culprits come to mind ..

1. Sheets 'Info' could be protected,

2. That range on 'Info' that is to be cleared could include some merged cells.

 

[Peter_SSs]

no message, the code just breaks

You cannot display images stored on your computer. You would need to upload them to a file-sharing site and provide a link to the image.

 

[satputenandkumar0]

Dear papare,

bottomH not declared & bottomV not defined.

Regards,
Nandkumar S.

 

[Peter_SSs]

Dear papare,

bottomH not declared & bottomV not defined.

Regards,
Nandkumar S.

.. but neither of those would cause an error in the line bolded?

In fact, if the code is getting to the bold line then 'Option Explicit' must not be in force which means neither of those issues would cause any error in any case.

 

[papare]

Thanks, it was a merger of a cell which was causing the problem and thanks for the heads up with the bootomH & bottomV