Can't set Range Name as "Header cell" and suffix without changing Header itself

[Ochimus]

Anyone know how to create a Range Name in VBA using the Header Cell and a suffix WITHOUT changing the Header cell itself?

(E.g. Cells A1 - A10 have header "Less Time". I want the range to be ""Less Time Filter", but can't see how to combine the Header ("Less Time") with the Suffix (" Filter") without changing the Header itself?
.
Tried the "CreateNames" approach (Selection.CreateNames Sheet2.Cells(1, 1) & "_Filter"), but it generates an error

All solutions, suggestions and alternatives received gratefully as ever

Ochimus

[Fluff13]

Named ranges cannot have spaces. One way is like

Please Login or Register  to view this content.

But it depends on what you are trying to do

[Ochimus]

Fluff,

Many thanks for prompt response, but it doesn't do what I explained?

As I said in the original post, I do NOT want to change the content of the Header Cell.

I want to create a Range Name that combines the wording of the Header cell with a Suffix (E.g. Cell says ""Less Time", Suffix is "_Filter", so Range Name becomes "Less Time_Filter".

So the cell will still say "Less Time", but the Range including it will be called "Less Time_Filter"

Hope this clarifies?

Ochimus

[Fluff13]

Firstly

As I said in the original post, I do NOT want to change the content of the Header Cell.

The code I supplied does NOT change the content of the cell (as per you request)!

Secondly, did you read my reply? namely

Named ranges cannot have spaces.

[Ochimus]

Fluff,

Many thanks for clarification, and especially for drawing my attention to the space in the Header itself.

I was so focused on attaching the suffix I missed that completely! Which is why my initial attempts fell over.

Just had to expand your snippet to check whether a Header started with a number, in which case it adds an initial underscore, but everything now works seamlessly and I can mark this as Solved.

Ochimus

[Fluff13]

Glad it's sorted & thanks for the feedback