Function - Count User Defined Columns in a Range

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.

I could, but I thought this would be a cool way to help me learn vba and create a useful function.

Any ideas?