I'm sorry... I meant that you could record a macro that copies a named range
from a hidden worksheet, right? Why step through entering each cell with the
macro is what I mean. Why not just have the macro copy the cells from the
hidden worksheet?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Frantic Excel-er" wrote in
message ...
I think so, but my boss wants them in every worksheet that I validate, so
it
would be there just in case it was ever referenced....

"Anne Troy" wrote:

If this is always the same, wouldn't it be simpler for you to copy some
cells from a hidden sheet instead?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Frantic Excel-er" wrote in
message ...
Hi All...

I have code that contains the following:

ActiveCell.FormulaR1C1 = "USB"
Range("A2").Select
ActiveCell.FormulaR1C1 = "04165"
Range("A3").Select
ActiveCell.FormulaR1C1 = "14709"
Range("A4").Select
ActiveCell.FormulaR1C1 = "14716"
Range("A5").Select
ActiveCell.FormulaR1C1 = "24704"
Range("A6").Select
ActiveCell.FormulaR1C1 = "44705"
Range("A7").Select
ActiveCell.FormulaR1C1 = "44710"

and it goes on to enter the associated text on the next line...all the
way
down to 60 rows. Is there a way that I can consolidate these steps
where
the
macro will automatically know to put the text in the next
rows......for
example....
MACRO CODE = Enter Text, start A1...FAS,12354, 23456