Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move cursor to columns to the right
Steven.
Try this Sub findLU() For Each Cell In Range("C:C") If Cell.Value = "LU" Then Cell.Offset(0, 2).Value = Cell.Offset(0, 2).Value / 1000 End If Next End Sub Neil "Steven R. Berke" wrote in message om... I want to write a macor which will find the letters LU in Column C them move to rows to the right to column E and divide the figure in column E by 1000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
Cursor not displaying properly to resize/move columns/tables | Excel Discussion (Misc queries) | |||
Move cursor to next row | Excel Discussion (Misc queries) | |||
Move Cursor to A1 | Excel Discussion (Misc queries) | |||
Move cursor to columns to the right | Excel Programming |