Delete Entire X Column below Except Header.

[harky]

Is there a way,using VBA, to clear E3 & below (the entire column) except the header at A2 ?

 

[vcoolio]

Hello Harky,

......except the header at A2 ?

Do you mean E2? If so, try:-

Sub Test()

Range("E3", Range("E" & Rows.Count).End(xlUp)).ClearContents

End Sub

Cheerio,
vcoolio.

 

[harky]

Sorry my eye blur. Should Column D3 below.

My header is location @ Row A1 and A2 (remain untouch)


Thanks!

Hello Harky,



Do you mean E2? If so, try:-

Sub Test()

Range("[COLOR=#ff0000]E3[/COLOR]", Range("[COLOR=#ff0000]E[/COLOR]" & Rows.Count).End(xlUp)).ClearContents

End Sub

Cheerio,
vcoolio.

 

[harky]

provide a clear pic..
Clear the column D3 below which highlight in yellow.

*using excel 2010

Hello Harky,


Do you mean E2? If so, try:-

Sub Test()

Range("E3", Range("E" & Rows.Count).End(xlUp)).ClearContents

End Sub

Cheerio,
vcoolio.

 

[harky]

Hi,

Think i manage to find my ans to ans my own question.. haha

Sub Clear_Column()
    Range("D3", Range("D3").End(xlDown)).ClearContents
End Sub

 

[vcoolio]

Well done Harky! Good to see.

Cheerio,
vcoolio.