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

if i've understood correctly, you could try a Find and Replace (ctrl + F) with
Find: DSDDE|Times!
Replace: DSData|Times!

Hope this helps

-----
Kirsty

"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

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

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

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