I have a range resize issue. Something happens with the elements lying in E5 : K5. After that something happens, I need to resize the horizontal range to include D5.
So myRange before was was E5:K5
But after the resize, it becomes D5:K5
How can this be done in VBA?