deleted from sheet. Just want to
delete 0(Zero) from the sheet.
Thanks
Manjunath
*From:* 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
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
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 khadilka...@gmail.comwrote:
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 may
: $$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 ]. I
would like
@googlegroups.com
*Subject:* $$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