I can't use Offset and change value at the same time

[mps111]

Hi everyone! I don't know a lot about Excel and I haven't done anything with it in the last year, so I forgot most of what I knew. I have recently started to work with it again and I'm struggling a lot.
The macro I'm writting has an error in this line:

Please Login or Register  to view this content.

I have also tryed it like this:

Please Login or Register  to view this content.

Can someone tell me please whats wrong?

Thanks everyone

[Pete_UK]

Have a read through the Forum Rules at the top of the page, and then amend your title to something more meaningful before the mods force you to do so.

Maybe you can also explain what E1 is - a variable?

Pete

[mps111]

E1 is a cell. Can't I use it this way? I don't remember how all this works - have been working online instead, in some websites...

[StephenR]

If you want to set the value of the offset cell to that of E1 then this

Please Login or Register  to view this content.

[jeffreybrown]

You can try...

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Pete_UK]

Try it like this:

Please Login or Register  to view this content.

Hope this helps.

Pete

[mps111]

It doesn't work like this:

Please Login or Register  to view this content.

or like this:

Please Login or Register  to view this content.

But I think the problem isn't there because if i replace the cell for "1", it still doesn't work...

[StephenR]

What do you mean "doesn't work"? Error message? Which is the active cell?

[Pete_UK]

Don't know what "doesn't work" means. Wrong result, error of some kind, computer blows up ??

Which is the ActiveCell when you get to that line? If it is in column A or B then you can't move 2 columns to the left to write the value of E3 there.

Pete

[StephenR]

Pete_UK: snap.

[mps111]

Yes, error message.

This is the full code:

Please Login or Register  to view this content.

So yes, it selects a cell before that line

[StephenR]

Perhaps explain what you're trying to achieve - there might be an easier way?

[mps111]

I need to check, for every row, if C1 is bigger than collumn C and if it is, than A is 1. If it isn't, A is 0. This is the way I'm trying to do it, if there is an easier one, great.