Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VB code to edit cell values
I need some VB to do the following please (My VB is not good enough yet)
Starting from the active cell (call it the StartCell) In the cell to the left.. ThreeChars = Value.right(3) (the last three chars) Value = Value - last three characters (assume value is text & at least 3 chars present) In StartCell.. value = ThreeChars (as text, overwrite any contents of StartCell) move active cell one down from StartCell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Code not grabbing cell values | Excel Discussion (Misc queries) | |||
How to edit the code to fit image within specific cell? | Excel Programming | |||
Code to do edit checks when user moves out of a cell | Excel Programming | |||
Have code check cell contents on edit. | Excel Worksheet Functions | |||
UDF code to find specific text in cell comments, then average cell values | Excel Programming |