Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I'm currently working on a macro that takes a list of values from one sheet as a 'Columns to delete' list. I want to take this list, select a set of headings on another sheet, and if the heading matches my 'columns to delete' list, delete the column. I know how to select the 'columns to delete' range, and the headings to check range on the other sheet. I'm also aware that as I'll be deleting columns as I go I'll need to parse them in reverse, starting on the right and going left. What I can't quite figure out is how to put all that together into code. In looking things up I believe I can do something like a 'For i = varTitles.Columns.Count to 1 Step -1' to go in reverse, I'm just not sure how to compare the contents of both lists. Any ideas? Much appreciated!! -Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert vertical blocked list to horizontal list? | Excel Worksheet Functions | |||
copying formula for horizontal data to vertical in different sheet | Excel Worksheet Functions | |||
change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
Display Excel list from vertical to horizontal | New Users to Excel | |||
Converting a large vertical mailing list into a horizontal format | New Users to Excel |