Count number of Imported lines

[Bytor47]

Hi,

I have inherited a spreadsheet that will open up a raw data file and import the data after removing unwanted header info. I would like to somehow count the number of lines that have been imported so that I can do some further tweeking. I am guessing this is where I would need to add it.

Here is the code that is doing the copying from the input file:

Please Login or Register  to view this content.

If it's better to count the lines when pasting then here is the code that does that:

Please Login or Register  to view this content.

Any help is greatly appreciated.

Thanks

[Leith Ross]

Hello Bytor47,

I have added some code to the routine to display a message box with the line count.

Please Login or Register  to view this content.

Sincerely,
Leith Ross