Re: $$Excel-Macros$$ how to clear all values and properties in a sheet

2013-08-10 Thread Prabhu Pinky
wow great.. thanks ashish.. Thanks & Regards, Prabhu R On 11 August 2013 11:23, ashish koul wrote: > Sub tes() > Sheets(1).UsedRange.Clear > End Sub > > > > On Sun, Aug 11, 2013 at 11:16 AM, Prabhu Pinky wrote: > >> hi experts, >> >> pls gimme the macro for clear all the contents, values, prop

Re: $$Excel-Macros$$ how to clear all values and properties in a sheet

2013-08-10 Thread ashish koul
Sub tes() Sheets(1).UsedRange.Clear End Sub On Sun, Aug 11, 2013 at 11:16 AM, Prabhu Pinky wrote: > hi experts, > > pls gimme the macro for clear all the contents, values, properties in a > excel sheet. (for ex: sheet1 entire cells) > > Thanks & Regards, > Prabhu R > > -- > Are you =EXP(E:RT) o

$$Excel-Macros$$ how to clear all values and properties in a sheet

2013-08-10 Thread Prabhu Pinky
hi experts, pls gimme the macro for clear all the contents, values, properties in a excel sheet. (for ex: sheet1 entire cells) Thanks & Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum