co-ordinates

  1. E

    Is it possible to identify a cell and use its co-ordinates?

    Hello Is it possible to have a formula that will check all the cells at left in the row, find the first cell that is not zero, and use its co-ordinates (eg A12) ? Thanks!
  2. E

    Need to calculate X and Y co-ordinates in show in a table

    Picture this - I want to be able to create a (...non-VBA solution would be preferred...) table of X- and Y-coordinates based on user input for up to a 5x5 grid. The user enters the number of rows (say 2) and then the spacing between each. They do the same thing for number of columns (say 3) with...
  3. A

    VBA Coding Query/ideas

    Hi all, I am writing some code to fix up some survey information. The type of data I receive has a x, y and z co-ordinates for the same points, lets say a shot at the ground line, a shot at the top of a structure and shots part way up the structure. The software that will be importing this...
  4. C

    Help with charts

    I want to use the charts to do the following: I have data where each data point has an "X" value, "Y" value (co-ordinates) and a "UR" value. These are in three columns, each data point is on a seperate row. Here is some dummy data (real data is a lot bigger): What I want to do is make a chart...
  5. C

    Lookup in 3D space but against ranges of values

    My problem relates to a computer model of a building. I have thousands of nodes output from the model each of which has stress values associated with it. Each nodes has an X, Y, Z value describing it's location in 3D space. The strength properties of the building are assigned in hundreds of...
  6. J

    Latitude And Longitude Of Active Cell

    Does anyone have a vba script to list the co-ordinates (latitude and longitude) of the activecell so that I can move the cursor to that position. I have the following script which lists the cursor position, but would like the cell position co-ordinates. Dim MyPointAPI As POINTAPI Private...

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