Could you attaché the excel file. Manish Purohit Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world.
-----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Telenochek Sent: 25 July 2009 01:22 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ How to retrieve the address of a cell used in a formula Hello everyone, I have a worksheet that calculates system performance on Sheet1 based on electronic components, whose data is located in other Sheets (sheets 2,3...n). I would like to have the user simply select a component from another sheet to place in a system, and have it import the rest of the data automatically. For example, suppose the user wants place an amplifier5 (located in "Amplifiers" sheet) instead of the resistor3 (located in the "Resistors" sheet) in my system. I'm wondering if there's a simple way to extract the source address from a formula. For example, suppose the user types the equals sign "=" and then goes to Amplifiers sheet and selects the name of the amplifier (located in E1 cell, where E2:E20) contain data relevant to this component. Now the formula for cell A1is: = Amplifiers!E1 How can I extract this address, so that I can automatically fill data from Amplifiers!E2:E20. CELL("address", A1) does not work, since it will return A1, not Amplifiers!E1 Do I have to write a macro with an InputBox, or is there an easier way? Assume a non-technical user, we don't want the user to type in =CELL ("address, etc..) Thanks --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
