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.
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.