Amending List Validation Ref

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

I have a workbook with roughly 30 sheets, In 24 of the
sheets Range("E2:E250") I have a data Validation -> List
and the list ref refers to a range on that sheet, I want
to change this range to 'Suppliers' Can anyone think of a
quick way of doing this - I tried grouping the sheets but
this didnt seem to work.

TIA
 
Record a macro while you do it manually once.

Then you can add a loop to loop through the sheets
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cant find VLookup property 5
Run macro from active workbook whose name keeps changing 20
validation list from worksheet given by ref 5
Code to change a named range 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Add sheet and name it unless it already exists 12
List of items from other sheets 2
Code to Implement Required Cells Not Working 3

Back
Top