Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO SELECT NEXT CELL OF LAST VALUE CELL
Hi, in macro how you can select the next cell of the last value cell
in coloumn For example If I have value in cell A1 to A10 then how can I select next cell of cell A10 which will be B10. Please if anybody can help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO SELECT NEXT CELL OF LAST VALUE CELL
Hi,
Try this Sub versive() lastrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row Cells(lastrow, 1).Offset(0, 1).Select End Sub Mike "K" wrote: Hi, in macro how you can select the next cell of the last value cell in coloumn For example If I have value in cell A1 to A10 then how can I select next cell of cell A10 which will be B10. Please if anybody can help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO SELECT NEXT CELL OF LAST VALUE CELL
try
cells(10,cells(columns.count,10).end(xltoleft).col umn+1).select -- Don Guillett Microsoft MVP Excel SalesAid Software "K" wrote in message ... Hi, in macro how you can select the next cell of the last value cell in coloumn For example If I have value in cell A1 to A10 then how can I select next cell of cell A10 which will be B10. Please if anybody can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
Run Macro from cell change THEN select adjacent cell | Excel Programming | |||
How do I select multiple selections using the range(cell(),Cell()) | Excel Programming | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |