Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I align pictures to the columns in code
Hello, I want to bring in pictures and align and size them so that they sit
exactly between the borders of the B column The left side of my shape should end up on the border between A and B and the right side, on the border between B and C Does that make sense? The columns in the sheet may be different sizes so I'll need to include a way of locating the left and right before positioning the picture. I can't assume they'll always be the same. Is this possible Many thanks M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I align pictures to the columns in code
Try this (changing the worksheet name and picture shape name references to
what you are using in your code)... With Worksheets("Sheet1").Shapes("Picture 1") .Left = Range("B:B").Left .Width = Range("B:B").Width End With -- Rick (MVP - Excel) "Michelle" wrote in message ... Hello, I want to bring in pictures and align and size them so that they sit exactly between the borders of the B column The left side of my shape should end up on the border between A and B and the right side, on the border between B and C Does that make sense? The columns in the sheet may be different sizes so I'll need to include a way of locating the left and right before positioning the picture. I can't assume they'll always be the same. Is this possible Many thanks M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare 2 columns and align duplicates into same row | Excel Worksheet Functions | |||
How to add and align pictures and text in headers | Excel Discussion (Misc queries) | |||
Format and Align Columns | New Users to Excel | |||
Compare and align columns of data | Excel Programming | |||
How to align entries in columns so other columns will follow ? | Excel Programming |