Adding a common value to a column using VBA

[Chris123]

*first time attempting to use VBA
*mac excel 2011

Looking to add a common value within the range D1 to D8000 on Sheet1.
Example:
Current sheet contains the following;
D1 = 123
D2 = 583
D3 = 229
etc...to D8000

I need to add the letters "ALB" prior to each of these numbers.

What I need:
D1 = ALB123
D2 = ALB583
D3 = ALB229
etc...

(The "ALB" could be added at the end just the same, if there is a difference.)

[SamT]

@ All: See: Adding a common value to a column.

Chris, (I think that) I answered the question at the Mac Users Forum link above.