Variable Range
Selection.rows.count means that area is already selected. If you want to
expand the selection
selection.Resize(selection.rows.count,10).select
to expand to 10 columns same number of rows, or the simple
Selection.Resize(,10).Select
--
Regards,
Tom Ogilvy
"Dave" wrote:
How can the following range statment: "ActiveCell.Range("A1:A300").Select" be
written for a varialble range based on "Selection.Rows.Count" ?
Thank you
dave
|