gvreddyhr
03-05-2013, 12:44 AM
Hi ,
Thank you very much for continuous support for my previous posts, I require help in tweaking the code.
I have the data in excel where team updates trackers and lot of formulas are put in place, now I want to give option to freeze the data, when they “Freezedata” macro, which they have updated should be copied and paste special values in the same rows, the dependent row would be E7 to (xldown), can anyone help me with tweaking this code
Sub freezedata()
Range(Selection, Selection.End(xlDown)).Select
Rows("7:86").Select
Range("E7").Activate
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("E7").Select
End Sub
Regards,
GV Reddy
Thank you very much for continuous support for my previous posts, I require help in tweaking the code.
I have the data in excel where team updates trackers and lot of formulas are put in place, now I want to give option to freeze the data, when they “Freezedata” macro, which they have updated should be copied and paste special values in the same rows, the dependent row would be E7 to (xldown), can anyone help me with tweaking this code
Sub freezedata()
Range(Selection, Selection.End(xlDown)).Select
Rows("7:86").Select
Range("E7").Activate
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("E7").Select
End Sub
Regards,
GV Reddy