mardi 31 mars 2015

Excel VBA - Clear Column contents from row 2 down

I am trying to clear column contents from row 2 down on a VBA script which I am running, the piece of code below is how I am going about this.


This doesn't appear to be working, but no syntax issues or error messages. Are there issues with this code?



Option Compare Text
Option Explicit

Sub Loader()

Dim wb3 As Workbook
Set wb3 = ThisWorkbook

wb3.Worksheets("Config Sheet").Range("F2").End(xlDown).ClearContents

End Sub

Aucun commentaire:

Enregistrer un commentaire