Thread: Changing one range on multiple sheets.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike-hime Mike-hime is offline
external usenet poster
  
Posts: 14
Default Changing one range on multiple sheets.
There is a point in my code where I would like to reset the same range on
several worksheets to empty. Is there a way to do this without writing a
line of code for each sheet?

It looks like this right now:

MySheet1.Range("C3") = ""
MySheet2.Range("C3") = ""
MySheet2.Range("C3") = ""
etc...

TIA

Mike-hime


Reply With QuoteReply With Quote