Range.select + sheets.select

[DrewDog]

Is there any way to modify the following statement:


Range("c301").Value =
Range("c2").Offset(fromNewRow, 0).Value

so that after the "=" sign the target cell is on a
different sheet (like using the sheets.select command)?

Drew

 

[Bill James]

Please try:

Range("c301").Value = _
Range("YourOtherSheetName!c2").Offset(fromNewRow, 0).Value

Where "YourOtherSheetName" is replaced with the name of
your worksheet that contains c2.