Thread: faulty PasteSpecial line??
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
[email protected] geofferrington@hotmail.com is offline
external usenet poster
  
Posts: 25
Default faulty PasteSpecial line??
Yep..... That works

Sub moveStuffUp()
Range(Cells(ActiveCell.Row, "I"), _
Cells(ActiveCell.Row, "K")).Delete xlUp
Range("I" & ActiveCell.Row).Select
End Sub

Geoff

Reply With QuoteReply With Quote