Thread: How do I not delete an enitre row when running a duplicate delete.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
  
Posts: 1,298
Default How do I not delete an enitre row when running a duplicate delete.
firstcol = "C"
lastcol = "G"
killrow = 5

Range(Cells(killrow, firstcol), Cells(killrow, lastcol)).Delete xlShiftUp

"TonygWillfe" wrote:

I'm running a macro that deletes an entire row when it is duplicated.
However, I only want the macro to delete columns C to G. How do I adjust the
macro to delete only between these columns and move the cells up. Help would
be greatly appreciated.
Reply With QuoteReply With Quote