VBA Code to extract specific column range from broader range

[frenchmaninsd]

Hi,

From a RefEdit on a UserForm, I get a range containing multiple columns, let's say Sheet1!$B$4:$E$13. Another value tells me which column I need to focus on. So if the value is 2, that means the second column in my range (Column C). I'd like to get the code that will return Sheet1!$C$4:$C$13.

Thanks in advance!

 

[Eric W]

Welcome to the Board!

Try:

Set NewRange = WorksheetFunction.Index(MyRange, 0, 2)

where MyRange is Sheet1!$B$4:$E$13, and the 2 is the column you want.