Patrick,

Use Resize. Assuming that you have set the selected range to a variable
called tbl, this will cut back 1 column

tbl.Resize(tbl.Rows.Count, _
tbl.Columns.Count - 1).Select


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Patrick" wrote in message
. be...
Hello,

When you select a range with a macro, via End xldown etc... I would like
to
select this range minus 1 column, how is this possbiel in excell

Regards

Patrick