Hi folks,
to set the current region as column A (1,1) works

But I need Column D Cell 2 ie D2


Set otest = ActiveSheet.Cells(2, 4).CurrentRegion

Also what about the next column ie E2 in relation to this current region

is this correct?

sl