Using Names in Macros

[StewartS]

I am writing a macro which selects a varible range of data and then performs a pivot table on it.

In order to select the range in the pivot table I was going create a name for the range in the macro. I am using varibles to select the first and last cell in the range.

See below

Dim startcell
Dim endcell

Range("A1").Select
startcell = ActiveCell.Address
Selection.End(xlDown).Select
Selection.End(xlRight).Select
endcell = ActiveCell.Address

Range(startcell, endcell).Select
ActiveWorkbook.Names.Add Name:="Data", RefersToR1C1:= _
"=DOWNLOAD!R1C1:R5253C7"

Instead of the "=DOWNLOAD!R1C1:R5253C7" I want to use the startcell, endcell range.

Can anybody help please.

Stewart

 

[NateO]

ActiveWorkbook.Names.Add Name:="Data", RefersToR1C1:= _
selection


Cheers,

Nate

 

[StewartS]

Nat

Thanks

I new it was something simple I was missing.

Stewart