Delete row where active cell is located using VBA
 

Hi
Is there a way to delete the row where the active cell is on using VBA ?

Thanks for any help in advance.
Jeff

Delete row where active cell is located using VBA
 

ActiveCell.EntireRow.Delete

For more on deleting rows, see www.rubbershoe.com/deleterows.htm

"Jeff Marshall" wrote in message
...
Hi
Is there a way to delete the row where the active cell is on using VBA ?

Thanks for any help in advance.
Jeff

Delete row where active cell is located using VBA
 

activecell.entirerow.delete

--
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Jeff Marshall" wrote in message
...
Hi
Is there a way to delete the row where the active cell is on using VBA ?

Thanks for any help in advance.
Jeff

Delete row where active cell is located using VBA
 

Perfect !!
Thanks
Jeff


"Robin Hammond" wrote in message
...
activecell.entirerow.delete

--
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Jeff Marshall" wrote in message
...
Hi
Is there a way to delete the row where the active cell is on using VBA ?

Thanks for any help in advance.
Jeff