Clear sheets using VBA

[hudson andrew]

Hi all,

I was wondering if there is a better way of tweaking of my below code to see if I can dynamically clear content in my active sheet leaving first ROW.

below is the code

Please Login or Register  to view this content.

[vcoolio]

Hello HudsonAndrew,

Try the following:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[LJMetzger]

Hi Hudson Andrew,

Try:

Please Login or Register  to view this content.

NOTE: .ClearContents removes data only. .Clear removes data and all formatting.

Lewis

[hudson andrew]

Hi guys ..

thanks for the code its is working fine but need small changes , i am actually dealing with tables , above code only clearing the content i want everything to be cleared .

example : i want table content and its rows and its format to be cleared .

thanks !
Hudson

[xlnitwit]

Hi,

This will clear the table range leaving only the headers intact and resize the table

Please Login or Register  to view this content.

[CK76]

If you want to clear multiple tables in activesheet, except for header rows.

Please Login or Register  to view this content.

[hudson andrew]

Hey guys , this is fantastic . its is working one more small tweek what if i wanted to keep first two rows and delete everything , how do i change the code to ?.

[CK76]

How do you mean?

Do you need first row of data kept + header?
Or just the 2 rows of data range with or without data?

[hudson andrew]

yes, i need below .

Do you need first row of data kept + header?

i want one header and one row data rest everything needs to be cleared including formats .

Thanks ..

[CK76]

Something like below?

Please Login or Register  to view this content.

[hudson andrew]

This is really greate mate , it worked thanks .