Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move cursor to columns to the right
this will work
Sub FindDivide() x = Columns(3).find("LU").Address Range([x]).Offset(, 2) = Range([x]).Offset(, 2) / 1000 End Sub -- Don Guillett SalesAid Software Granite Shoals, TX "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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move cursor to columns to the right
you don't need to evaluate a string to make it a string
Range([x]).Offset(, 2) = Range([x]).Offset(, 2) / 1000 can be simplified to Range(x).Offset(, 2) = Range(x).Offset(, 2) / 1000 Either method will raise an error if LU is not found. Regards, Tom Ogilvy Don Guillett wrote in message ... this will work Sub FindDivide() x = Columns(3).find("LU").Address Range([x]).Offset(, 2) = Range([x]).Offset(, 2) / 1000 End Sub -- Don Guillett SalesAid Software Granite Shoals, TX "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 | |||
Can I move the cursor on error?? | Excel Discussion (Misc queries) | |||
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) |