View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ronnie_knight@msn.com is offline
external usenet poster
 
Posts: 2
Default named ranges in a For Loop

I'M SORRY! I had forgotton I had already posted this. Jim's solution
gives a Method 'Range' of object '_Global' failed. Chip's solution is
almost the same as Jim's. Gary's earlier solution works wonderfully:

Sub Clear_rnge()
For Each nm In ThisWorkbook.Names
Range(nm).ClearContents
Next
End Sub

Please accept my appologies for double posting and thanks for the help.