Delete the Range of Columns in Excel VBA

Question

I am trying to delete the range of columns but getting error "Application Defined or object defined error". In the below code wks is the worksheet and colStart and colEnd are variables with values.

Dim colDelete As String

colDelete = wks.Range(wks.Cells(1, colStart), wks.Cells(1, colEnd)).EntireColumn.Delete

This code works for me. Are you sure wks is a properly assigned worksheet object, and colStart and colEnd are >0 whole numbers? Are you sure the worksheet is not protected? Can you post some more of your code? — vacip
– vacip, Commented Jun 17, 2015 at 15:14

vacip · Accepted Answer · 2015-06-17 15:30:10Z

2

Declare your variables. Always.

dim colStart as long
dim colEnd as long
dim wks as Worksheet

It should work this way.

answered Jun 17, 2015 at 15:30

vacip

5,4563 gold badges29 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nandish · Accepted Answer · 2015-06-17 15:25:18Z

0

enter image description here

Yes vacip the colStart and colEnd has integer values as you can see in watch screen of my image. And also wks is properly assigned worksheet object.

answered Jun 17, 2015 at 15:25

Nandish

5124 silver badges9 bronze badges

4 Comments

vacip Over a year ago

Well, they are actually strings, not numbers. I'll post an answer, but you need to declare your variables.

Nandish Over a year ago

Actually I have declared my variables in my code. The code is too long so not able to paste the whole code here.

vacip Over a year ago

Ok, so why does it say Type: "string" in your watches window?

Nandish Over a year ago

Thanks Vacip. I got my mistake. My variables are string. My bad. Thanks a lot

Collectives™ on Stack Overflow

Delete the Range of Columns in Excel VBA

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related