Hey ankur,
I want to ask something
Sub test()
Sheet1.Range("A2:A150000").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 <ankurpande...@gmail.com> wrote:
> *hi kalyan
> as per ur requirement....find 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
>> <era_...@yahoo.com>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 <santoshbahug...@gmail.com>*wrote:
>>>
>>>
>>> From: santosh bahuguna <santoshbahug...@gmail.com>
>>>
>>> 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
>>> <rajanverma1...@gmail.com<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
>>> <kalx...@gmail.com<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****
>>>
>>> ****
>>>
>>> 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<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.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.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
>>
>
> --
>
> ----------------------------------------------------------------------------------
> 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
