Offset VBA Problem
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
|