help in selecting cells , VBA in Excel

  • Thread starter Thread starter Kortrijker
  • Start date Start date
K

Kortrijker

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
 
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)
 
Back
Top