sakura.saki
06-20-2012, 06:16 AM
Hi I am now having a problem with the expression: I wish to express the cell like:
range("A").offset(0,j)&count1.row (this is of cause wrong)
or something like: Sheets("Word").Range(("A").Offset(0, j)& count1).Value = Sheets("teams CW").Range("F1").Value (this is also wrong)
which means the column j from A and then the the cell within it which is determined by row number of count1.row...I have the following but donīt known how to add the offset(j,0) into it to have the right expression....can anyone help with it? thanks!
count1 = Source2.Row - Source1.Row + 6
Sheets("Word").Range("A" & count1).Value = Sheets("teams CW").Range("F1").Value
range("A").offset(0,j)&count1.row (this is of cause wrong)
or something like: Sheets("Word").Range(("A").Offset(0, j)& count1).Value = Sheets("teams CW").Range("F1").Value (this is also wrong)
which means the column j from A and then the the cell within it which is determined by row number of count1.row...I have the following but donīt known how to add the offset(j,0) into it to have the right expression....can anyone help with it? thanks!
count1 = Source2.Row - Source1.Row + 6
Sheets("Word").Range("A" & count1).Value = Sheets("teams CW").Range("F1").Value