| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help in selecting cells , VBA in Excel
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help in selecting cells , VBA in Excel
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting/Editing highlighted cells in Excel | Excel Discussion (Misc queries) | |||
| Excel keeps selecting two cells | Excel Discussion (Misc queries) | |||
| When selecting cells in Excel 07 why doesn't it highlight? | Excel Discussion (Misc queries) | |||
| The cursor on my Excel spreadsheet is not selecting cells. | Excel Discussion (Misc queries) | |||
| Activiating and Selecting Excel Cells in VB.NET | Excel Programming | |||
Hybrid Mode
