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

You could use Resize with Offset

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

Adjust as needed.