Hi G,
Welcome to the Forum - try this:
Directions for running the routine(s) just suppliedSub ShiftLeft() Range("J4").Delete Shift:=xlToLeft End Sub
Copy the code to the clipboard
Open your Workbook
Save your Workbook or Another Workbook designated for Macros as Macro_Enabled
Press ALT + F11 to open the Visual Basic Editor.
Select “Module” from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
Bookmarks