"Jim Thomlinson" wrote in message
...

I assume that nRows is an integer or long variable...

ThisWorkbook.Names.Add Name:="dAge", RefersTo:="=RawData!$H$2:$H$" &
nRows,
Visible:=True

I hope the poster understands that the named range is not "connected" to
nRows, i.e., if the value of nRows changes later it won't change the range
that was just created. Just thought I'd mention it....