I am working on a macro to sort inventory several ways. The inventory items detail is in columns B:T. On either side of that are some formulas. The inventory list may get longer or shorter, so to select the inventory to sort I have ...
Range("B12").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
This works fine, but the selected range includes several columns of formulas on the right that don't need to be sorted. Is there some way to just select columns B:T instead of
"Range(Selection, Selection.End(xlToRight)).Select"?
Or is that even a good idea or worth it?
Regards,
Vernon
Range("B12").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
This works fine, but the selected range includes several columns of formulas on the right that don't need to be sorted. Is there some way to just select columns B:T instead of
"Range(Selection, Selection.End(xlToRight)).Select"?
Or is that even a good idea or worth it?
Regards,
Vernon