Converting Excel column number to letter and letter to column number is actually something that every VBA developer does at least once a day. The easiest way is probably to use the property
.Column or
.Address of the range object that…
Everyone knows the feeling that they need to use the
=Index(Match(),Match()) formula in Excel and something tiny was not enough to reach their goal. Some time ago I knew that something is missing I was trying to “filter” with the…
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkCookie policy