Let's say I have the following to delete the contents of
Column 68 to 256.

Sheets("Main").Select
Application.GoTo Reference:="C68:C256"
Selection.Delete Shift:=xlToLeft

but instead I want the reference to be from a named range -
say "last_column" which is the number 67. How would I
change the above code to referenc the number in the range
vs manually edititing the code? Looking for same help
with row (say "last_row" = 100)