Macro to Copy and Paste Specific Text in Column A on the last line with Text in Column B?

Hi,

I would like to know a VBA code to copy the word 'Name' in Column A from A1 unti A'x', where x is the last row with text in Column B.

In other words, if my Column B has 27 registries with text from B1 to B27, I want the macro to copy the word 'Name' in Column A from A1 to A27, however, if the number of rows are more or less in Column B, I want the code to know where is the limit to copy.


Thanks in advance for your support,
D2S

Thank you it works.