Hi I have one last question.
In my worksheets there are formulae in all of the following cells: B43:G52
I want to create a macros where if all those cells do not have any values greater than 0 or are empty, i.e. "". Then an image, titled "Picture 1" from Sheet 2 will be pasted in B43.