VBA to clear contents based on list of sheet names

[westend9876]

I have a sheet called 'Clear'. Column A has the names of other sheets in the workbook. Column B has the range of cells listed like this B1, B2:B5, B10:B11, B14, B18:B22, B25, B29:B33, E25, H12:H14 for which I need to clear contents for each corresponding sheet listed in Column A.

I need VBA code to run macro that will cycle through all of the sheets in Column A on 'Clear' worksheet and clear contents for the range of cells listed in Column B.

 

[Nebu]

Hi:

This is relatively easy to do, upload a sample file.

Thanks

 

[westend9876]

Hi:

This is relatively easy to do, upload a sample file.

Thanks

The workbook is rather large. May you put a sample code together? I can modify once I see the correct syntax and logic.

 

[Nebu]

Hi:

I am not going to create a sample file for you and write code, you will have to upload a sample file if you need help.

Thanks