Thread: how to fill gaps in Current Region?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mikhail Mikhail is offline
external usenet poster
  
Posts: 9
Default how to fill gaps in Current Region?
Dear Excel experts!
Thank you all for your valuable help.
IMHO the most elegant solution is Range("A2").CurrentRegion.Resize(,56).copy
Thank you again.
Mike510


Reply With QuoteReply With Quote