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!