+ Reply to Thread
Results 1 to 1 of 1

VBA to repeat the process of calculation

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    VBA to repeat the process of calculation

    I am new to VBA. I want to calculate distance between 2 latitude longitude data. I know the formula to calculate. But I want VBA to repeat process.

    Column A has latitude and Column B has longitude.
    The column Header has Latitude and Longitude (A1B1)
    The data starts from A2B2 till bottom.
    In Cell C2D2 the data from A3B3 should be pasted.
    Again, in the same way, data from A4B4 should be pasted to C2D2 only.

    I want code to do the above operation.

    thanks in advance,
    Last edited by vanitarathod; 06-26-2014 at 08:21 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help with my distance formula using latitude & longitude.
    By odimas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-24-2014, 11:53 PM
  2. Distance between latitude and longitude
    By fazna ali in forum Excel General
    Replies: 2
    Last Post: 11-06-2012, 05:03 AM
  3. Calculate distance of latitude/longitude points
    By sanlen in forum Excel General
    Replies: 5
    Last Post: 12-08-2010, 01:03 AM
  4. Latitude and Longitude: Minimize distance
    By gcool12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2010, 06:18 PM
  5. Can distance be calculated using latitude and longitude?
    By Paxton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-02-2005, 10:06 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1