Address returned, Not Contents?
Hi! I am trying to paste an image into a cell who's address is calculated by the following: =IF(C32=1,MAIN!B2, IF(C32=2,MAIN!D2,IF(C32=3,MAIN!F2,IF(C32=4,MAIN!H2 , IF(C32=5,MAIN!J2,IF(C32=6,MAIN!L2,IF(C32=7,MAIN!N2 ,MAIN!B20))))))) The formula works fine to retrive the contents of the cell which in this case in not at all important. What I want to be able to provide to the VBA code is a cell location for it to past a picture into, not the current contents. Any help appriciated. Michael -- MJSlattery ------------------------------------------------------------------------ MJSlattery's Profile: http://www.excelforum.com/member.php...o&userid=16141 View this thread: http://www.excelforum.com/showthread...hreadid=320482 |
All times are GMT +1. The time now is 04:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com