No. of Row = No. of inputs

Hi guys, Hope you can help with my situation.
Here's the scenario I need to create a vba macro that can place a constant text in other column.
For example,
Excel.JPG
as you can see in the attachment, the no. of text("TC") proportional to the no. of Row in column A.
this column A and the no of Row will be user input. As long as the user input more row in Column A it will also generate a text("TC") every 3 row

Hoping for the best and thank you in advance

Please Login or Register  to view this content.

Regards, TMS

Hi there !

Application.ScreenUpdating = False
Turns screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster.

You're welcome


What bulina2k said


Regards, TMS


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Originally Posted by apo

Here's another for fun..

Please Login or Register  to view this content.

for fun.. but for learning purposes also! very nice code!