i have simple question regarding setting value cell in excel using vba.
the following code doesn't work, me it?
thisworkbook.sheets("name1").range("i"& 4 +k).value = activesheet.range("d" & k) thank you!
thisworkbook.sheets("name1").range("i" & (4 +k)).value = activesheet.range("d" & k).value how's that? brackets around (4 + k) calculation, , .value @ end allow value taken across.
Comments
Post a Comment