Autofill numbers using Macro

[kamalthakur]

Hi All,

I have recorded a macro and it is working fine

My query is while the macro is running a column is inserted and numbers are autofilled

Please Login or Register  to view this content.

But I want as solution like if there is data only till B24 then It should fill upto A2:A24

[pike]

hi kamalthakur
add some code tags and get the answer as is quite straight forward

[rwgrietveld]

Listen to Pike. Do that first and then use this code

Range("A2:A61") can be changed in a dynamic range

Please Login or Register  to view this content.

[contaminated]

try this

Please Login or Register  to view this content.

[pike]

dude's still no tags!! no tags no posts

[DonkeyOte]

Guys, the fact that a non Mod requested an OP modify their post in line with the rules does not make one iota of difference regards to posting on a thread thereafter.

You (rwg, c) both know the rules well enough yourselves ... please consider this a (final) friendly reminder of that fact ...

If I see a non-Mod inform re: rule I see no reason to do likewise (for fear of overwhelming OP) - however on that basis I expect others to use their own judgement and not post either until rule is complied with.

Please do not create extra work for the Mods by ignoring the postings of your fellow members to the extent that Mods are compelled to duplicate the warning ... we'd rather spend our time answering than administering.

[pike]

Hi kamalthakur
If you are unsure on how to add code tags click on the link in my signature
as the answer is still quite straight forward

[pike]

my take

Please Login or Register  to view this content.

[DonkeyOte]

Pike, now you break your own rule...

So that I can stop watching this thread I've added the tags... please refrain from these practices going forward.

[kamalthakur]

Thank you for the response I was away from my system.

I have copied the code and pasted and it is working but the number increment is not happening

Any clue on this

[pike]

will do DonkeyOte had a rush to the brain
Hi kamalthakur
whats the formula in A2?

[kamalthakur]

Below is the code you gave to me

With Range("A2")
.AutoFill Destination:=Range("A2:A" & Cells(Rows.Count, 2).End(xlUp).Row)
End With

there is no formula when i run the macro from cell A2 the numbers should start like a2=1 a3=2 this should increase till there is a value in B column

[pike]

Now kamalthakur
I have the solution in my hot little hand but for the answer, so it wont go past 24 row ,you must MUST add the code tags to the last post
eg

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

[kamalthakur]

Ok Pike below is the code

{code}
Range("A2").Select
ActiveCell.FormulaR1C1 = "1"
Range("A3").Select
ActiveCell.FormulaR1C1 = "2"
Range("A2:A3").Select
With Range("A2")
.AutoFill Destination:=Range("A2:A" & Cells(Rows.Count, 2).End(xlUp).Row)
End With
{code}

[rwgrietveld]

[pike]

close but no cigar replace the first { code} with [ code] and the second {code} with [/code]

[pike]

its like looking into a mirror ...... great minds ....

[kamalthakur]

Please Login or Register  to view this content.

[rwgrietveld]

Edit. reason: No added value

[pike]

beautiful

Please Login or Register  to view this content.

[kamalthakur]

Fine Please delete it i never new a new person if doesn't know how use the tags this is not the way to respond him

[kamalthakur]

You mean to say that it will take upto 24 fourth row
My query is if cell B70 has data it should increment till B70
so whenever i run the macro it should first check till which in B column the data is and then it should increment the number in first column

[pike]

Hi kamalthakur
dont be like that, there are a few rules .. which should have to read .. it explains the tags
and how once you have so many post that you need to add the tags
Look at my Public Profile I've had four infractions .. no sweat .. It very friendly here
please dont be offended. your problem was fun to solve and when you hang around for a while you will be answering questions and will laugh when you remember your first couple of posts
the mod are pretty good they let the members answer the posts and only come in if they are off the mark.
Yes there are rules but they help keep order for those who come after searching for similar questions
the tag are important and help make the code easier to read.

its no biggie you now know how to add the tags: now - you did better that me when i first started

[pike]

my bad

Please Login or Register  to view this content.

[pike]

no RC code are better \

Please Login or Register  to view this content.

[pike]

Hi kamalthakur

Please Login or Register  to view this content.

dont forget
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save