Rename columns headings VBA in excel

[vbanewbie68]

Hi Sir/madam

I have a question to ask please in relation to VBA macros as see below.

When I download data from a platform that is linked to a donation page I would like the macro to rename the column headings. Please find attached the highlighted information below: to get the macro to rename the First Name and the Last Name to Donor First Name and Donor Last Name.

Thank you

Best Regards

Vbanewbie68

 

[Peter_SSs]

Like this?

Sub RenameHeadings()
  With Rows(1)
    .Replace What:="First Name", Replacement:="Donor First Name", LookAt:=xlWhole
    .Replace What:="Last Name", Replacement:="Donor Last Name", LookAt:=xlWhole
  End With
End Sub

 

[vbanewbie68]

Like this?

Sub RenameHeadings()
  With Rows(1)
    .Replace What:="First Name", Replacement:="Donor First Name", LookAt:=xlWhole
    .Replace What:="Last Name", Replacement:="Donor Last Name", LookAt:=xlWhole
  End With
End Sub

Hi Peter_SSs

Thank you for this and it works on my end successfully.


Regards

V

 

[Peter_SSs]

Glad to help.