hello gurus,
could someone help me tweak the below code, for whatever reason the data doesnt paste. i'm trying to avoid copy / paste to speed up the macro. TIA
Sheets("XXX").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.CurrentRegion.Value = Sheets("YYY").Range("a1").Value
could someone help me tweak the below code, for whatever reason the data doesnt paste. i'm trying to avoid copy / paste to speed up the macro. TIA
Sheets("XXX").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.CurrentRegion.Value = Sheets("YYY").Range("a1").Value