You're welcome Roy........happy to help.

Vaya con Dios,
Chuck, CABGx3



"Roy the rooster" wrote:

That was fantastic thanks!!

"CLR" wrote:

Edit Replace Replace: DSDDE ReplaceWith: DSData ReplaceAll

Vaya con Dios,
Chuck, CABGx3



"Roy the rooster" wrote:

How do I change 5000 cells from DSDDE|Times!'V2647:B' to
DSData|Times!'V2647:B' Where the 2647 is a different number in every cell