I want to locate a cell. We can use cells(1, "i"). "I" column means the "type" which is the head(first cell content) of the column. Is there a way to use the name "type" instead of "I"? For the reason that the column of I may change, For example after some modification the I column may change to save the name of the company not type.I want the vba script to be more flexible. Can it be made?
Bookmarks