Hi Amar,
change cells with range
Sub Macro1()
Range("a:a").Replace What:="0", Replacement:="", LookAt:=xlWhole,
SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End Sub
On Thu, Mar 7, 2013 at 7:04 PM, Somnath Khadilkar wrote:
> Still Prob
> ==
Still Prob
R/ Prince, I just 'recorded a macro just clicked in some cell G8 and
stopped recording] and put your code in it., On exec. it says error,
you may pl have a look
Sub Macro1()
'
' Macro1 Macro
'
Sheet1.range("$A1$AZ1048576").clearcontents.
'
Range("G8").Select
End Sub
:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Prince
>> *Sent:* 06 March 2013 13:26
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0
>>
>>
>>
>> By
-macros@googlegroups.com] *On Behalf Of *Prince
> *Sent:* 06 March 2013 13:26
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0
>
>
>
> By using VBA :
>
>
>
> Sheet1.range("$A1$AZ1048576").clearcon
: $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0
By using VBA :
Sheet1.range("$A1$AZ1048576").clearcontents.
regards
prince
On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote:
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric 0
By using VBA :
Sheet1.range("$A1$AZ1048576").clearcontents.
regards
prince
On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote:
>
> Dear Sir,
>I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
> would like to BLANK or DELETE the numeric 0 , [Other cells