Delete and then re-insert rows and columns

[ChristineJ]

I have a range of data that is contained within 6 contiguous columns by 29 contiguous rows. It can appear anywhere in a worksheet beginning in column C (would not be in columns A or B) and beginning in row 3 (would not be in rows 1 or 2).

I'd like to run a macro that would
(1) delete all the rows above this range and all the columns to the left of this range so that data appears in range B2:G30
(2) run another macro called "Evaluate"
(3) insert the same number of rows and columns deleted in (1) so that data range is back to where it was originally

Is there a way to do this? Thanks.

 

[StephenCrump]

Does your range have a name? if not, how do we know where it starts, e.g. is there a particular column header we can search for?

Why do you need to delete rows/columns and then re-insert? Would clearing the row/columns suffice? Or does your code for Evaluate maybe rely on the data range starting in B2? If so, could we rewrite Evaluate to make it more flexible?

 

[ChristineJ]

Does your range have a name? if not, how do we know where it starts, e.g. is there a particular column header we can search for?

Why do you need to delete rows/columns and then re-insert? Would clearing the row/columns suffice? Or does your code for Evaluate maybe rely on the data range starting in B2? If so, could we rewrite Evaluate to make it more flexible?

I think I figured it out by naming the range and finding the cell reference of the first cell in the range. I only learned now to do that after I posted. I appreciate your reply - your first question confirms I am going in the right direction.