On Sep 18, 9:53 am, JE McGimpsey wrote:
One way:

Range("A1").Resize(7, 6).ClearContents

Note that you almost never need to select a range - working directly
with the range object makes your code smaller, faster, and IMO, easier
to maintain...

In article . com,



jlclyde wrote:
I am writting code to clear an area of a spread sheet. I have the
upper left hand cell selected, but I need to be able to offset from
this point and go down 6 rows and 6 columns. So instead of just
selecting A1 it woudl select A1:F7.

Thanks in advance,
Jay- Hide quoted text -

- Show quoted text -

Thank you for the help. I will keep that in mind when writting future
code.
Jay