Probs while running macro
Hi guy's iam new to this Excel VBA Community, I use search for the Access issues and now i am have an problem while runing the macro in Excel.I am using an macro which having the foloing property:
I got two xls working sheet "Macro","Result". The data which is going to sorted ill be pasted in the marco sheet. When macro is runnig first the format and other processs are doned then the old data in the Result sheet is deleted (i.e.) that is the whole sheet is deleted from the Xls file and new sheet is instered and renamed as result by macro. It show error while the new sheet name is deducting different . Iam not intrested in deleting the data in the result Xls worksheet . I want to delete the work sheet itself.
pls help me in this issue..
Thanks in advance......:)