Selecting a range of columns based on a cell value

Good morning.

I am deleting a range of columns once a month using the following as part of a bigger routine


Columns("B:CI").Select
Selection.Delete


The column selction always starts at "B" however the width changes every month.

B:CI =Jan 2016
B:CJ =Feb 2016
B:CK =March 2016

On a seperate worksheet I want to be able to type "CK" in a specific cell and the macro to select columns B:CK, likewise if I typed "DE" in the specified cell the macro would choose columns B:DE

Many thanks
Phil

You could use this code:

Please Login or Register  to view this content.

where in range A1 you write CI or CJ or other.

You could also use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Another option using an Input Box

Please Login or Register  to view this content.

Woks a treat, thank you very much.

Thank you for the help Antonio

Phil