Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a range in a module
I want to select a two cell range and name it using Excel Basic.
The code below does select the two cells with the coordinates of the lower cell being (ReqRow,ReqCol). The first two lines of the naming code compile and run but produce nothing ie no name in list of range names. AccCode is correctly read previously however. It is a 3 letter string eg veh. The third line of the naming code will not compile - how do you name a range rather than a single cell? Help! There is so much I don't know! Sue ReqRow = ActiveCell.Row ReqCol = ActiveCell.Column ActiveCell.Offset(-1, 0).Range("A1:A2").Select ActiveWorkbook.Names.Add Name:="ac" & AccCode, RefersToR1C1:= _ "'Work Data'!R[" & ReqRow & "]C[" & ReqCol & "]:" _ 'Comment [" & ReqRow & - 1"]C[" & ReqCol & "]"" ActiveCell.Offset(1, 2).Range("A1").Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range naming | Excel Discussion (Misc queries) | |||
Module naming | Excel Programming | |||
Naming a range | Excel Discussion (Misc queries) | |||
naming a range | Excel Programming | |||
VB Code Naming a Range (range changes each time) | Excel Programming |