XL 2016 delete rows in range

[omar88]

Hello
i hope your doing well please i'm in need of your help to delete some rows in a range with vba for example:

Delete row 2 from F to AZY

delete row 6 from F to azy
....
...
...

 

[vgendron]

Hello and welcome

Note that for any help, it is better to join an excel file to explain and show what you need.

anyway:
i guess that F and AZY are the columns you want to delete in row 2 or 6

many choices
rows(2).delete==> the whole row will be deleted ==>previous row 3 become 2
range("F2:AZY2").clearcontents==> clear the content (not the formatting) range "F2:AZY2" without deleting the row:=> you will have an empty range
range("F2:AZY2").clear===> clear content and formatting

range("F2:AZY2").delete ==> delete the range==> makes a shift between rows..

 

[omar88]

thank you