Selecting Range
Hey Dan,
Here is one way
selection.end(xldown).columns("A:F").select
although selecting is messy
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Dan" wrote in message
...
Hello,
I have data in columns A through F and I would like select
the last row of data (A:F). I get to the last row by:
Selection.End(xlDown).Select
How do I then Select colums A:F for that row?
Thank you in advance,
Dan
|