Access VBA deleting an active excel spreadsheet column.

[Thompyt]

I want to delete a column on a spreadsheet before it saves.



I have seen something where worksheetC.EntireColumn.Delete() the () is the range, but makes Access VBA ask for = or I put in the range (xlRange), then it gives me a method or data member not found on the .EntireColumn

Thanks

[ranman256]

record the macro in excel, do the steps, stop macro.
then plug that code into an excel block below...

Set XL = CreateObject("excel.application")
With XL
    .Visible = True
    .Workbooks.Open "c:\folder\file.xls"
    .Columns("D:D").Select
    .Selection.Delete Shift:=xlToLeft
End With
End Sub

[Thompyt]

Thanks ranman,
I figured this out:

wkSheetC.Columns.Range("A:C,E:G,I:M").Delete

I understand this is column specific and tailored to certain layout.

[Thompyt]

Now I am looking at deleting rows where the row is null

I am trying:

For iRow = 2 to 3002

If IsNull(wkSheetC.Rows(iRow)) Then
                wkSheetC.Rows(iRow).Delete
            End If

It runs through, but doesn't delete any rows. It seems that the row isn't considered as a null.