NKlawender
New Member
- Joined
- Apr 5, 2022
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
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"
Here is the latest that I tried:
Range("B2:B" & Cells(Rows.Count, "A").End(xlUp).Row).Value = "WBT"