| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select a certain range of data
I need to write a code that is able to start at cell A6 then find the last
column with data then find the first blank row and set that as my range and then have that range selected. So, as an example from below, the code would select A6:C8 and leave out the cells below the blank row. A B C 6 text-1 text-1 text-1 7 text-2 text-2 text-2 8 text-3 text-3 text-3 9 10 Total xxx Thank You in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Data Range | Excel Discussion (Misc queries) | |||
| how to select and count from a range of data | Excel Discussion (Misc queries) | |||
| select range containing data | Excel Discussion (Misc queries) | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| In data range select final value. | Excel Discussion (Misc queries) | |||
Threaded Mode
