Hello,
Does anyone know how to write a VBA code to delete all values in columns L to V. I would like to delete every value in these columns except from the value that appears in row 1.
Cheers
Wetfish
Hello,
Does anyone know how to write a VBA code to delete all values in columns L to V. I would like to delete every value in these columns except from the value that appears in row 1.
Cheers
Wetfish
This is one way of doing it....
Sub ClearLV() Range("L2:V65536").ClearContents End Sub
Ted
"Live Long and Prosper"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks