Hi can anyone help?
I want to add transpose to the Copy ToSht.Range, is there a way to do this?
I would like the copy to transpose to AK20:AK21![]()
Private Sub CommandButton3_Click() Set FromSht = Sheets("Sheet1") Set ToSht = Sheets("Sheet2") r = 2 While FromSht.Cells(r, "A") <> "" And FromSht.Cells(r, "C") <> "" r = r + 1 Wend If FromSht.Cells(r, "A") <> "" Then FromSht.Cells(r, "C") = 1 FromSht.Range("A" & r & ":B" & r).Copy ToSht.Range("AK20:AL20") End If End Sub
Any help would be apprieciated
Regards
pwill32
Bookmarks