I'm Lost!!! Please help me!

  • Thread starter Thread starter Reefmonster
  • Start date Start date
R

Reefmonster

I have been trying to find a way to name a series of cells individuall
after a subsequent set of sheet names.

For example.

A1 on Summary sheet after a sheet labeled "IDF Build"
A2 on Summary sheet after a sheet labeled "Cabling Solutions"
A3 on Summary sheet after a sheet labeled "Nurse Call"
Etc....

Can you please help me with this issue?

Thanks,

Mat
 
try this in a sub
sub namecell
range("a1").name="IDF Build"
range("a2").name="xxxIDF Build"
range("a3").name="yyyIDF Build"
end sub
 
Don,

Please explain it to me like I'm 4....

I am proficient with Paly doh, and thats it.....

:o)

Thanks,

Mat
 
It's a macro. Copy it into a module and use alt f8 to execute it.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Don Guillett said:
try this in a sub
sub namecell
range("a1").name="IDF Build"
range("a2").name="xxxIDF Build"
range("a3").name="yyyIDF Build"
end sub
Click to expand...
 
Back
Top