Column deletion using column numbers as user input (how to change syntax of ranges)

Hi all. I am using the following code to input column numbers and delete those columns. This deletion differs for each client, hence the macro. I am currently trying to code out the column numbers for the user instructions but am running into a difficulty. The current syntax allows me to list a single column number followed by a comma. How would I change the code below to allow for ranges? (e.g. instead of 1, 2, 3, 4...I would like to use 1-4). One of my deletion ranges for client A is columns 84-128. It would be too much for the user to input every single column number. NOTE: I would like the syntax to allow for single columns as well as ranges.

Please Login or Register  to view this content.

@JLGWhiz yes the columns are sometimes non-contiguous. Could you give specifics about how I would use an array? Thanks so much.

@Trebor76 I will give this a try! Thank you.

Thank you both! Robert's fix worked. I appreciate the input and support. VBA is exciting to learn but I am really only a few months in to coding.

Different method.

Please Login or Register  to view this content.