Hi Dhananjay,
Find the attached excel file with the solution.
You can use N( ) to treat any string as 0.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com [mailto:excel
Insertequals()
Dim cel As Range
For Each cel In Selection
If IsNumeric(cel.Value) Then
cel.Value = = cel.Value
End If
Next
End Sub
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination
We can do the subtotal in one cell only.
Find the attached excel file for the solutions
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com
You can use replace all and in find area put .com* (without quotes) and in
replace area put .com.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac
Could you attaché the excel file.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Telenochek
Sent: 25 July 2009
Hi,
I think it will work better without using any variable.
Try using the below code
Sub PasteAsValue()
Range(A1).Copy
Range(A1).PasteSpecial xlPasteValues
End Sub
Regards,
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination
