Another quicky (yes I know, havent posted for a year, and now this week Im posting on the hour!)
On my spreadsheet I want to move a column at the start of the day (as one column is todays values, the one previous is yesterdays). I have tried the following but it doesnt like it:-
Code
Sub RQV()
'
' RQV Macro
' Macro recorded 14/03/2007 by U370131
'
Dim warn As Integer
warn = MsgBox("Do you wish to move RQV data to yesterday?", vbYesNoCancel)
Sheet1.Unprotect
Range("F2:F65536").Select
Selection.Cut
Range("E2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheet1.Protect
End Sub
Display More
It comes out with a run time error 1004? It needs to be a paste special as I just want the values put in. I have tried recording a macro to see how the vba code works, but it doesnt give me the option to paste special for some reason and I presume this is why the error occurs.
Ps I have booked myself on 4 VBA/Excel course over the next month so I hope to one day repay the favour back for some people!