Re: erasing outside print area

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: mikerickson <mikerickson.c30c9b@xxxxxxxxxxxxxxx>
Date: Sat, 23 Jun 2007 17:08:29 +0100

This works for me.
Code:
--------------------
Dim pValues As Variant
With Active***
pValues = .Range(.PageSetup.PrintArea).Value
.Cells.ClearContents
.Range(.PageSetup.PrintArea).Value = pValues
End With
--------------------
er;513921 Wrote:

hallo,
how can erase the empty cells, outside print area?

--
mikerickson
.

Follow-Ups:
- Re: erasing outside print area
  - From: Dave Peterson

Prev by Date: RE: I Need HELP with "IF" "THEN" I think????
Next by Date: Next Emptycell row #
Previous by thread: Re: erasing outside print area
Next by thread: Re: erasing outside print area
Index(es):
- Date
- Thread