Dear All,
I have made one macro for search word in column
like
NO
YES
Correct
if this words are in cell then write the OK in next cell .
I have query that I have used elseif many time. Is there any other way in
which i can write macro in one line
for example
if A1 contain words like
thanks its working fine
On Tuesday, February 18, 2014 9:59:44 PM UTC+5:30, Mahesh wrote:
Hi Prabhakar
perhaps you can use,
=DATE(YEAR(H2)+60,MONTH(H2),DAY(H2))
Regards
Mahesh
On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara
ashishb...@gmail.comjavascript:
wrote:
Dear Prabhakar,
Try this
Sub query()
Dim rng As Range
Dim cel As Range
Set rng = Range(A1:a10)
For Each cel In rng
If cel = Yes Or cel = No Or cel = Correct Then
cel.Offset(0, 1) = Ok
End If
Next cel
End Sub
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Wed, Feb
Hello,
I have a file with many values, distributed across multiple columns.
From sheet1 i want to find and move all the duplicate values in the sheet 2
and I need a macro,a code macro to work at the level of the sheets,
Sheet1-Sheet2
I want to move cut/paste all values duplicates 2 times 3
Dear Mahesh,
Thanks a lot for your reply :)[?]
again Thanks a lot for solving my problem i have found my ans in this link
Regards
Abhishek
On Wed, Feb 19, 2014 at 12:17 AM, Mahesh Parab mahes...@gmail.com wrote:
Hi Abhishek
Try : UDF mention on below link