Naming ranges in for each loop

[Aaron092]

Hi all

I'm trying to name single cells using the active cell column and row (splitting these and putting together) but I cannot get it to work.
One example of the code I'm currently using:

Please Login or Register  to view this content.

There are 29 of these in total but I cannot get the code to set a named range.
No errors, it just does not set a named range.

I have also tried the following:

Please Login or Register  to view this content.

Any help on this is appreciated.

Many thanks

[Norie]

What cells do you want to name and what do you want to name them?

[Aaron092]

Hi Norie

It's unknown which cells will be named, the only constant is the Columns:
H, M, S, Z, AE, AI, AO.

I'm getting the row to use using the following:

Please Login or Register  to view this content.

but then rows of data are pasted above each of these (it's a report building .. thing. I didn't ask what it was for )

I'm trying to name the ranges as follows:

lmone
lmtwo
lmthree
lmfour
lmfive
lmsix
lmseven

saone
satwo
sathree
safour
safive
sasix
saseven

colone
coltwo
colthree
colfour
colfive
colsix
colseven

drone
drtwo
drthree
drfour
drfive
drsix
drseven

[Norie]

Sorry but I'm a bit confused.

In the original code you posted you were looping through column C starting at row 4.

Not sure where you are looping in the code in the 2nd post.

Also that code isn't naming ranges and I don't see it getting row numbers either, unless you are doing something with lmcell, sacell etc.

By the way, there is a slightly easier way to name cells.

Please Login or Register  to view this content.

[Aaron092]

Norie, I am so sorry.
The reason it's not working is because I was referencing column C only.

It should have been C:AO

Please Login or Register  to view this content.

Please Login or Register  to view this content.

These do get the cell range in the loop and sets it as a named range.

Thank you for your help - it is appreciated. Such a stupid error!