Hi All,
I have a Macro that inserts a picture into a range of cells on a single worksheet, this is all working fine however it needs to appear below some text, the picture inserts fine on my normal view however when I go to print preview it moves well off the printable view - you can just see the edge of it despite the picture being directly under the text when I use any of the views.
In order to get it to align under the text I have to move it across a lot of other text and half way through a cell which of course I can't write into my macro.
I have 'print object' ticked and it appears on the print preview - just miles to the left (right when looking at screen) of where it shows on my normal view.
Is there something I am doing wrong?
Any ideas would be appreciated.
Regards
I have a Macro that inserts a picture into a range of cells on a single worksheet, this is all working fine however it needs to appear below some text, the picture inserts fine on my normal view however when I go to print preview it moves well off the printable view - you can just see the edge of it despite the picture being directly under the text when I use any of the views.
In order to get it to align under the text I have to move it across a lot of other text and half way through a cell which of course I can't write into my macro.
I have 'print object' ticked and it appears on the print preview - just miles to the left (right when looking at screen) of where it shows on my normal view.
Is there something I am doing wrong?
Any ideas would be appreciated.
Regards