| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I not delete an enitre row when running a duplicate delete.
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete row if duplicate | Excel Discussion (Misc queries) | |||
| How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
| Delete Duplicate | Excel Discussion (Misc queries) | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
| Delete Macro After Running | Excel Programming | |||
Hybrid Mode
