Sorry if I've been too vague, I was trying to keep it simple. This word doc will allow forensic firearms examiners to document their examinations. The functionality has to be that the examiner can change the results section of any worksheets as needed and which frequently happens as a result of the review process of the case they're working on. Also by doing it this way, the compiler can be run again as many times as needed when changes are made.
That being said, each worksheet's last row is formatted identically - one column only that spans the width of the table. The destination cell is in a nested table that I have no control over. The code I posted originally pastes into the correct cell in that table (Cell 1, 2 of the nested table in the Results of Examination section). My problem is that the code isn't correctly identifying the last row in each worksheet unless the cursor is in the longest worksheet.
I've uploaded a worksheet (docm) that has been filled out. The code in question is in a macro called 'Results'.
I hope this clears things up. Thank you!
|