Resize an Object to a Range Size - VBA Code Examples

Return to VBA Code Examples Menu

VBA – Resize an Object to a Range Size

Associated Files Download Links

Resize Object to Range Size in VBA

You can size an object like Pictures, Autoshapes, and Charts to be the same size as a Range. To do this, set the objects .Left .Top .Width and .Height properties equal to the respective properties of a Range.

The following example sizes a Chart to the Range B2:D6

size object to range size

The VBA code used to accomplish this:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

Sub SizeChart2Range()

Dim MyChart As Chart

Dim MyRange As Range

Set MyChart = ActiveSheet.ChartObjects(1).Chart

Set MyRange = Sheet1.Range("B2:D6")

With MyChart.Parent

.Left = MyRange.Left

.Top = MyRange.Top

.Width = MyRange.Width

.Height = MyRange.Height

End With

End Sub

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!

<<Return to VBA Examples

Did you find this VBA tutorial useful? Then share it with your friends and colleagues:

Was this helpful?
You might like these related Code Examples...

Delete Rows that Meet Certain Criteria in VBA The following Subroutine will delete each row in a range where the value in Column A begins with a prescribed piece of text: For example ...

Commenting in VBA This article will teach you how to comment a single line or multiple blocks of code in the VBA Editor. To learn about how to interact with E...

Using Isnumeric and Isnumber in VBA This article will teach you how to use the and functions in VBA to check if values are numbers. IsNumeric is a built-in VBA function, w...

Isempty function in VBA In this article, you will learn how to use the function in VBA to check if a cell is empty. If you want to do the same in Excel, a similar ...

VBA Char / Chr Function Every character in Excel has an assigned number code to itself. The function in VBA returns a character for a given number (ASCII) code. In...

VBA Upper, Lower, and Proper Case – Case Fun... While working in VBA, you often need to convert strings into lowercase, uppercase or proper case. This is possible by using the , and func...

Return to VBA Code Examples Menu

vba ad vertical

Was this helpful?
You might like these related Code Examples...

Delete Rows that Meet Certain Criteria in VBA The following Subroutine will delete each row in a range where the value in Column A begins with a prescribed piece of text: For example ...

Commenting in VBA This article will teach you how to comment a single line or multiple blocks of code in the VBA Editor. To learn about how to interact with E...

Using Isnumeric and Isnumber in VBA This article will teach you how to use the and functions in VBA to check if values are numbers. IsNumeric is a built-in VBA function, w...

Isempty function in VBA In this article, you will learn how to use the function in VBA to check if a cell is empty. If you want to do the same in Excel, a similar ...

VBA Char / Chr Function Every character in Excel has an assigned number code to itself. The function in VBA returns a character for a given number (ASCII) code. In...

VBA Upper, Lower, and Proper Case – Case Fun... While working in VBA, you often need to convert strings into lowercase, uppercase or proper case. This is possible by using the , and func...

1 (312) 469-0172