View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jneaves@clemson.edu is offline
external usenet poster
 
Posts: 7
Default Search in Multiple Sheets

Hey, I have a workbook with many worksheets. I am trying to write a
macro to search all the worksheets for a unique value. I have a
userform to enter the value and assign it to a variable. I just need
to search all sheet for that string, and if that string exists in a
worksheet, activate that worksheet. Anyone done anything like this?
Can you help?