Looking for some help. I am an experienced user of excel, but usually have to piece-meal macros together to make them work.
The problem I am having is that my macros (hiding empty rows in a given sheet) are slowed way down when I put a linked picture on the sheet. I am looking for some code to insert into my subs to 'turn off' the picture link in the beginning and 'turn on' the link at the end.
My pictures are linked as follows:
1) Photo list on separate sheet (Each picture 100% contained in a single cell).
2) Create name for each cell for each picture. "Picture1" "Picture2" ETC.
3) On my setup sheet, I have an IF equation to determine what cell name to display. Cell B10 =IF($A$1="x","Picture1",IF($A$2="x","Picture2",""))
4) I then use Define Names to direct the final photo to the IF statement cell. FinalPicture =INDIRECT('SetUp'!$B$10)
5) Finally after pasting a picture on my final sheet, I enter into the formula bar the Defined Name. =FinalPicture
This allows me to display a different picture based on what selection is made.
This all worked great, until I went back to use my simple macros that hid empty rows to consolidate a large list. It takes 3+ minutes to run instead of 2-3 seconds.
Any help would be appreciated.
Bookmarks