Create a Range Name Based on a Selected Range 1

[Dauphy]

Hi!

I'm new to VBA; so please bear with me.

The user highlights a selection range; hits a button; and a chart appears. First things first - I'm struggling with assigning a named range based on the area that has been selected.

After I have obtained that named range; I need an offset range based on the first column selected. For example, if C48 was selected; i need the value listed in C1; therefore I need to create a named range for this one too.

Once I have this; I'll be able to record my macro strokes for the rest of the chart.

Thank you.

 

[srogers]

I'm new to this too so I need to clarify what you are asking. Are you asking how to name a range of cells?

Thanks-

 

[DaleWatson123321]

Dauphy,

Try this...


Sub Create_Names()
Selection.Name = "data"
ActiveCell.Select
Selection.Offset(-3, 0).Name = "heading"
End Sub


Hope it helps. Please advise as to how it fits.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Dauphy]

Perfect Dale!

Sorry SRogers; but thanks anyways