Change the size of a range

[SBF12345]

I have a range defined by two variables. Both variables are located in a single column. I would like to select and copy the cells in the adjacent range. How can I expand the selection defined by the values in the first column to include the values in the second column.

I tried the code below but received an "application defined or object defined error" error.

ActiveWorkbook.Sheets("ActiveSheet").Range(RngStart, RngEnd2).Resize(0, 1).Copy

 

[footoo]

ActiveWorkbook.Sheets("ActiveSheet").Range(RngStart, RngEnd2).Resize(, 2).Copy

https://docs.microsoft.com/en-us/office/vba/api/excel.range.resize

 

[SBF12345]

That seems to be working...I am having another related issue come up. I am having my range variables with dates starting in February return the month of December. Its as if it is adding an additional "1" to the value in the cell use to set the range variable. Wha?

 

[footoo]

That seems to be working...I am having another related issue come up. I am having my range variables with dates starting in February return the month of December. Its as if it is adding an additional "1" to the value in the cell use to set the range variable. Wha?

Post your code.

 

[MARK858]

Question 3 has been asked in a new thread here