Find and replace data in formula with VBA

[cameronem20]

Hi All,

I have been given this project to do and have very little knowledge about VBA, just the rest of the project.

What I need to know is:

1) A newly created worksheet has been created by VBA to be control!A1 " summary". How is it possible to also code it that this is the worksheet that it goes to to do the updating on?

2) On this newly created sheet control!A1 "summary", I need it to find and replace some data in a formula to change "Template" to the data in control!A1

Thanks Heaps
Cameron

 

[mdav2]

I take it you have a VBA program to create a new worksheet in a workbook but after that I don't understand what you want. Can you rephrase it with an example, you may get a response.