View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default VBA to find difference in cell locations

Is it possible to find the difference between cell locations. Such as if I
am on cell E1 and pick another cell H1, I would like to know the difference
between the locations. In this case there are 2 cells between E1 and H1.

I am writting a code that needs to know the difference between the cell
location, I just don't know what the VBA looks like for something like this.

Thanks