delete command?

[vibehappy]

is there a command to delete rows, or better yet, a range of rows? for example, is there a way to say IF(WEEKNUM(TODAY())>A3, delete A3:H8)? And by that (and I know that's written incorrectly), I mean to say if the week number in A3 is less (older) than today's week number, delete this range of cells...

thanks!

 

[xapie128]

If you are talking about VBA code...
This is how to delete rows:

    Columns("A:H").Select
    Selection.Delete Shift:=xlToLeft

But at one point, you asked:

for example, is there a way to say IF(WEEKNUM(TODAY())>A3, delete A3:H8)

Note that A3:H8 is a Range of cells, not full columns.
If you just want to clear what's in that range, then use:

    Range("A3:H8").Select
    Selection.ClearContents

 

[vibehappy]

hey, thanks for the reply! well, what i'm looking to do is delete rows, rather than clear the contents.

could i then do this?

Rows("3:8").Select
Selection.Delete Shift:=xlUp

would that be the correct code?

thanks again for the reply, i appreciate it.
have a great day!

 

[erik.van.geit]

hey, thanks for the reply! well, what i'm looking to do is delete rows, rather than clear the contents.

could i then do this?

Rows("3:8").Select
Selection.Delete Shift:=xlUp

would that be the correct code?

thanks again for the reply, i appreciate it.
have a great day!

Hi, vibehappy
Welcome to the Board !!!!!

if you want to delete the entire rows, then that would work indeed: but why not try out before asking ?
you don't need to select the range

Rows("3:8").Delete

(shift up is the default)

kind regards,
Erik

 

[vibehappy]

thanks very much for the reply...that should help a bunch! and i'll try it out next time for sure...sorry i didn't think of that, lol. have a great day!

 

[xapie128]

well, what i'm looking to do is delete rows

Oops, sorry. That's what I get for not reading close enough.
Thanks Erik for fixing my error.

 

[erik.van.geit]

well, what i'm looking to do is delete rows

Oops, sorry. That's what I get for not reading close enough.
Thanks Erik for fixing my error.

you're welcome !! that's team-work