Hello All,
I just started working and I have been given an assignment to create a Macros tool in which the user will be provided with a user form to input data. The data (which are UTM coordinates) will then be added to a list on one tab in an excel worksheet. On another tab, there is a matrix that has the distance between each site. This distance is calculated using a formula which has already been created. Each time new site data is added, a row and column will be added to the matrix database. I am having trouble writing the correct code which will drag down the formula across the last row of data to find the distances between each site. Here's what I have so far which actually goes about it a slightly different way. A loop is formed to count how many rows of data there are, then at the last row, the formula from above is dragged down. Any help willbe VERY much appreciated.
Moderator Note:Please Login or Register to view this content.
Pls use code tags around your code next time as per forum rules.
Bookmarks