I would select B1 then, holding SHIFT down press END the HOME. Then, still holding SHIFT down use the left arrow until only one column is selected. Easier to do then describe! Best Regards David Grugeon Excel VBA Group Moderator -----Original Message----- From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of Torstein Johnsen Sent: Wednesday, 27 June 2012 7:32 PM To: ExcelVBA@yahoogroups.com Subject: [ExcelVBA] Select range in column with non-continuous data This is not a VBA-question. I hope I can explain it and get some good advice anyway. in a worksheet - 3 columns, about 10000 rows of data. In column A and C the data are continuous...
Sabtu, 30 Juni 2012
]] XL-mania [[ Digest Number 2433
Microsoft Excel Community Group 3 New Messages Digest #2433 1a Re: Keanehan Excel by "Kid Mr." nmkid.family@ymail.com 1b Re: Keanehan Excel ...
READ MORE....
[smf_addin] Digest Number 2262
EXCEL Stock Market Functions Add-in Group 4 New Messages Digest #2262 1a Re: Morningstar Premium data extraction by "oryxius" oryxius 1b Re: Morningstar...
READ MORE....
[belajar-excel] Digest Number 1672
Milis Belajar Microsoft Excel Group 15 New Messages Digest #1672 1 MAKRO BAGI PEMULA by "Siti Nurhikmah" 2a Re: (mods : menentukan nilai...
READ MORE....
Langganan:
Postingan (Atom)
Followers
Blog Archive
-
▼
2012
(2067)
-
▼
Juni
(158)
- RE: [ExcelVBA] Select range in column with non-con...
- ]] XL-mania [[ Digest Number 2433
- [smf_addin] Digest Number 2262
- [belajar-excel] Digest Number 1672
- Re: Vedr: Vedr: [ExcelVBA] Select range in column ...
- ]] XL-mania [[ Digest Number 2432
- [smf_addin] Digest Number 2261
- [belajar-excel] Digest Number 1671
- [smf_addin] Digest Number 2260
- [belajar-excel] Digest Number 1670
- Re: Vedr: Vedr: [ExcelVBA] Select range in column ...
- Re: [ExcelVBA] New to Group
- Vedr: Vedr: [ExcelVBA] Select range in column with...
- Re: [ExcelVBA] New to Group
- Re: Vedr: [ExcelVBA] Select range in column with n...
- Re: Vedr: [ExcelVBA] Select range in column with n...
- [ExcelVBA] New to Group
- Re: Vedr: [ExcelVBA] Select range in column with n...
- Vedr: [ExcelVBA] Select range in column with non-c...
- Re: [ExcelVBA] Select range in column with non-con...
- Re: [ExcelVBA] Select range in column with non-con...
- ]] XL-mania [[ Digest Number 2431
- Re: [ExcelVBA] Select range in column with non-con...
- [smf_addin] Digest Number 2259
- [ExcelVBA] Select range in column with non-continu...
- [belajar-excel] Digest Number 1669
- [belajar-excel] Digest Number 1668
- ]] XL-mania [[ Digest Number 2430
- [smf_addin] Digest Number 2258
- [belajar-excel] Digest Number 1667
- [ExcelVBA] Re:
- ]] XL-mania [[ Digest Number 2429
- [smf_addin] Digest Number 2257
- [belajar-excel] Digest Number 1666
- ]] XL-mania [[ Digest Number 2428
- [smf_addin] Digest Number 2256
- [belajar-excel] Digest Number 1665
- [belajar-excel] Digest Number 1664
- [smf_addin] Digest Number 2255
- [belajar-excel] Digest Number 1663
- [belajar-excel] Digest Number 1662
- Re: [ExcelVBA] Cannot adapt matrix formula.
- ]] XL-mania [[ Digest Number 2427
- [smf_addin] Digest Number 2254
- [belajar-excel] Digest Number 1661
- RE: [ExcelVBA] Cannot adapt matrix formula.
- [belajar-excel] Digest Number 1660
- [ExcelVBA] Cannot adapt matrix formula.
- ]] XL-mania [[ Digest Number 2426
- ]] XL-mania [[ Digest Number 2425
- [smf_addin] Digest Number 2253
- [belajar-excel] Digest Number 1659
- [belajar-excel] Digest Number 1658
- ]] XL-mania [[ Digest Number 2424
- [smf_addin] Digest Number 2252
- [belajar-excel] Digest Number 1657
- [belajar-excel] Digest Number 1656
- Re: [ExcelVBA] Excel Date Calculations
- [ExcelVBA] Excel Date Calculations
- [smf_addin] Digest Number 2251
- [belajar-excel] Digest Number 1655
- [belajar-excel] Digest Number 1654
- ]] XL-mania [[ Digest Number 2423
- [smf_addin] Digest Number 2250
- [belajar-excel] Digest Number 1653
- [smf_addin] Digest Number 2249
- [belajar-excel] Digest Number 1652
- ]] XL-mania [[ Digest Number 2422
- [smf_addin] Digest Number 2248
- [belajar-excel] Digest Number 1651
- [ExcelVBA] Re: DTPicker
- ]] XL-mania [[ Digest Number 2421
- [smf_addin] Digest Number 2247
- [belajar-excel] Digest Number 1650
- [belajar-excel] Digest Number 1649
- Re: [ExcelVBA] VBA Reference to a protected workbook
- ]] XL-mania [[ Digest Number 2420
- [ExcelVBA] VBA Reference to a protected workbook
- [smf_addin] Digest Number 2246
- [belajar-excel] Digest Number 1648
- [belajar-excel] Digest Number 1647
- [ExcelVBA] DTPicker
- ]] XL-mania [[ Digest Number 2419
- [smf_addin] Digest Number 2245
- [belajar-excel] Digest Number 1646
- ]] XL-mania [[ Digest Number 2418
- [smf_addin] Digest Number 2244
- [belajar-excel] Digest Number 1645
- [belajar-excel] Digest Number 1644
- Re: [ExcelVBA] Main Menu not showing
- Re: [ExcelVBA] Uising Excel for safety critical ca...
- [ExcelVBA] Main Menu not showing
- [ExcelVBA] Uising Excel for safety critical calcul...
- ]] XL-mania [[ Digest Number 2417
- [smf_addin] Digest Number 2243
- Re: [ExcelVBA] Pivot type problem
- [belajar-excel] Digest Number 1643
- [ExcelVBA] Re: ReSOLVED: Closing WAS:Opening a CS...
- [ExcelVBA] Re: ReSOLVED: Opening a CSV file and po...
- [ExcelVBA] Re: ReSOLVED: Opening a CSV file and po...
-
▼
Juni
(158)