Deleting a given row in VBA

[buffalo]

How do I delete a given row in VBA?

I have the row value in a variable called RowValue

thanks a lot!

 

[Greg Truby]

Range("A" & rowvalue).entirerow.delete

 

[FryerTuck]

Rows(rowvalue).delete

 

[Greg Truby]

(a) Fryer - dang! I always forget that syntax.

(b) Just a comment - if you're deleting multiple rows using a loop, beware of the synchronization of the row counter and the actual row. Frequently it's better to work from the bottom upwards rather and top-down when deleting rows as it makes keeping thing in sync easier.