Does anyone know of a way to use intersect and usedrange to set a new range variable and have it equal the used range minus the first row and column?
Does anyone know of a way to use intersect and usedrange to set a new range variable and have it equal the used range minus the first row and column?
Dim myRange as Range With ActiveSheet.UsedRange Set myRange = .Offset(1,1).Resize(.Rows.Count - 1, .Columns.Count - 1) End With
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Works Perfect. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks