blanchard306
05-20-2016, 09:14 AM
I have code to minus header row from current region but I need to select current region minus header row and last column. Can anyone help?
Here is my current code
Selection.CurrentRegion.Select
Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
So say my current region is Rows 1 through 20 and columns A through H I would need the selection to capture rows 2 through 20 and columns A through G.
The data won't always be 1-20 and A-G sometime more rows and more columns so I need to be able to do it from current region and minus out the first row and last column.
Thanks!!
Here is my current code
Selection.CurrentRegion.Select
Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
So say my current region is Rows 1 through 20 and columns A through H I would need the selection to capture rows 2 through 20 and columns A through G.
The data won't always be 1-20 and A-G sometime more rows and more columns so I need to be able to do it from current region and minus out the first row and last column.
Thanks!!