Activesheet.UsedRange.Select

as a starter

--

HTH

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

"Kortrijker" wrote in message
...
Dear all,

Can someone help me, please?

I want Excel select data automatically.

I have one Excel sheet, data are transferred from SQL server into Excel,
which means I don't know how many recorders in the table everytime.

Is there codes of VBA to select the whole data in this table ? Thanks.

Best wishes
jiang