Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refer to cell
Hi
Try Range("A1").Resize(x,x).Name = "CorrMatrix" The Refers To technique is diffcult to use for variable ranges. regards Paul On May 23, 9:13 am, Arne Hegefors wrote: Hi! I want to name a range in VBA. I know in what cell I want it to start, lets say A1. I also have a variable that controls both the height and length of the range (they are of equal size). This variable is called x. I have: ThisWorkbook.Names.Add Name:="CorrMatrix", RefersTo:="=$A$1:$C$10", Visible:=True but the Refers to bit is wrong. How shall I write it? please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refer to cell | Excel Programming | |||
Refer a specific cell in a named cell range | Excel Programming | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
How to refer to every 5 th cell? | Excel Discussion (Misc queries) | |||
refer cell using c | Excel Programming |