How to delete entire.column between a Range.

[Trev0j]

Hello,

what I want to do is:

i have a ranged name" Adjusted" and ranged name " Start" which is located in A1. i want to delete entire columns between range "Start" and "Adjusted". wherever the range " Adjusted" is located.
btw, before this code, need to find the range "Adjusted" and delete all the columns in between A1

I am thankfull for every help!

 

[Joe4]

Does the "Adjusted" range ever contain more than one column?
If so, what do you want it to do in that instance?

Let's say that "Adjusted" is in column D. When you say delete entire columns between "Start" and "Adjusted", does that mean just deleting columns B and C in that instance?

 

[Rick Rothstein]

Hello,

what I want to do is:

i have a ranged name" Adjusted" and ranged name " Start" which is located in A1. i want to delete entire columns between range "Start" and "Adjusted". wherever the range " Adjusted" is located.

I am thankfull for every help!

Are the ranges "Start" and "Adjusted" full column ranges?

Do the ranges "Start" and "Adjusted" each contain only one column?

 

[Fluff]

How about

Sub del()
Range(Range("Start").Offset(, 1), Range("Adjusted").Offset(, -1)).EntireColumn.Delete
End Sub

 

[Trev0j]

Yes! just deleting all the columns between A1 and wherever the "Adjusted" fall.

 

[Trev0j]

How about

Sub del()
Range(Range("Start").Offset(, 1), Range("Adjusted").Offset(, -1)).EntireColumn.Delete
End Sub

Thank mate but unfortunately this code is giving me runtime error 1004

 

[Joe4]

Fluff's code works for me.
Do you have any merged or protected ranges in your sheet?

If you run this code, what does it return?

Sub Test()
    MsgBox Range("Start").Address & vbCrLf & Range("Adjusted").Address
End Sub

 

[Trev0j]

Fluff's code works for me.
Do you have any merged or protected ranges in your sheet?

If you run this code, what does it return?

Sub Test()
    MsgBox Range("Start").Address & vbCrLf & Range("Adjusted").Address
End Sub

Thanks.its the same error: Method 'Range' of object'_Global' failed

 

[Fluff]

Are both named ranges on the active sheet, when you ran the code?

 

[Rick Rothstein]

Thanks.its the same error: Method 'Range' of object'_Global' failed

Is "Start" and "Adjusted" actual Excel Defined Names or are they just range variables set within your code?