VBA : Set Range from Cell Function

user_8287922 0
Viewed 5845

I am trying to use Excel VBA to create a Range variable that is one column to the right of sourcerange.

Dim targetRange as Range
Dim sourcerange as range

Set sourceRange = range("B1:B2") 'Works

Set targetRange = Range(cells(sourceRange.row, sourceRange.Column + 1)) 'does not work

Set targetRange = Range(Cells(2, 2)) 'does not work

Can anyone help explain why it is not working?

vba excel
2 Answers
Related