Macro to copy cell contents then used Find & Replace to put text elswhere.

Hi,
I am wanting to create a macro to do something fairly simple (well I think it is) but struggling with how.

I have a variable that will always appear in the same cell "A9" and I want to use the contents of that cell to replace text elsewhere in the document (of which location is not always the same).

Any help much appreciated.
Thanks
Aimee

Ok - will try to explain..
What I am doing is I have a quote for products that is generated from our database to an excel spreadsheet. Using macros I want to be able to click a button and convert it to an "order confirmation" for our customer to check and sign. I have all the other macros sorted to change various text and add fields but can't figure this out:

At the bottom of the document is a line that says "signed for My Company" the location of this line varies as it depends on the length of quote as to what cell it ends up in.
I want to take the text from cell A9 (Customer Name) and replace "My Company" so it reads "signed for Customer Name".

"Customer name" is a variable - however location (cell A9) will always remain the same.
"Signed for My Company" text will always be the same - however location will vary.


Hope this helps!

Thinking all I need is something as simple as this:

Sub ReplaceText()
ActiveSheet.Cells.Find("signed for my company").Replace What:="my company", Replacement:= contents of cell A9
End Sub

Only problem is with my very limited (basically nill) VBA experience I can't get the reference to cell A9 correct.
Can someone help me?
Thanks!!

Sorry I'm not quite sure what you are saying.
The location of "Signed for My Company" is variable so need to use a find and replace function. I just can't figure out how to take the contents of cell A9 and use that to replace the text.
My VBA skills are nil so been creating macros using 'record macro'.
I would just record a Macro using the Find and Replace in Excel but just can't figure out how to reference contents of cell A9. I end up with "Signed for A9" or "Signed for (A9)" etc.
So trying to figure out how to do it VBA but still can't figure out how to call up the contents of A9.

Cheers
Aimee

No I have a copy of an original excel quote generated by our database which has "Signed for My Company" text already at the bottom (because the length of the quote always changes the location is variable) .
I am wanting to take this quote and turn it into an order confirmation which means inserting the customer name in place of my company name. The customer name is always in cell A9.

Thanks macropd this works perfectly!!!! I was sure it was something simple I just needed to try and explain it to someone else!
I have no control of the Pronto (not Excel) database the original quote was coming out of I just had the end result which was a quote in Excel format. So my only option was use macros to change it to the order confirmation format I want.

Cheers
Aimee