Macro that will rename ONLY cell A1 with Invoice Number

[amandeep08]

Currently i have macro that will rename the complete 1st row with the data i have mentioned.

I want the Macro that will rename ONLY cell A1 with "Invoice Number"

 

[jasonb75]

You just need to change the range in the macro that you already have.

If you want both options readily available then you will need to create a copy of the whole procedure and rename one of them.

 

[amandeep08]

You just need to change the range in the macro that you already have.

If you want both options readily available then you will need to create a copy of the whole procedure and rename one of them.

Actually I have to change names of multiple cells in row 1. I thought if someone can help change one cell, I will be able to change rest of them

 

[jasonb75]

As I already said,

You just need to change the range in the macro that you already have.

I have not seen the code that you already have so I do not know what needs to be changed.

When you post it, please remember to use VBA tags so that it is formatted properly.