Re: $$Excel-Macros$$ Numbering

2011-07-13 Thread karan 1237 
Hey ankur,

I want to ask something

Sub test()
Sheet1.Range("A2:A15").Clear
Dim i, j As Long
Range("a1").Value = InputBox("put your value")
For i = 1 To Sheets(1).Cells(1, 1).Value
Cells(i + 1, 1).Value = i

Next i
End Sub

In this code what is "i" & "j" ?

*

Kαяαη*



On Mon, Jul 11, 2011 at 1:37 PM, ankur  wrote:

> *hi kalyan
> as per ur requirementfind the solution...tell me if it helps u ..
>
> *Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Mon, Jul 11, 2011 at 9:49 AM, santosh bahuguna <
> santoshbahug...@gmail.com> wrote:
>
>>
>> Please find the attached file and let me know if is this you are looking
>> for
>>
>>
>> Regards
>> Santosh Bahuguna
>>
>> On Sat, Jul 9, 2011 at 1:42 PM, karunanithi ramaswamy 
>> wrote:
>>
>>> Mr Santhosh,
>>>   your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
>>>  i.e., REQUIRED NUMBERING  FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
>>> AM I RIGHT?
>>> R.KARUNANITHI
>>>
>>> --- On *Sat, 7/9/11, santosh bahuguna *wrote:
>>>
>>>
>>> From: santosh bahuguna 
>>>
>>> Subject: Re: $$Excel-Macros$$ Numbering
>>> To: excel-macros@googlegroups.com
>>> Date: Saturday, July 9, 2011, 3:59 AM
>>>
>>>
>>> Use Simple formula
>>>
>>> =COUNTIF(A$1:A1,A1)
>>>
>>>
>>> Please let me know if you looking for this only
>>>
>>>
>>> Regards
>>> Santosh Bahuguna
>>>
>>>
>>>
>>> On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma 
>>> http://mc/compose?to=rajanverma1...@gmail.com>
>>> > wrote:
>>>
>>>  *Hi
>>> Try this*
>>>
>>> * *
>>>
>>> *Private Sub Worksheet_Change(ByVal Target As Range)*
>>>
>>> *On Error GoTo Err:*
>>>
>>> *If Target = Range("A1") Then*
>>>
>>> *For i = 1 To Range("A1").Value*
>>>
>>> *Range("A" & i + 1).Value = i*
>>>
>>> *Next*
>>>
>>> *End If*
>>>
>>> *Err:*
>>>
>>> *End Sub*
>>>
>>> * *
>>>
>>> *From:* 
>>> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>[mailto:
>>> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>]
>>> *On Behalf Of *NOORAIN ANSARI
>>> *Sent:* Friday, July 08, 2011 5:38 PM
>>> *To:* 
>>> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
>>> *Cc:* Kal xcel
>>> *Subject:* Re: $$Excel-Macros$$ Numbering
>>>
>>> ** **
>>>
>>> kalyan babu.
>>>
>>> Please try it..also
>>>
>>>  
>>>
>>> =IF(A2="","",COUNTA($A$2:A2))
>>>
>>> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel 
>>> http://mc/compose?to=kalx...@gmail.com>>
>>> wrote:
>>>
>>> Dear Experts,
>>>
>>>  
>>>
>>> I want the formula for below mention query...
>>>
>>>  
>>>
>>> user will put 100 in A1, from A2 autometically numbering will start like
>>> this
>>>
>>>  
>>>
>>> A21
>>>
>>> A32
>>>
>>> A43
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>>  
>>>
>>> till 100
>>>
>>>  
>>>
>>> What will be the formula??
>>>
>>>  
>>>
>>> Please help
>>>
>>>  
>>>
>>> Thanks in advance
>>>
>>>  
>>>
>>> Kalyan Chatterjee
>>>
>>>  
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Jo

Re: $$Excel-Macros$$ Numbering

2011-07-12 Thread Kal xcel 
Thank you all...

On Mon, Jul 11, 2011 at 1:37 PM, ankur  wrote:

> *hi kalyan
> as per ur requirementfind the solution...tell me if it helps u ..
>
> *Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Mon, Jul 11, 2011 at 9:49 AM, santosh bahuguna <
> santoshbahug...@gmail.com> wrote:
>
>>
>> Please find the attached file and let me know if is this you are looking
>> for
>>
>>
>> Regards
>> Santosh Bahuguna
>>
>> On Sat, Jul 9, 2011 at 1:42 PM, karunanithi ramaswamy 
>> wrote:
>>
>>>   Mr Santhosh,
>>>   your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
>>>  i.e., REQUIRED NUMBERING  FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
>>> AM I RIGHT?
>>> R.KARUNANITHI
>>>
>>> --- On *Sat, 7/9/11, santosh bahuguna *wrote:
>>>
>>>
>>> From: santosh bahuguna 
>>>
>>> Subject: Re: $$Excel-Macros$$ Numbering
>>> To: excel-macros@googlegroups.com
>>> Date: Saturday, July 9, 2011, 3:59 AM
>>>
>>>
>>> Use Simple formula
>>>
>>> =COUNTIF(A$1:A1,A1)
>>>
>>>
>>> Please let me know if you looking for this only
>>>
>>>
>>> Regards
>>> Santosh Bahuguna
>>>
>>>
>>>
>>> On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma 
>>> http://mc/compose?to=rajanverma1...@gmail.com>
>>> > wrote:
>>>
>>>  *Hi
>>> Try this*
>>>
>>> * *
>>>
>>> *Private Sub Worksheet_Change(ByVal Target As Range)*
>>>
>>> *On Error GoTo Err:*
>>>
>>> *If Target = Range("A1") Then*
>>>
>>> *For i = 1 To Range("A1").Value*
>>>
>>> *Range("A" & i + 1).Value = i*
>>>
>>> *Next*
>>>
>>> *End If*
>>>
>>> *Err:*
>>>
>>> *End Sub*
>>>
>>> * *
>>>
>>> *From:* 
>>> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>[mailto:
>>> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>]
>>> *On Behalf Of *NOORAIN ANSARI
>>> *Sent:* Friday, July 08, 2011 5:38 PM
>>> *To:* 
>>> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
>>> *Cc:* Kal xcel
>>> *Subject:* Re: $$Excel-Macros$$ Numbering
>>>
>>> ** **
>>>
>>> kalyan babu.
>>>
>>> Please try it..also
>>>
>>>  
>>>
>>> =IF(A2="","",COUNTA($A$2:A2))
>>>
>>> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel 
>>> http://mc/compose?to=kalx...@gmail.com>>
>>> wrote:
>>>
>>> Dear Experts,
>>>
>>>  
>>>
>>> I want the formula for below mention query...
>>>
>>>  
>>>
>>> user will put 100 in A1, from A2 autometically numbering will start like
>>> this
>>>
>>>  
>>>
>>> A21
>>>
>>> A32
>>>
>>> A43
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>>  
>>>
>>> till 100
>>>
>>>  
>>>
>>> What will be the formula??
>>>
>>>  
>>>
>>> Please help
>>>
>>>  
>>>
>>> Thanks in advance
>>>
>>>  
>>>
>>> Kalyan Chatterjee
>>>
>>>  
>>>
>>> --
>>>
>>> --
>>> 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 @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to 
>>> excel-macros@googlegroups.com<http://mc/compose?to=

Re: $$Excel-Macros$$ Numbering

2011-07-10 Thread santosh bahuguna 
Please find the attached file and let me know if is this you are looking
for


Regards
Santosh Bahuguna

On Sat, Jul 9, 2011 at 1:42 PM, karunanithi ramaswamy wrote:

> Mr Santhosh,
>   your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
>  i.e., REQUIRED NUMBERING  FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
> AM I RIGHT?
> R.KARUNANITHI
>
> --- On *Sat, 7/9/11, santosh bahuguna * wrote:
>
>
> From: santosh bahuguna 
>
> Subject: Re: $$Excel-Macros$$ Numbering
> To: excel-macros@googlegroups.com
> Date: Saturday, July 9, 2011, 3:59 AM
>
>
> Use Simple formula
>
> =COUNTIF(A$1:A1,A1)
>
>
> Please let me know if you looking for this only
>
>
> Regards
> Santosh Bahuguna
>
>
>
> On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma 
> http://mc/compose?to=rajanverma1...@gmail.com>
> > wrote:
>
>  *Hi
> Try this*
>
> * *
>
> *Private Sub Worksheet_Change(ByVal Target As Range)*
>
> *On Error GoTo Err:*
>
> *If Target = Range("A1") Then*
>
> *For i = 1 To Range("A1").Value*
>
> *Range("A" & i + 1).Value = i*
>
> *Next*
>
> *End If*
>
> *Err:*
>
> *End Sub*
>
> * *
>
> *From:* 
> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>[mailto:
> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>]
> *On Behalf Of *NOORAIN ANSARI
> *Sent:* Friday, July 08, 2011 5:38 PM
> *To:* 
> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
> *Cc:* Kal xcel
> *Subject:* Re: $$Excel-Macros$$ Numbering
>
> ** **
>
> kalyan babu.
>
> Please try it..also
>
>  
>
> =IF(A2="","",COUNTA($A$2:A2))
>
> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel 
> http://mc/compose?to=kalx...@gmail.com>>
> wrote:
>
> Dear Experts,
>
>  
>
> I want the formula for below mention query...
>
>  
>
> user will put 100 in A1, from A2 autometically numbering will start like
> this
>
>  
>
> A21
>
> A32
>
> A43
>
> .
>
> .
>
> .
>
> .
>
>  
>
> till 100
>
>  
>
> What will be the formula??
>
>  
>
> Please help
>
>  
>
> Thanks in advance
>
>  
>
> Kalyan Chatterjee
>
>  
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to 
> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> 
>
> ** **
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to 
> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.c

Re: $$Excel-Macros$$ Numbering

2011-07-09 Thread karunanithi ramaswamy 
Mr Santhosh,
  your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
 i.e., REQUIRED NUMBERING  FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
AM I RIGHT?
R.KARUNANITHI

--- On Sat, 7/9/11, santosh bahuguna  wrote:

From: santosh bahuguna 
Subject: Re: $$Excel-Macros$$ Numbering
To: excel-macros@googlegroups.com
Date: Saturday, July 9, 2011, 3:59 AM

Use Simple formula 

=COUNTIF(A$1:A1,A1)


Please let me know if you looking for this only 


Regards
Santosh Bahuguna 



On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma  wrote:














Hi

Try this

 

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo Err:

If Target = Range("A1") Then

For i = 1 To Range("A1").Value

Range("A" & i + 1).Value = i

Next

End If

Err:

End Sub

 



From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI

Sent: Friday, July 08, 2011 5:38 PM

To: excel-macros@googlegroups.com

Cc: Kal xcel

Subject: Re: $$Excel-Macros$$ Numbering



 



kalyan babu.





Please try it..also





 





=IF(A2="","",COUNTA($A$2:A2))





On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:



Dear Experts,





 





I want the formula for below mention query...





 





user will put 100 in A1, from A2 autometically
numbering will start like this





 





A2    1





A3    2





A4    3





.





.





.





.





 





till 100





 





What will be the formula??





 





Please help





 





Thanks in advance





 





Kalyan Chatterjee





 



-- 

--

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 @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel









-- 



Thanks
& regards,





Noorain
Ansari





http://noorain-ansari.blogspot.com/



 

-- 

--

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 @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel









-- 

--

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 @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel






-- 

--

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 @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

-- 
---

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread Haseeb Avarakkan 
A2, copy down as many needed

=IF(ROWS(A$2:A2)<=A$1,ROWS(A$2:A2),"")

Or, If you are inserting rows between A2 & the last rows this will not work 
as expected, so use this one;

=IF(COUNT(A$1:A1)<=A$1,COUNT(A$1:A1),"")

copy down as many needed

HTH
Haseeb

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread santosh bahuguna 
and if you want opposite
then use

=COUNTIF(A1:A100,A1)

then it will be
A1 : 100 result be will B1 : 100
A2 : 100  B2 : 99
A3 : 100  B3 : 98
A4 : 100  B4 : 97
A5 : 100  B5 : 96
A6 : 100  B6 : 95

Regards
Santosh Bahuguna




On Fri, Jul 8, 2011 at 3:29 PM, santosh bahuguna
wrote:

> Use Simple formula
>
> =COUNTIF(A$1:A1,A1)
>
>
> Please let me know if you looking for this only
>
>
> Regards
> Santosh Bahuguna
>
>
>
> On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma wrote:
>
>>  *Hi
>> Try this*
>>
>> * *
>>
>> *Private Sub Worksheet_Change(ByVal Target As Range)*
>>
>> *On Error GoTo Err:*
>>
>> *If Target = Range("A1") Then*
>>
>> *For i = 1 To Range("A1").Value*
>>
>> *Range("A" & i + 1).Value = i*
>>
>> *Next*
>>
>> *End If*
>>
>> *Err:*
>>
>> *End Sub*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
>> *Sent:* Friday, July 08, 2011 5:38 PM
>> *To:* excel-macros@googlegroups.com
>> *Cc:* Kal xcel
>> *Subject:* Re: $$Excel-Macros$$ Numbering
>>
>> ** **
>>
>> kalyan babu.
>>
>> Please try it..also
>>
>>  
>>
>> =IF(A2="","",COUNTA($A$2:A2))
>>
>> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:
>>
>> Dear Experts,
>>
>>  
>>
>> I want the formula for below mention query...
>>
>>  
>>
>> user will put 100 in A1, from A2 autometically numbering will start like
>> this
>>
>>  
>>
>> A21
>>
>> A32
>>
>> A43
>>
>> .
>>
>> .
>>
>> .
>>
>> .
>>
>>  
>>
>> till 100
>>
>>  
>>
>> What will be the formula??
>>
>>  
>>
>> Please help
>>
>>  
>>
>> Thanks in advance
>>
>>  
>>
>> Kalyan Chatterjee
>>
>>  
>>
>> --
>>
>> --
>> 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 @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>
>>
>>
>> -- 
>>
>> Thanks & regards,
>>
>> Noorain Ansari
>>
>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>> 
>>
>> ** **
>>
>> --
>>
>> --
>> 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 @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> 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 @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread santosh bahuguna 
Use Simple formula

=COUNTIF(A$1:A1,A1)


Please let me know if you looking for this only


Regards
Santosh Bahuguna



On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma wrote:

>  *Hi
> Try this*
>
> * *
>
> *Private Sub Worksheet_Change(ByVal Target As Range)*
>
> *On Error GoTo Err:*
>
> *If Target = Range("A1") Then*
>
> *For i = 1 To Range("A1").Value*
>
> *Range("A" & i + 1).Value = i*
>
> *Next*
>
> *End If*
>
> *Err:*
>
> *End Sub*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* Friday, July 08, 2011 5:38 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* Kal xcel
> *Subject:* Re: $$Excel-Macros$$ Numbering
>
> ** **
>
> kalyan babu.
>
> Please try it..also
>
>  
>
> =IF(A2="","",COUNTA($A$2:A2))
>
> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:
>
> Dear Experts,
>
>  
>
> I want the formula for below mention query...
>
>  
>
> user will put 100 in A1, from A2 autometically numbering will start like
> this
>
>  
>
> A21
>
> A32
>
> A43
>
> .
>
> .
>
> .
>
> .
>
>  
>
> till 100
>
>  
>
> What will be the formula??
>
>  
>
> Please help
>
>  
>
> Thanks in advance
>
>  
>
> Kalyan Chatterjee
>
>  
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> 
>
> ** **
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Numbering

2011-07-08 Thread Rajan_Verma 
Hi
Try this

 

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo Err:

If Target = Range("A1") Then

For i = 1 To Range("A1").Value

Range("A" & i + 1).Value = i

Next

End If

Err:

End Sub

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Friday, July 08, 2011 5:38 PM
To: excel-macros@googlegroups.com
Cc: Kal xcel
Subject: Re: $$Excel-Macros$$ Numbering

 

kalyan babu.

Please try it..also

 

=IF(A2="","",COUNTA($A$2:A2))

On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:

Dear Experts,

 

I want the formula for below mention query...

 

user will put 100 in A1, from A2 autometically numbering will start like
this

 

A21

A32

A43

.

.

.

.

 

till 100

 

What will be the formula??

 

Please help

 

Thanks in advance

 

Kalyan Chatterjee

 

-- 

--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/> 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 

Thanks & regards,

Noorain Ansari

 <http://noorain-ansari.blogspot.com/> http://noorain-ansari.blogspot.com/

 

-- 

--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread NOORAIN ANSARI 
Dear Kalyan,

Please try it

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i, j, k As Long
i = Sheet1.Range("A1").Value
Sheet1.Range("A2:A1000").Clear
For j = 2 To i + 1
Sheet1.Cells(j, 1).Value = k + 1
k = k + 1
Next
End Sub

-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

On Fri, Jul 8, 2011 at 6:07 PM, ashish koul  wrote:

> try this
>
>
> On Fri, Jul 8, 2011 at 5:40 PM, Kal xcel  wrote:
>
>> Dear Ashish,
>>
>> I want the numbering will start frm 1 and it will end at the number given
>> by user, like if user put 100 so numbering 1,2,3,4,5,6,7100, if
>> user put 200 numbering will start from 1,2,3,4,5,6,7,8,9,10200.
>>
>> I think you got what I am saying.
>>
>> Thanks in advance
>>
>> Kalyan
>>
>> On Fri, Jul 8, 2011 at 5:29 PM, ashish koul wrote:
>>
>>> a2= a1+1
>>>
>>>
>>> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:
>>>
 Dear Experts,

 I want the formula for below mention query...

 user will put 100 in A1, from A2 autometically numbering will start like
 this

 A21
 A32
 A43
 .
 .
 .
 .

 till 100

 What will be the formula??

 Please help

 Thanks in advance

 Kalyan Chatterjee


 --

 --
 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 @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> http://akoul.posterous.com/
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>   --
>>>
>>> --
>>> 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 @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> 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 @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread ashish koul 
try this

On Fri, Jul 8, 2011 at 5:40 PM, Kal xcel  wrote:

> Dear Ashish,
>
> I want the numbering will start frm 1 and it will end at the number given
> by user, like if user put 100 so numbering 1,2,3,4,5,6,7100, if
> user put 200 numbering will start from 1,2,3,4,5,6,7,8,9,10200.
>
> I think you got what I am saying.
>
> Thanks in advance
>
> Kalyan
>
> On Fri, Jul 8, 2011 at 5:29 PM, ashish koul  wrote:
>
>> a2= a1+1
>>
>>
>> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:
>>
>>> Dear Experts,
>>>
>>> I want the formula for below mention query...
>>>
>>> user will put 100 in A1, from A2 autometically numbering will start like
>>> this
>>>
>>> A21
>>> A32
>>> A43
>>> .
>>> .
>>> .
>>> .
>>>
>>> till 100
>>>
>>> What will be the formula??
>>>
>>> Please help
>>>
>>> Thanks in advance
>>>
>>> Kalyan Chatterjee
>>>
>>>
>>> --
>>>
>>> --
>>> 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 @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>>  *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>   --
>>
>> --
>> 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 @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


kal.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread Kal xcel 
Dear Ashish,

I want the numbering will start frm 1 and it will end at the number given by
user, like if user put 100 so numbering 1,2,3,4,5,6,7100, if
user put 200 numbering will start from 1,2,3,4,5,6,7,8,9,10200.

I think you got what I am saying.

Thanks in advance

Kalyan

On Fri, Jul 8, 2011 at 5:29 PM, ashish koul  wrote:

> a2= a1+1
>
>
> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:
>
>> Dear Experts,
>>
>> I want the formula for below mention query...
>>
>> user will put 100 in A1, from A2 autometically numbering will start like
>> this
>>
>> A21
>> A32
>> A43
>> .
>> .
>> .
>> .
>>
>> till 100
>>
>> What will be the formula??
>>
>> Please help
>>
>> Thanks in advance
>>
>> Kalyan Chatterjee
>>
>>
>> --
>>
>> --
>> 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 @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>   --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread NOORAIN ANSARI 
kalyan babu.
Please try it..also

=IF(A2="","",COUNTA($A$2:A2))

On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:

> Dear Experts,
>
> I want the formula for below mention query...
>
> user will put 100 in A1, from A2 autometically numbering will start like
> this
>
> A21
> A32
> A43
> .
> .
> .
> .
>
> till 100
>
> What will be the formula??
>
> Please help
>
> Thanks in advance
>
> Kalyan Chatterjee
>
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Numbering

2011-07-08 Thread ashish koul 
a2= a1+1


On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel  wrote:

> Dear Experts,
>
> I want the formula for below mention query...
>
> user will put 100 in A1, from A2 autometically numbering will start like
> this
>
> A21
> A32
> A43
> .
> .
> .
> .
>
> till 100
>
> What will be the formula??
>
> Please help
>
> Thanks in advance
>
> Kalyan Chatterjee
>
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel