Write to the neighbo(u)ring cell 1

[eti3nne]

I have written some data into say Cell AA12 now I want to write to AB12. How do I code this move to the next column? (I write to the first cell correctly becuase I have previously stored its location (ActiveCell) whilst I fetch the result from a sheet elsewhere; the second write will also get its value from that same sheet elsewhere).

Next time I may write to say, D34 first, so I'll need to write the second value to E34 subsequently.

Any ideas?

Thanks for looking.

 

[SkipVought]

hi,

I have written some data into say Cell AA12...

HOW? Your code, please.

Generally...

YourCellObject.Offset(0,1).value = [i]someValue[/i]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[eti3nne]

That'll do nicely thanks, Skip*.

Cheers,

Steve.