Excel Paste - Positioning of Pictures 1

[ajcarr]

I have an application which needs to insert pictures at particular positions in an Excel workbook.(These are organisation logo's). However, I can't find out how to control the exact positioning within a spreadsheet. Selecting a cell and pasting puts it roughly in the right area and I know I can move it by 'IncrementLeft' and IncrementTop but how do you control the initial positioning?

Incidentally, I've noticed that macro recorder in Excel 2007 doesn't record object movements to generate the 'Increment' movements while that in Excel 2003 does.

 

[SkipVought]

Hi,

Relative to a cell...

with TheRangeObject.TopLeftCell
   YourPicObject.top = .top
   YourPicObject.left = .left
end with

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ajcarr]

Thanks Skip. I spent hours searching through the help screens trying to find this. So simple when you know how.

Allan

 

[SkipVought]

Glad to share, Allan.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}