Hi,
I have a workbook I am working on. When I copy a sheet and try to run the Macro Button to insert Flight (specified No. of Rows), the rows are being inserted to the sheet copied from only. How do I work around this? I want the rows to be inserted on the Active sheet don't matter how much times I copy one of the existing sheets. I know I can do this manually for each sheet copied, but I want to avoid it, since others would not know what to do. The sample file is attached with the codes/module that are being used.
Thank you very much in advance
CLRamjit
I have a workbook I am working on. When I copy a sheet and try to run the Macro Button to insert Flight (specified No. of Rows), the rows are being inserted to the sheet copied from only. How do I work around this? I want the rows to be inserted on the Active sheet don't matter how much times I copy one of the existing sheets. I know I can do this manually for each sheet copied, but I want to avoid it, since others would not know what to do. The sample file is attached with the codes/module that are being used.
Thank you very much in advance
CLRamjit