shortest

  1. M

    VBA copy format challenge!

    Hi, I am grabbing the .Value from a variable. How to copy formatting of cell above as well? Shortest code possible as I have many lines of code like this. wsSheet2.Cells(3,2).Value = TestSheet1 Thanks in advance.
  2. L

    Connectors

    Hi, I am trying to create elbow connectors between two images in the sheet, i prefer it connecting Bottom center of image 1 to Top center of image 2, so that i appears as a tree structure. when i write code it creates between right center of image 1 to left center of image 2, something like it...
  3. E

    Shortest distance between Lat/Longs with condition

    Hi all, This has been bothering me for the last few days. What I am looking to do is find the shortest distance in miles between two lat long points, (which I have figured out thanks to posts on this site). However, I also want to limit the result to just the nearest lat long point associated...
  4. A

    Cross reference data from 2 different sheets to fill 3rd sheet

    My sheet 1 (Raw Data) looks like this <colgroup><col><col><col></colgroup><tbody> Experience Height P1 Best Tallest P2 Worst Tallest P3 Worst Tall P4 Good Short P5 Bad Tall P6 Worse Short P7 Best Shorter P8 Bad Shortest P9 Worse Shorter P10 Worst Shortest </tbody> My...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top