Thread: Move text after delete
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
  
Posts: 123
Default Move text after delete

You can use
Range("B7:K23").Delete Shift:=xlShiftUp

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote