Using VBA, delete a column in a range, not entire worksheet

[batman37]

I have a single row horizontal VBA range that starts with worksheet column F. Using VBA code, I want to delete a selected column from that range only, not from the entire worksheet. The range has been declared (Dim) and Set and used successfully in other code. But so far I have not found any combination of range name, Columns().Delete or EntireColumn().Delete that deletes only the one column from the range and not from the entire sheet. What am I missing? How should the line of code read to accomplish this deletion?

Thanks in advance.

 

[bebo021999]

What do you mean:

1) clear content of that range
or
2) clear content of that range, not whole column, but shift cells left

?

 

[batman37]

What do you mean:

1) clear content of that range
or
2) clear content of that range, not whole column, but shift cells left

?

I don't want to clear any content in the range, except for the specified column to be deleted, with a shift left for everything right of it. Because the range is a single row, the "column" to be deleted happens to be a single cell.

 

[Joe4]

Since you are just deleting a single cell, you can just use:

    ActiveCell.Delete Shift:=xlToLeft

to delete the selected cell.

 

[batman37]

Thank you Joe4. That worked beautifully in my application. I suppose that for a multi-row range, I could just For-Next through it by row and apply the same code to each row in turn. When I have some time I'll try it.

 

[Joe4]

Thank you Joe4. That worked beautifully in my application. I suppose that for a multi-row range, I could just For-Next through it by row and apply the same code to each row in turn. When I have some time I'll try it.

No need to do a loop.

If you have selected the cells you wish to delete, just use:

   Selection.Delete Shift:=xlToLeft

 

[batman37]

Thanks again Joe4. That also worked very well. I learn something new every day.