In looping, I had located data in some column e.g. range("aa" & row), range("ab" & row-1). now I want to insert a new column before column AA on spreadsheet and hope original data will be relocated automatically i.e. range("ab" & row), range("ac" & row-1) without re-edit the code. How to do it? thanks.
Bookmarks