Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
selecting data in a row
Dim rng As Range
With Worksheets("Data") Set rng = .Range("a2", .Range("a" & Rows.count).End(xlUp)) End With rng.Select -------------------- With above code I select all data in column A. How can I select all data in row 1. I mean what is the equal code for selecting columns in a row ? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data selecting | Excel Worksheet Functions | |||
Selecting Data | Excel Discussion (Misc queries) | |||
Selecting most recent data within several lines of data | Excel Discussion (Misc queries) | |||
Pivot charts - data disappear after selecting or data are static | Excel Worksheet Functions | |||
Selecting data | Excel Worksheet Functions |