in excel i wanted to be able to find the last cell in column a that is being is being used. so for example if the last cell is A10 then i would set a variable to get this number.

ive done this using some code.

but what i want to do is

for i - 0 to LastCell

each cell . value = "Hello"

next i

how do i do this, thing is i know you can say

Dim BCell as Range

For each BCell in range("A1:A10")
BCell.value = "Hello"
next BCell

But i do not know what the "A10" will actually be as people might add / remove rows which means the last cell will change,

so basically

Dim BCell as Range

For each BCell in range("A1:LastCell")
BCell.value = "Hello"
next BCell

this didnt work tho,

any help please??

Thanks,

ahh figured it out

For each BCell in range("A1", LastCell)
BCell.value = "Hello"
next BCell

used a comma to seperate the cells

cheers anyways guys