So, one of my issues with vlookup is if you have a large range it's a pain to count columns for a very wide range quickly. I'm doing some VBA training and would like to create a user defined function to accomplish this.
So, I thought I'd create a function "CountColumns" that would be used like this =CountColumns(column 1, column 2) and it would return the distance between them.
So...
=CountColumns(A, D)
Would = 4.
In my function, here's what I had so far. Can anyone help? Still learning.
Please Login or Register to view this content.
Bookmarks