@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
Selection.
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 ku
To post to this group, send email to excel-macros@googlegroups.com
2011/2/23 кαяαηη yα∂αν
>
> To post to this group, send email to excel-macros@googlegroups.com
>
--
--
Some important links for excel users:
1. F
hi
+ sign was earlier used in lotus, excel has changed the syntax to =
you can use = or =+ will give the same result
On Thu, Feb 24, 2011 at 1:07 AM, Jenie wrote:
> Hello excel experts, what is the importance of using *+ *in formula as
> shown below? I the plus sign, still the formula worked
Hi all,
I have a Sales Tracking workbook. I have 2 issues that I can't seem to
resolve.
1. When the UserForm to add sales is closed I want all sheets to
refresh. I am using:
ActiveWorkbook.RefreshAll
It refreshes everything EXCEPT the Sales Analysis sheet. I have to
manually refresh the Pivot T
Hello excel experts, what is the importance of using + in formula as shown
below? I the plus sign, still the formula worked correct!!!
=+IF(A5="VP","Pass",IF(A5="Step","Complete",""))
=IF(A5="VP","Pass",IF(A5="Step","Complete",""))
Thanks
From: excel-macros@googlegroups.com [mailto:excel-
Thanks a lot Paul, Harmeet , Ayush and experts for help.
I will let you soon if it works.
regards
Hems
On Wed, Feb 23, 2011 at 7:28 PM, Paul Schreiner wrote:
> See if you can follow this:
> (file attached)
>
> Module1:
>
> Option Explicit
> Sub Save_File()
> Dim fso, DrvLt, Fldr1, Fldr2, FN
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 w
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
This is what I ended up using. Take in mind I was looking in column
B. Work great. Thanks for all your help and suggestions and getting
back so fast.
Sub InsertRowChange()
Dim i, j, k, z As Long
k = Range("b65356").End(xlUp).Row
Debug.Print k
For i = k To 2 Step -1
If Cells(i, 2).T
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
Selecti
Send an email with the subject being what you need help with (title)
to: excel-macros@googlegroups.com, and then attach file.
On Feb 23, 5:30 am, кαяαηη yα∂αν wrote:
> Hi..Experts,
>
> I need your help.I am unable to attach my file. Pls tell me where
> I can attach file.
>
> Thnx
>
> Karan
-
Hi..Experts,
I need your help.I am unable to attach my file. Pls tell me where
I can attach file.
Thnx
Karan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
I think, it could be with IF Formula
For Example
'(=IF(D7="step","complete",IF(D7="vp","pass",""))'
if value in D7 Cell.
On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote:
> Hello Excel Gurus,
>
> Need small favour from experts,
> I have two columns in Excel, I need a macro, where if Column A
Just add add the following to the condition
If Sheets(1).Cells(i, 1).Text <> Sheets(1).Cells(i - 1, 1).Text and
Len( Sheets(1).Cells(i - 1, 1).Text) > 0 Then
On Wed, Feb 23, 2011 at 1:51 PM, Omar wrote:
> When we run macro again it insert two blank lines
>
>
>
>
>
> *From:* excel-macros@go
file is attached. Please help.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Dear Ayush Ji
*Ex-n-Trick-in-XL (Excentric in Excel)*
Thanks & Regds,
ROHAN
On Wed, Feb 23, 2011 at 1:38 PM, §»VIPER«§ wrote:
> Dear Ayush,
>
> "ICE" (INTENSIVE CARE in EX(CELL)
>
>
> --
> Thanks & Regards
>
> Thamu
>
>
> On 2/22/11, Ayush Jain wrote:
> > Dear members,
> >
> > I am too excit
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
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 in
good
On Wed, Feb 23, 2011 at 11:13 AM, Harmeet Singh wrote:
> 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 wrote:
>
>> you want to save blank e
Dear Ayush,
"ICE" (INTENSIVE CARE in EX(CELL)
--
Thanks & Regards
Thamu
On 2/22/11, Ayush Jain 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
> our Google group
21 matches
Mail list logo
