need help creating named ranges! getting error 450

[treepio]

Hi everyone,

I'm trying to make a VBA code that creates about 10 different named ranges, taking the formulas to be used in the named ranges from a column. (I'll use a button to update this list every so often)
I'm currently stuck on having it create different names for each row.
Below is the basic formula im using, trying to get the hang of it.

Please Login or Register  to view this content.

Trying it like this, I get error code 450
Can anyone tell me what I'm doing wrong?

[YasserKhalil]

Can you attach a sample of your file?

[romperstomper]

What is in S7? Does it contain spaces?

[Norie]

Why are you naming the same range, with the same name, 10 times?

[treepio]

Since I'm working with some confidential data, I can't send the file I'm working on, but I've created this dummy file to get my idea across.
There's still some dead-end parts to my VBA there; I'm aware of those, but i figured I need to fix my main problem before going further.

dummy.xlsm

I sometimes have trouble explaining myself, so please tell me when I'm being unclear.

[romperstomper]

You're trying to give names like a800 to the cells - you can't do that because that is an actual cell address already.

[treepio]

@romperstomper: s7 contains the number of one of my coworkers. It does not contain spaces.

@ norie: Basically I'm trying to use the for c = 1 to 10 part, to create a expanding list of employees.
I'll have to make it count the rows after this. That part isn't really done yet

[treepio]

@ romperstomper So if I just change the code Im using a little, to make it create names like a800a or something, it could work?

edit: I've tried it like that, and it works! thanks a lot for the quick, useful responses people! I'm very grateful!