Excel VBA- Range as picture

By Ajeet Kumar

EXCEL TO SYNCHRONIZE THE DATA RANGE AND PICTURE ELEMENT

1. Select a data range in worksheet.
2. Name it in the Name Box.
3. Select the range
4. Copy the range as Picture using ALT + H, C, P
5. Paste the picture at any suitable place at the worksheet.
6. Select the picture and in the formula bar, pass the named range as formula
7. Now change any value in the data range, the change will be reflected in the picture.
8. If you place any picture in the data range, it will appear in the picture. For example, you can place picture in each cell of the data range.