| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell naming using cell references (VBA? Offset?)
Hello,
I have a table. I need to assign a name to each of the cells but it is extremely tedious even using the name manager. (I also have to do it multiple times). I have been trying to create the code in VBA but am making a ham-fisted frustration of the job. I know this involves offsets and an iteration but I'm afraid my skills do not extend to this. Can you help? Here's what I want to do: a b c ... n 1 colnameb colnamec... colnamen 2 rowname2 3 rowname3 ... M rownamem I want the cell in b2 to be named rowname2colnameb ....the cell in c2 to be named rowname2colnamec ....the cell in NM to be named rownamemcolnamen The tables are in different positions, so please presume I am starting the macro with the cursor in cell b2. Thankyou in advance!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming Cells Using Relative Cell References | Excel Worksheet Functions | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| =OFFSET(!$A$1,,,,) - global range naming | Excel Worksheet Functions | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Threaded Mode
