Thanks a lot for all your feedback..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prafull Jadhav
Sent: 06 June 2013 17:53
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Search Replace
Dear Sir,
Small Question...
then Sir
try below VBA code
Sub conditionalreplace()
Dim rng As Range
For Each rng In Range(D1:D10)
If rng.Value 0.8 Then
rng = .80
End If
Next
End Sub
.
Enjoy
Team XLS
On Thu, Jun 6, 2013 at 11:18 AM, Amit Desai (MERU)
Dear XLS,
if we not declarer variable , will code run properly .?
suppose ...we write code as per below.
Sub conditionalreplace()
For Each Range In Range(D1:D10)
If Range.Value 0.8 Then
Range = .80
End If
Next
End Sub
if not ...Please
then use:
Range = .80
it seems that the usage is inconsistent.
hope this helps,
Paul
From: Prafull Jadhav prafulltjad...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, June 6, 2013 7:59:11 AM
Subject: Re: $$Excel-Macros$$ Conditional Search Replace
is inconsistent.
hope this helps,
Paul
--
*From:* Prafull Jadhav prafulltjad...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thu, June 6, 2013 7:59:11 AM
*Subject:* Re: $$Excel-Macros$$ Conditional Search Replace
Dear XLS,
if we not declarer variable
.” - John Wesley
-
From: Prafull Jadhav prafulltjad...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, June 6, 2013 8:26:37 AM
Subject: Re: $$Excel-Macros$$ Conditional Search Replace
Dear Sir,
Small Question
:* Re: $$Excel-Macros$$ Conditional Search Replace
Dear Sir,
Small Question...
then Sir what is exact meaning and use of declare variable in below case?
Thanks in Advance .
Reg,
Prafull Jadhav.
On Thu, Jun 6, 2013 at 5:41 PM, Paul Schreiner schreiner_p...@att.netwrote:
IF you do
Dear Friends,
Do we have any functionality to do conditional search replace...
For example what if I wants to search for values less than 80% replace them
by 80% in selected range! Do we have any features...
Best Regards,
Amit Desai
Disclaimer: This message