Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this piece of code:
newfname = EDIFormP6.WeeklyOutputp6.Value & Format(Date, "dd.mm.yyyy") & "TESTING" & ".xls" Open newfname For Output As #1 Range("A1").Select Cell_Contents = "UNS1" Print #1, Cell_Contents Selection.Offset(0.1).Select Cell_Contents = "LIN1" Print #1, Cell_Contents Selection.Offset(0.1).Select Cell_Contents = "NAD2A" Print #1, Cell_Contents close #1 Now, when i look at the excel file after the code has run, the UNS1, LIN1 & NAD2A is appearing all in column A down 1 2 & 3, ive tried various different codes which i would of thought would put them all in row 1 columns A B & C but it just always seems to but them in all in column A. am i missing something here? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inputting data into excel to create csv file | Excel Discussion (Misc queries) | |||
Alignment Data Label changes when opening file Excel 2007 | Charts and Charting in Excel | |||
inputting figures in cells | Excel Discussion (Misc queries) | |||
open file by inputting file name in cell? | Excel Discussion (Misc queries) | |||
Inputting duplicate data alert MS Excel 2003 | Excel Discussion (Misc queries) |