Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Deleting columns through links

  Asked By: Binge    Date: Nov 03    Category: MS Office    Views: 695
  

I am creating columns dynamically and having some data in each column. I want to have a link at the top of each column, which is used to delete the corresponding column. Can any one help for this.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Liam Bouchard     Answered On: Nov 03

While I'm not sure exactly what you mean by "creating columns  dynamically", if all you're trying to do is delete  the column  you could do it with the following code. Just change the column letter to reflect which column you're trying to delete.

Range("a1").entirecolumn.delete

If you're just trying to delete the data, but leave the column itself so as not to mess up formulas:

range("a1").entirecolumn.clearcontents
Worksheets("Sheet1").Columns("A").Hidden = True (Assuming you want to hide the empty column)

Hopefully that helps you out

 
Answer #2    Answered By: Hababah Younis     Answered On: Nov 03

Thanks for your reply. I worked on it and it is working fine.

 
Didn't find what you were looking for? Find more on Deleting columns through links Or get search suggestion and latest updates.




Tagged: