expression for offset()

[sakura.saki]

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!

[vba]count1 = Source2.Row - Source1.Row + 6
Sheets("Word").Range("A" & count1).Value = Sheets("teams CW").Range("F1").Value[/vba]

[Kenneth Hobs]

[VBA]Sheets("Word").Range("A" & count1).offset(,j).Value = Sheets("teams CW").Range("F1").Value
[/VBA]

[mikerickson]

if count1 is an integer, perhaps
[vba]Sheets("Word").Cells(count1, j).Value = Sheets("teams CW").Range("F1").Value [/vba]
if count1 is a cell,
[vba]Sheets("Word").Cells(count1.Row, j).Value = Sheets("teams CW").Range("F1").Value [/vba]

[sakura.saki]

thanks a lot! really thoughtful

[sakura.saki]

thank you too. but it was not what I meant. nevermind. solved already.:-)

[snb]

If you want to use numbers you'd better use 'cells':


[vba]

Sheets("Word").cells(Source2.Row - Source1.Row + 6,1).Value = Sheets("teams CW").Range("F1").Value
[/vba]