Hi everybody,
I have a range activatedRange(strPlageSélectionnée).Activate
, and i'm looking for selecting their entire columns in order to delete them. I know that to select a column there is a specific formulaActiveCell.EntireColumn.Select
and to delete one column it'sActiveCell.EntireColumn.Delete
But how can i select and delete many columns at once. Is there any specific formula ?
Thanks for your help
Image1.jpgImage2.jpgImage3.jpgImage4.jpg
Last edited by Ramo964516; 02-28-2016 at 01:27 PM.
Maybe
Selection.EntireColumn.Delete
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Hi Paul_Hossler,
I usedand it works. thanks for your helpRange(strPlageSélectionnée).EntireColumn.Delete
Hello Ramo964516,
Alternatively, if you want to delete contiguous ranges based on a single selected cell, such as G1 for example, you can do this -
Hope that helps!Range(strPlageSélectionnée).Resize(, 2).EntireColumn.Delete ' change 2 to any number of contiguous columns
Last edited by williedog; 03-03-2016 at 08:38 AM.
Posting Permissions
Reply With Quote
