Thanks Damimkader. I will try and let you know.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Damimkader S. Meeran"
Date: Thu, 22 Mar 2012 05:20:05
To:
Cc:
Subject: Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial
nu
t to insert 3 column in between (I.e 4,5,6).
>
> Sandeep Chhajer.
>
>
> Sent on my BlackBerry® from Vodafone
> --
> *From: * "Damimkader S. Meeran"
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 22 Mar 2012 03:57:16 -0700 (PDT)
> *To: *
cel-macros@googlegroups.com
Date: Thu, 22 Mar 2012 03:57:16
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial
numbers.
Hi Sandeep,
Before I proceed to modify the code, could you let me know the following
1. Which version of exc
Hi Sandeep,
Before I proceed to modify the code, could you let me know the following
1. Which version of excel are you using
2. Do you want the code to insert the rows equivalent to the missing serial
numbers for e.g. if after number 3 you have 7, do you want the code to
insert 4 rows in the mi
Dear Damimkader,
while I am running this code I am getting the follwing error code
run time error 13
type mismatch
please help.
My problem has been reproduced
My current Data is like thisSr. No. S_DISNO S_DISC S_UNIT S_SELP Purchse
quantity 495061 358 SILK DUPPATTA 0.90m 260.00 36.0
Hi Sandeep,
My code below assumes the following
1. The serial numbers are in column A
2. The Excel version you are using is 2007.
3. The code is good for 10,000 rows. Please modify if required.
Sub Serial()
Dim i As Long
For i = 1 To 1
If Cells(i, 1) <> "" And Cells(i + 1, 1) <> "" Then