View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matthew Matthew is offline
external usenet poster
 
Posts: 47
Default A macro to paste values

In Excel we use a lot of formulas that link to our database and not everyone
who gets the excel sheets has the database. I want to write a macro that will
select every sheet in the workbook, select all cells and paste values. But
because the sheet names and the number of them are usually different i need
it to know to pick all the sheets availanle? Can anyone help with the
coding?!?