Thank you Andrew, I am very grateful for your reply. But when I declared module-level variable then while running the macro it said "Compile error" "By ref argument type mismatch" Can you please show the way to pass values correctly by modifying the code I posted. It would be of great help.