VBA to autofill number till last row

**shiva_reshs** · 08-21-2014, 08:49 AM

Hello,

I have data in which I want VBA to autofill number to 1, 2, 3, 4 till last filled row of the Adjustment cell.

Please Login or Register  to view this content.

I tired with this code, but not working.

Please advice,

Thanks,
Shiva

**satputenandkumar0** · 08-21-2014, 08:57 AM

try

Please Login or Register  to view this content.

**shiva_reshs** · 08-21-2014, 08:57 AM

Thanks a lot. Code works well.

**satputenandkumar0** · 08-21-2014, 09:00 AM

Glad to help you.

**shiva_reshs** · 08-21-2014, 10:03 AM

weird. It was working fine. but now I get

Run Time Error '13 : Time Mismatch on below line

Please Login or Register  to view this content.

**satputenandkumar0** · 08-21-2014, 10:12 AM

try below

Please Login or Register  to view this content.

If not solved
Please attach sample file

**JOHN H. DAVIS** · 08-21-2014, 10:18 AM

Another approach:

Please Login or Register  to view this content.

**shiva_reshs** · 08-21-2014, 12:18 PM

Nice.. Working fine now.

Thanks,
Shiva

**JOHN H. DAVIS** · 08-21-2014, 01:09 PM

You're welcome. Glad to help out and thanks for the feedback and the rep.

**jindon** · 08-21-2014, 01:16 PM

Why not AutoFill?

Please Login or Register  to view this content.

Re: VBA to autofill number till last row