I have three worksheets, Me, Vm & Pl, in which I named cells for use in
macro's and other functions. The next step is to copy each worksheet and
rename them Ve, Vm & Vl. As expected, the cell names of the newly copied
worksheets stay the same with the exception of the worksheet name being
different. I assumed that I cannot have two cells in a workbook, not
worksheet, with the same name. If I can, it would reduce the time to rename
cells in the copied worksheets. Also, when I copy the VB associated with the
original worksheet to the copy worksheet, all I should need to do is find and
replace the worksheet names. Can someone help clarify if I can have duplicate
names or will need to delete the second and third occurance of the names and
enter the corrected versions? Any help would be appreciated. Thank You, JAD