Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the end of a row plus 1
Right- first post out of the way and I'm on a roll... I am horribly
stuck on trying to select the cell immediately to the right of a row. I used the following code to select the cell at the bottom of a column (in this case 'B' where the data starts in row 3) Sub Test() Dim y As Long Dim rng As Range Set rng = Range("B3").End(xlDown) y = rng.Row + 1 Range("b" & y).Select End Sub But I got this (applying the same [or so I thought] logic) Sub Test() Dim y As Long Dim rng As Range Set rng = Range("b3").End(xlDown) y = rng.Row + 1 Range("b" & y).Select End Sub But this selects the same cell and +2 selects the cell below +3 the cell below that etc... I'm stuck. Any ideas? Thanks Solomon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Select other workbook to select data in a macro. | Excel Programming |