Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a quote mark, then repeat
Hi -
This used to be so easy in Lotus! I want to convert values to labels in a column of 50 cells. Best way to do so is to insert a quote mark at the beginning of every cell. Attempted to create a relative macro to do so by: F2 (edit) R1C1\Home\' \Stop. Assigned it Control Q. Since I have no clue how to make a macro repeat (downwards), I thought I would just arrow down to the next cell manually, and then Control Q. All this "brilliant" macro did was copy the contents of R1C1 to R2C1. I miss Lotus. Sigh.. Thanks to anyone who helps! Tried to search this, BTW. sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert single quote symbol | Excel Worksheet Functions | |||
how do you insert lines in a quote form | Excel Discussion (Misc queries) | |||
Foot mark aka single quote mark? | Excel Worksheet Functions | |||
Extra Quote Mark | Excel Programming | |||
Help - 'finding' a quote mark (") ??? | Excel Programming |