How to calculate distances between two cells in VBA?

Hi all! I have been working with you the last weeks because I have been consulting the forum a lot. Thanks a lot for spreading the knowledge.

I need your help because I couldn't find anything like this. I am not consider myself a developer really, I just know how to copy and paste and change little things. That's maybe why I can't find anything else in Google.

I need basically to do two things with the same logic of counting cells between two references

I want to print this count in the fourth column automatically
=COLUMNS(INDIRECT(C2))-COLUMNS(INDIRECT(B2))
in this way in VBA

Please Login or Register  to view this content.

I don't want to print the formula directly in the cell, only the result.

And for a loop that I need to build to repeat the printing in cells according to the amount of rows set in two variables... how do I calculate (instead of the distance between columns) the distance between rows.
Range1 and Range2 are Range type and I get them from text in certain cells. What I want to do is to copy Range(Range1 & ":" & Range2) and paste it on the last row from column B of Destiny sheet and for the same amount of rows in column A to paste the Table name I get from Source and I also need to paste in "LoadTable".

Please Login or Register  to view this content.

The final result is a table in Destiny sheet made of tables of the sizes given by Range1:Range2 that are extracted from different Sources sheets. In the Destiny sheet the first column has to be named automatically with the Table name of origin and the tables pasted from column B.

Hope make sense my doubt. Many thanks in advance.
Gerónimo

If you need the whole program for more info, it's here...

Please Login or Register  to view this content.