Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I thought his would be the simplest of macros !
I need to add "19" to the beginning of the description of an asset to correct two digit years to four. I recorded my steps ie. F2 key , then home then right arrow the 19 then an enter key to move down to the next cell. If the next cell needs correction and I run the macro created by my recording, rather than correcting the new cell, ie. adding "19" to the beginning, it inserts the corrected contents of the previous cell on which the macro was run. Engaging the relative reference key does not help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting characters from beginning of call | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
Weird characters at beginning of cell | Excel Discussion (Misc queries) | |||
Insert characters in a text string | Excel Worksheet Functions | |||
add characters to beginning of text | Excel Worksheet Functions |