I have a macro that copy values from sheets to a summary sheet (OutSh)
For that I use this line, as an example:
That is working fine, but how can I take the value from a String variable, Temp2 and "paste" it the same way?![]()
Range("B2").Copy Destination:=OutSh.Cells(rows.Count, 1).End(xlUp).Offset(1, 1)
I want to use this method.Thanks![]()
Destination:=OutSh.Cells(rows.Count, 1).End(xlUp).Offset(1, 1)
![]()
Bookmarks