Hi all

I am currently working on a project and I have a formula with fixes postcodes if required, I want to be able to code it so I get the same result without have to copy and then pastespecial. Basically the column is going to be user generated with an input box but its the actions of the formula itself I need translating.

Selection.formula = "=TRIM(IF(ISBLANK(H2),"""",IF(RIGHT(H2,4)<>"" ""&RIGHT(H2,3),UPPER(LEFT(H2,LEN(H2)-3)&"" ""&RIGHT(H2,3)),UPPER(H2))))"
I apologise for asking what may seem like a basic beginners question but I have only just started out.

Thanks in advance

Dave