***Clear cells only data not the formatting

[Rehaan Syeed]

hi

i want to know how can we clear cells without clearing the format or validation putted in the perticular cell (cells) with the help of a macro

i have tried doing with the below macro but itz deletng the validations as well can and one help me with that

USED macro

Sub clear_contant()
range("A1:A5").clearcontant
End_sub


thanks

Rehaan Syeed

 

[VoG]

This clears only the contents, not the formatting or data validation (tested in Excel 2010)

Sub clear_contant()
Range("A1:A5").ClearContents
End Sub

 

[Rehaan Syeed]

i tried it but itz still coming out with the same result.

the A1 to A5 cell references holds validations as well but i juzz wanna make those cells empty without deleting the validations assigned

 

[VoG]

Before the macro

Excel Workbook
	A
1	Y
2	N
3	N
4	N
5	Y
Sheet1

#VALUE!

After the macro

Excel Workbook
	A
1
2
3
4
5
Sheet1

#VALUE!

 

[Rehaan Syeed]

Thank You Very much itzz Working

 

[Rehaan Syeed]

Hi Peter

Iam a New User to this site this is a very good site with a quick replies to our quries.

can u help me with the consolidation macro. i mean a macro which consolidates the multiple excel workbook into one workbook sheet if we give path to that macro from which folder it should take the data.

thanks
Rehaan Syeed

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc837974.aspx