View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Find reference to specific range in code

Hello,
Find/Replace in the VBE works pretty much the same as it does
on an Excel worksheet.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)





wrote in message
Hallo,
Is there any fast way to check if a specific worksheet range is
referred to in my VBA code? (Find ???)
I suppose it's a common problem when you move data from unnamed cells
in a worksheet to another place on the same worksheet . It may
require to review all the references in the code that refer to the
changed cells.
Thanks for any advice.
Herman