View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default What's command for find sheets exist in workbooks?

I need your help for command of VBA
what's command for "find sheets("A")=ture"
please refer to under information.

if "find sheets("A")=ture" then
Worksheets("A").Delete
end if
ActiveWorkbook.Worksheets.Add
rename = ActiveSheet.Name
Worksheets(rename).Name = "A"