problem with clear up cells (1 Viewer)

[associates]

Hi,

I wonder if i could get some help here.

I was trying to clear up specific cells.

Here is some of my code
Worksheets("sheet1").Activate
Worksheets("sheet1").Range("inputData").Activate

I have defined a cell with a name called "inputData". Then, i used the offset thing. Now, i know that the next row would be 1 according to offset from the "inputData".

So my goal is to be able to clear 7 rows down from the "inputData" and 6 columns from the "inputData". How would i do that?

Thank you in advance

 

[shades]

You could use Resize with Offset

Range("B2").Offset(1,1).Resize(6,7)

Adjust as needed.
________
Steroid rehab forum