Hi all, I want macro which should add WorkSheet and then check if
there are more WorkSheets in ActiveWorkbook, and if there are more
WorkSheets then check if any of those WorkSheet got name "Data". If
there is no WorkSheet with name "Data" then put name "Data" to new
added WorkSheet but if there is a WorkSheet with name "Data" then put
name "Data(1)" of new added WorkSheet, and if there are WorkSheets
with names "Data" and "Data(1)" then put name "Data(2)" of new added
WorkSheet and so on like (3),(4).... I hope i was able to explain what
i need. Please can any friend can help