Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO SELECT SPECIFIC CELL
Row A B C ---Col
1 SS 2 DD 3 EE 4 FF 5 GG 6 HH 7 TT 8 9 10 I always had problem with selecting cells by macro. Accroding to the table above what code should I write 1 - To select last value cell in column B 2 - To select one cell below of last value cell in column B 3 - To select left cell of last value cell in column B 4 - To select right cell of last value cell in column B 5 - To select one cell below left of the last value cell in column B (which will be cell A8) 6 - To select one cell below right of the last value cell in column B (which will be cell C8) I know that code should be something like this "Cells("B1" & Rows.Count).End(XlUp).Row.Select" but I am not quite sure. Please if any body can help as by getting knowledge of selecting specific cells it will be very helpful for me. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select specific sheet and cell | Excel Programming | |||
select specific sheet and cell | Excel Programming | |||
select a cell with specific value | Excel Programming | |||
Select specific cell | Excel Discussion (Misc queries) | |||
Select specific Data from a cell | Excel Programming |