address reference

  1. S

    Spltting address with a formila

    Hi, I need to split some addresses with formulas and am not sure the right way of going about doing it. I currently have two workbooks. One called Raw Data which has a series of columns and the other called master which looks up the raw tab. On the raw tab there are 6 columns that are like...
  2. R

    VBA Data Validation List and Address

    The code below is used to go through a range of values looking for the first cell that is < 0. It then inputs a Data Validation list, Lengths_7000. The cell is given a default value, but I want to capture the address of where the validation list was entered to be used in the code later. Any...
  3. K

    Compare 2 columns of data and find the address of cells that are not in both columns

    Hello, I am trying to compare 2 lists of data, column a (current data) and column b (new data), and find the address of the cells that are in column b and not column a. The data in column a is constant and the data in column b is updated regularly. Example: What formula would I use to find the...
  4. S

    Non-absolute verson of Range.Address

    Is there a non-absolute version of Range.Address? I have a VBA code that builds the outline of a spread-sheet with formula's, formatting etc. It contains a loop which puts formula into a column but I would like the formula to use relative addresses so that later on I could extend the number of...
  5. B

    Analyzing dynamic data

    Hi all, I would like to automate the analysis of data that I pull from a database via automated SQL query. Some of the problems I've run into are: data array is not always the same size. It always contains the same number of columns but the rows will vary some. So, first off, I need a way to...
  6. S

    Count, Cell Address or Numbers Directly (Data Analysis)

    I have a workbook with species data, such as: **** sapiens, and the sites where data were taken (13). There are multiple rows of species just as there multiple columns of sites. How can I write a function to properly list the number of species at each site, by name? If there is no way to do...
  7. H

    VBA extract column/ row value from address string

    Hi Folks I am trying to work out how to get column/ row values from an address string. the relevant code I am using is:- DivCell = Cells(DivRow, DivCol).Address EndCell = Cells(ExpRow, ColMax).Address If Not Intersect(Target, Range(DivCell, EndCell)) Is Nothing Then...
  8. A

    Using Address References in Another Function

    I am trying to use the references from an address function in another function. Specifically, I would like to use cells F10 and F11 that show the text $C$1 and $C$5 respectively, in the function min($C$1:$C$2). Anyone know how I can do that? Thanks!

Watch MrExcel Video

This Week's Hot Topics

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
Top