Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selection.cells(1).value
Hello,
I am working with the selection object. If I select a single cell. my selection.Cells.Count = 1. I can do this and get the correct value of the cell: selection.cells(1).value However I can also do this: selection.cells(0).value and get the value of the cell above the selected. Is this correct? Why is this happening? Seems a little scary? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Selection - Paste Selection - Delete Selection | Excel Programming | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Get a range of cells from a selection of cells | Excel Programming | |||
Macro to select cells and then new selection from selected cells | Excel Programming | |||
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells | Excel Programming |