Quote Originally Posted by Beatrix View Post
Sorry I guess It's me,my English etc.. couldn't explain it properly. I meant data security policies, compliance policy etc.. I need to change my data but keep the structure as it is..
hi there. re to snb's comment: snb states that workbooks or worksheets may be protected. so remove the protection first. ----- and if you are not familiar with, adopt snb's codes to your workbook/worksheet structure. ----- from 'enabling the user to select the first row to start deleting rows' requirement i assume that the files are generated by some non MS office applications (or by different departments or or by different employees). so they dont have the same table structure and need to be made similar.