How do I change my code to offset to the....

[Mark Lowe]

info into columns rather than rows??

here's what I have.....

Sheets("COLUMN").Range("A65536").End(xlUp).Offset(1, 0).Value = CN
Sheets("COLUMN").Range("C65536").End(xlUp).Offset(1, 0).Value = FB
Sheets("COLUMN").Range("E65536").End(xlUp).Offset(1, 0).Value = FA
Sheets("COLUMN").Range("G65536").End(xlUp).Offset(1, 0).Value = CW


As always, thanks for the info.

 

[Juan Pablo González]

Not clear what you expect...

Offset has two parameters, rows and columns, if you need to offset one column to the right you can use.

MyRange.Offset(,1)

 

[Mark Lowe]

How do I change the code so that the info goes into the next available column to the right? If I write it as.....

Sheets("COLUMN").Range("A65536").End(xlUp).Offset(0,1).Value = CN

........wouldn't that put the info in column B?? I'm confused