Dear Ayush,
ICE (INTENSIVE CARE in EX(CELL)
--
Thanks Regards
Thamu
On 2/22/11, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am too excited to share that discussexcel.com website development is in
good progress and we are ready to launch the website on 4th Anniversary of
good
On Wed, Feb 23, 2011 at 11:13 AM, Harmeet Singh harmeet.hew...@gmail.comwrote:
I Hope this will help.
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey Company
http://www.facebook.com/Harmeeet
On Wed, Feb 23, 2011 at 4:03 PM, ashish koul
When we run macro again it insert two blank lines
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, February 23, 2011 6:24 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Insert Row after Change in Value
If you're saying that the first time, it inserts a blank row,
but he second time you run it, it adds a second blank row, then
yes, it would, because it's comparing the blank line to a line with a value.
Since they are not equal, it adds another blank line.
You may need to change your IF statement
No
It still insert a new blank lines
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rakesh kumar
Sent: Wednesday, February 23, 2011 10:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Insert Row after Change in Value in a
Here is an example to replace sheet Batch column K with a macro:
Sub test()
'sheet Batch column K
With Sheets(Batch)
For Each c In .Range(.[A7], .[A65536].End(xlUp))
.Cells(c.Row, 11) = Evaluate(sumproduct((DB!$A$2:$A$46803=Batch!$A c.Row
)*(DB!$AP$2:$AP$46803=Yes)))
Next c
End With
Hi ashish sir,
thanks u for this ,but can u pls tell me how to use this because when
i del any status and enter other in same cell it gives some error and
basically i want that when ever any status updated in that column in
database rest values should come automatically
On 2/23/11, ashish koul
Hi Rakesh,
Thanks for your help.
I did not write this code. I found this template from the internet. I tried
to correct it and at the end I gave up.
I don't have much VB knowledge.
This is a great group and everybody is willing to help.
Regards,
San
On Wed, Feb 23, 2011 at 3:09 AM, rakesh
@omar - try this
Sub InsertRowChange()
Dim i, j, k, z As Long
k = Range(a65356).End(xlUp).Row
Debug.Print k
For i = k To 2 Step -1
If Not IsEmpty(Cells(i, 1)) And Not IsEmpty(Cells(i - 1, 1)) Then
If Cells(i, 1).Text Cells(i - 1, 1).Text Then
Range(a i).Select