VBA picked the wrong column when specifying Range("B" & lastrow)

[lynnsong986]

Hello,

I encountered a very strange thing today.

I have a worksheet change event that updates a financial statement structure on a tab named "Model"

I have a line in the code that simply is:

Please Login or Register  to view this content.

but when this code is run, the value somehow ended up in column C instead of B, in the correct row.

I literally had to add offset(,-1) to get it back to column B.

does anyone know why this has happened?

thanks so much

[jolivanes]

And the rest of the code is..........

[lynnsong986]

Please Login or Register  to view this content.

this is the part that is relevant, the event code is quite lengthy. thanks for taking a look!

[Fluff13]

It's because you are using that with range B

Please Login or Register  to view this content.

this is effectively

Please Login or Register  to view this content.

which is column C

[lynnsong986]

oh thank you soooo much!! I totally forgot how that part works!

[Fluff13]

Glad to help & thanks for the feedback.