Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two questions: 1-i'm trying to create a very simple macro that will
extract certain text from a cell and move it to the cell to the right. The full text is L+300...i want to copy just the 300, and move it. I want to do this for a column of cells that contain L+###. I've read posts that say the edit function doesn't work with macros (which, by the way is NEVER mentioned on excel help...), so how do you "get into" the cell to do this? Also, i've tried to use the cell reference tool on the 'stop record' toolbar with no success. HOw does this work, exactly? do you reference the target cell or the original? neither worked... 2- (stupid question) is there a way to enter this discussion area directly w/o going thru excel's help function (like, is there a direct web address?) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a reference from one cell to several other relavent cells | Excel Discussion (Misc queries) | |||
macros creating | Excel Discussion (Misc queries) | |||
creating a range reference from cell values | Excel Discussion (Misc queries) | |||
creating macros in excel | Excel Discussion (Misc queries) | |||
Macros-creating new sheets | Excel Worksheet Functions |