Insert the word GBP into Cell D1

[MAButler]

Every time my VBA code is run I need the word "GBP" to insert in to Cell D1, and the Format of column D to change to right.

[teylyn]

Fire up the macro recorder. Enter GBP into D1. Format column D to right justified. Stop the macro recorder.

There's the code you need. You can tidy it up to remove the Select statements Excel puts in.

[Richard Buttrey]

Hi,

Perhaps?

Please Login or Register  to view this content.

Regards