Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select a row to delete
What is the format for selecting a row to delete? The
problem is the row that needs to be deleted will change. The good news is that the activecell in column A will always be on the row that needs to be deleted. Is there a way to go ahead and tell Excel to highlight the row that the activecell is on and delete? Below is the basic code for deleing a row, however it specifies the row directly. What do I need to change? Rows("1:1").Select Selection.Delete Shift:=xlUp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button, now too thin, cannot select to delete | Excel Worksheet Functions | |||
How to delete a 'Select Box' | Excel Discussion (Misc queries) | |||
select and delete all blank rows | Excel Discussion (Misc queries) | |||
Delete Select Targets | Excel Discussion (Misc queries) | |||
Conditional Row Select and Delete | Excel Programming |