the macro is cool and I see what you did in the code so i can modify it, but for the novice - can you modify it to ask (when you press "Run") how many rows I want in the column and autosize based on that parameter?