Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of Tab key in a range
When using Excel I have selected a range of cells. I can then use the Tab key
to keep the selection but move the active cell to the next cell in the row. when the last cell on the row has bee selected, the active cell becomes the next cell on the next row all within the selected range. How is this achieved in VBA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of Tab key in a range
There is rarely any reason to select a cell in VBA
for each cell in Range("A1:F10") msbox cell.Address Next if you want to loop through the user's selection for each cell in selection -- Regards, Tom Ogilvy "diddy_david" wrote: When using Excel I have selected a range of cells. I can then use the Tab key to keep the selection but move the active cell to the next cell in the row. when the last cell on the row has bee selected, the active cell becomes the next cell on the next row all within the selected range. How is this achieved in VBA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |