wibbers2000
05-27-2009, 05:02 AM
Hi,
I have looked at the forum but cant find the answer to this. I click a command button that transfers data from 1 sheet to another. Data and columns are irrelevant.
what I would like to do is... when this data is copied over (via a command button) is that column "B" end.xlup and offset by 3 rows to insert a picture from "C:\Users\Paul\Documents\Images\mouse.png"
I have used this file type as excel 2007 will use it and keep the transparant background. However if this becomes an issue I can change
it for an alternative file type.
The picture doent change and the user should not ne prompted to find the file.
Regards
Paul
I have looked at the forum but cant find the answer to this. I click a command button that transfers data from 1 sheet to another. Data and columns are irrelevant.
what I would like to do is... when this data is copied over (via a command button) is that column "B" end.xlup and offset by 3 rows to insert a picture from "C:\Users\Paul\Documents\Images\mouse.png"
I have used this file type as excel 2007 will use it and keep the transparant background. However if this becomes an issue I can change
it for an alternative file type.
The picture doent change and the user should not ne prompted to find the file.
Regards
Paul