J
J Streger
I have some code that repositions a picture. The code is:
myPic.Top = .Rows(lRow).Top + (.Range(.Cells(lRow, 1), .Cells(lRow + 2,
1)).Height - _
myPic.Height) / 2
In Excel 2003, this code runs fine and positions my picture in the middle of
the range. In Excel 2007, as I loop downwards on the sheet, this code no
longer keeps the picture in the middle and the picture starts creeping up. In
fact, after only 50 rows, if I even set the picture's top = a row's top, the
picture's top will be significantly higher than the row. What was changed
between these versions to cause this? All my pictures are sized so that
neither their height or width is greater than the cell range.
Thanks all!
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003
User of MS Office 2003
myPic.Top = .Rows(lRow).Top + (.Range(.Cells(lRow, 1), .Cells(lRow + 2,
1)).Height - _
myPic.Height) / 2
In Excel 2003, this code runs fine and positions my picture in the middle of
the range. In Excel 2007, as I loop downwards on the sheet, this code no
longer keeps the picture in the middle and the picture starts creeping up. In
fact, after only 50 rows, if I even set the picture's top = a row's top, the
picture's top will be significantly higher than the row. What was changed
between these versions to cause this? All my pictures are sized so that
neither their height or width is greater than the cell range.
Thanks all!
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003
User of MS Office 2003