Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As an aside, note that:
activecell.delete would delete just the single cell, just it would if you were doing this from the user interface. Note that a dialog box will come up asking whether you want to shift remaining cells up or to the left. activecell.entirerow.delete will, of course, delete the entire row, which is usually (but not always) what is wanted. If you did actually want to delete only the single cell, then you would have to provide an additional argument to specify which way to shift the remaining cells. -- Regards, Bill Renaud |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't set the Entirerow.Hidden property. | Excel Programming | |||
problems with .EntireRow function | Excel Programming | |||
.EntireRow.Select question | Excel Programming | |||
EntireRow.Delete | Excel Programming | |||
EntireRow.Hidden | Excel Programming |