Hi,

I'm trying to make a macro that will assign reference numbers to blank cells in a certain row (F11 downwards - the bottom of the range will be different each time I use this macro). The reference number will be something like 200S (the following would be 200T, then 200U, ... , 200Z, 201A, 201B, and so on).

I've only made macros using the record button before, so I'm not sure how to approach this. Could someone please point me in the right direction.

Cheers,

BSOD14