How to increment numbers automatically in excel using macro

Closed
Bhavanim Posts 2 Registration date Thursday September 5, 2013 Status Member Last seen September 5, 2013 - Sep 5, 2013 at 03:57 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 5, 2013 at 08:58 AM
Hi,
I have a column A1 which has values like Tc001 and B1 and Tc002 > I just want to increment only the numbers. How can i achieve it using macros?

Regards,
Bhavani
Related:

4 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 5, 2013 at 07:47 AM
in excel 2007
clcik excel icon on top left and click excel options
click advanced
check (put a tick) against
"enable fill handle and cell drag-on ....."

hit ok at the bottom


type in A1
TC001
take the cursor to bottom right of A1
The cursor will become plus sign(+)
click this plus, hold and drag down as many cells as you like.
Bhavanim Posts 2 Registration date Thursday September 5, 2013 Status Member Last seen September 5, 2013
Sep 5, 2013 at 07:51 AM
I am not able to do this when it is a merged cell. Can u help me in this?
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 5, 2013 at 08:56 AM
why merge cells? is it for sosmetic purposes. iln that case demerge and do this and merge again. otheriwse post the data. or send the file through speedyshare.com
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 5, 2013 at 08:58 AM
try at the end of the merged cells. does it work.