Forum Discussion
Trying to delete a range using .SpecialCells(xlCellTypeConstants, 4).EntireRow.Delete not working
Afternoon I've inserted a column J into a macro that will put a 2 on each line when the current period and year, plus the previous year and period are a selected value in Excel and this works wel...
After looking at this for ages .. I tried copying the column J with the formula in and pasting it as values:
Columns("J:J").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
then running the above and its worked fine. Thank you for your help though
Ros
Columns("J:J").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
then running the above and its worked fine. Thank you for your help though
Ros