ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
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.
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.