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
Dear Ashish,
Code is Good one,but if anyone want delete Zero or Zero Value cell only
from specific column then how to modified code
Pls suggest code
Regards
amar
On Wed, Mar 6, 2013 at 8:51 PM, ashish koul wrote:
> Hi Manjunath
>
> try this
> Sub Macro1()
> Cells.Replace What:="0", Replaceme
Hi Manjunath
try this
Sub Macro1()
Cells.Replace What:="0", Replacement:="", LookAt:=xlWhole, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End Sub
On Wed, Mar 6, 2013 at 8:47 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
hi prince,
As per VBA code entire data is getting 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:
