Without knowing "the columns you really want", perhaps:

Intersect(Selection.EntireRow, Range("C:U")).Select




In article ,
Dave Birley wrote:

This line of Code:

Range(Selection, Selection.End(xlToRight)).Select

..comes up a couple of Columns short. The reason is obvious, the first of
the two missing Columns (T) is empty, but the one to the right of it (U)is
not. As I am selecting multiple Rows at the same time, and intend to run this
macro on a number of WS, each of which may or may not be populated in the
cells of those last two columns -- and may even find columns R and S empty
on some WS, but the number of Rows in each WS will vary, how do I tell the
Macro to Select the Columns I really want?