I have to create a macro which consists on importing a text file and give some format. However the same text file can change its size. The problem I have is that after creating a macro for example with 20 rows, and I add more rows to the text file, if I run the macro again it will not recognize more than the 20 rows used originally to create the macro.

How can I customize the macro to take the amount of rows that are present in the text every time I have to run it.

Hope somebody can help me with this.

Thanks in advance,
Karolina