Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting data
I'm selecting some data with a macro that has some blanks
within the data. I'm using: Range(Selection, Selection.End(xlDown)).Select to select the cells below my current activecell. However when I go to select cell to the right of my current activecell using: Range(Selection, Selection.End(xlToRight)).Select It only selects part of the data. It stops right before a blank cell and doesn't continue. This command is doing what it should but I need to be able to select everything to the right. I would be very happy if the code selected all the way to IV. Just to insure I’m getting everything. Thanks for your time and Help. Darron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting data in a row | Excel Worksheet Functions | |||
data selecting | Excel Worksheet Functions | |||
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 |