Thread
:
Need VB code to edit cell values
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_2_]
external usenet poster
Posts: 1,522
Need VB code to edit cell values
Examples of before/after
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Stephen Ford" wrote in message
...
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
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]