Upper limit on data transpose

[amreimer]

Hello everyone, I have a long macro that takes a csv file where each row represents a family and transposes it by family such that each row represents a child. I have used this macro succesfully for a few years, although there are more students this year than any prior year. Fow some reason the output worksheet w.S does not include the last few students (starting at row 115, student 114). It is not a data problem (the last families records are not transposed even if I swich the last record for one that I know works). Any ideas? The code pertaining to this operation is below. Thanks
+++++++++++++++++++++++++++++++++++++
'Transpose

Please Login or Register  to view this content.

[amreimer]

I should mention when I created this several years ago I learned some basic vba operation but I am not an expert, and i'm rusty. Don't assume I'm aware of something obvious.

[alansidman]

Rule 03: Code Tags
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them for you today. Please read all Forum Rules and comply in the future.)

[notreallyIT]

Is this line of code to find the last used row?

Please Login or Register  to view this content.

If so, and there is a column which you know is always populated on every row, try swapping this out for

Please Login or Register  to view this content.

Where 1 is the column number (so "a")

[amreimer]

Wow, that was quick. First off, sorry about the code tags. I'll do better in the future. Second, my problem is fixed. Thank you very much.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.