VBA To Fill Empty Column

[NKlawender]

I have a question. I have an existing empty column, B, with a header. I would like to insert the text "WBT" into each cell in column B. The spreadsheet will have a different number of rows every time, so it would need to find the number of rows based on a different column, like column A. I have done a few searches and tried a couple of things, but it doesn't work.
Here is the latest that I tried:

Range("B2:B" & Cells(Rows.Count, "A").End(xlUp).Row).Value = "WBT"

 

[Fluff]

In what way doesn't that work?

 

[NKlawender]

In what way doesn't that work?

I moved where in the macro that line of code was and it worked. Not sure why.
Thank you for the reply, though.

 

[Fluff]

Glad you sorted it & thanks for the feedback.