| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
manipulating pictures with VBA
I've created an extensive macro that produces 5 reports across 5
worksheets within a workbook. My client would like all 5 reports to be arranged on one formatted printable worksheet. I thought I would use Excel's copy picture function since the reports are of varying lengths and column widths. My problem, however, is how do I code where I can find the end of a picture is so when I go to paste the next report it doesn't overlap? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
manipulating pictures with VBA
once pasted, the picture will be a shape and have an TopLeftCell and
BottomrightCell property. Cells(activesheet.Shapes(1).BottomRightCell.Row+2, 1).Select -- Regards, Tom Ogilvy "sec12205" wrote in message ... I've created an extensive macro that produces 5 reports across 5 worksheets within a workbook. My client would like all 5 reports to be arranged on one formatted printable worksheet. I thought I would use Excel's copy picture function since the reports are of varying lengths and column widths. My problem, however, is how do I code where I can find the end of a picture is so when I go to paste the next report it doesn't overlap? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
manipulating pictures with VBA
Perfect! It worked! Thanks a bunch, Tom!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
| Manipulating certain rows only | Excel Worksheet Functions | |||
| Storing Clip Art pictures in My Pictures folder | Excel Discussion (Misc queries) | |||
| manipulating dates | Excel Worksheet Functions | |||
| Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
Linear Mode
