importing file using macro and all rows don't appear?
 

I've just created a macro in excel 2003 and saved it as a personal macro.
When I import new data using the macro and there are more rows than the macro
remembered I only get that amount of rows. What should I do so that I can
make the last row variable?
Thanks!
Michael

importing file using macro and all rows don't appear?
 

What do you have in your macro at the moment?

"Michael" wrote:

I've just created a macro in excel 2003 and saved it as a personal macro.
When I import new data using the macro and there are more rows than the macro
remembered I only get that amount of rows. What should I do so that I can
make the last row variable?
Thanks!
Michael

importing file using macro and all rows don't appear?
 

8000 rows and 22 colums. When I import a file with 14000 rows, I only get
8000 rows of the new data.

"bigwheel" wrote:

What do you have in your macro at the moment?

"Michael" wrote:

I've just created a macro in excel 2003 and saved it as a personal macro.
When I import new data using the macro and there are more rows than the macro
remembered I only get that amount of rows. What should I do so that I can
make the last row variable?
Thanks!
Michael

importing file using macro and all rows don't appear?
 

Show your current code.

--
Tim Williams
Palo Alto, CA


"Michael" wrote in message ...
8000 rows and 22 colums. When I import a file with 14000 rows, I only get
8000 rows of the new data.

"bigwheel" wrote:

What do you have in your macro at the moment?

"Michael" wrote:

I've just created a macro in excel 2003 and saved it as a personal macro.
When I import new data using the macro and there are more rows than the macro
remembered I only get that amount of rows. What should I do so that I can
make the last row variable?
Thanks!
Michael