save worksheet as per the active cell
Hi
i need a macro to save my excel file as per the activecell name
example: if my active cell is "A1" and in A1 i have typed a word called as
John, so the same workbook need to be saved in John's name to my C: drive.
|