Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Sub SelectColumns() Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Orders") ws.Select ActiveWindow.zoom = 80 Dim lo As ListObject Set lo = ws.ListObjects("Orders") lo.DataBodyRange.Columns(1).Resize(, 1).Select lo.DataBodyRange.Columns(10).Resize(, 1).Select Set ws = Nothing Set lo = Nothing End Sub
|Excel format formula for currency||15||22|
|Why do I often "Too many different cell formats" error message in Excel2010?||2||20|
|Excel. How to get via VBA the last used row in a named dynamic range||10||30|
|macro modification Column C||14||22|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!