How to erase a column VBA

[Guest]

Hi,

Im trying to erase a column via VBA, this column is variable and depends on
the active cell,
Im trying this but obviously its not working:

ActiveSheet.Columns(ActiveCell).Delete

Any kinda help will be very appreciated

Thx

Jepane

 

[Guest]

Sub demo()
ActiveCell.EntireColumn.Delete
End Sub

 

[Guest]

Thanx a lot Gary, i guess it was trivial, but helps me a lot