Range Select + Delete Blanks

**pr4t3ek** · 12-30-2008, 10:07 PM

i have the following code:

Please Login or Register  to view this content.

i would like to somehow amend the line

Please Login or Register  to view this content.

and make it go all the way up but then go down one row ... if that makes sense... (without selecting the cell)

i've tried

Please Login or Register  to view this content.

but that doesnt work

**Leith Ross** · 12-30-2008, 10:43 PM

Hello PD,

When you say all the way up, do mean to row 1 or the first empty row in the range?

Sincerely,
Leith Ross

**pr4t3ek** · 12-30-2008, 10:47 PM

empty row in the range

**Leith Ross** · 12-30-2008, 10:52 PM

Hello PD,

One more question. Which column will always be the longest or do they all vary?

Sincerely,
Leith Ross

**pr4t3ek** · 12-30-2008, 10:54 PM

they can vary.
column L & O will always having something(a value) in there though..

**Leith Ross** · 12-30-2008, 11:05 PM

Hello PD,

This code uses column "L" to determine the last row.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**pr4t3ek** · 12-30-2008, 11:11 PM

so how do i use that in the context of

Please Login or Register  to view this content.

where i want those rows to be deleted (because they are blank and do not hold any data in them)