Hey dudes/dudettes
I need the K3:K9 range to copy only the value and not the formula for the cells. Ive just started with vb and although im finding it hard to use im finding it incredibly interesting. Any help would be greatly appreciated.
Thanks
Andrew
Below is my script.
Sub Yay()
Dim rng, dest As Range
Worksheets("Calendar").Activate
Set rng = Range("N3:N8")
rng.Copy
Worksheets("Enquiry Sheet").Activate
Set dest = Cells(Rows.Count, "b").End(xlUp).Offset(1, 0)
dest.PasteSpecial Transpose:=True
Application.CutCopyMode = False
Worksheets("Calendar").Activate
Set rng = Range("K3:K9")
rng.Copy
Worksheets("Enquiry Sheet").Activate
Set dest = Cells(Rows.Count, "b").End(xlUp).Offset(0, 5)
dest.PasteSpecial Transpose:=True
Application.CutCopyMode = False
Worksheets("Calendar").Activate
End Sub
Bookmarks