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


--
Karolina
------------------------------------------------------------------------
Karolina's Profile: http://www.excelforum.com/member.php...o&userid=31600
View this thread: http://www.excelforum.com/showthread...hreadid=512902