range address

  1. G

    Setting a range equal to a group of variables

    Not sure where my syntax is wrong here. I've been trying to concat a few variables into a range based off the location in a shared folder for my coworkers to use when updating a sheet. Hopefully someone can point me in the right direction. When I've checked each variable by using msgbox within...
  2. G

    Naming a range from another workbook

    Having some difficulty naming the ranges in my code. Ultimately trying to run a Vlookup but I've tried breaking up the pieces of the range location to help simplify and find the error in my range value. Function ann_calc(acct As String, func As Long, term As Variant) Dim driveloc As String...
  3. T

    Allow volatile expression in VBA function

    Hello, I have a formula that checks the bgcolor of a reference cell (rColor), then selects all cells in the defined range (rMatrix) with corresponding color in order to calculate the sum or count the number of cells. Problem is that I want to enter a specific formula that determines the needed...
    • TLO2015
    • Thread
    • formula and vba range address vba volatile code
    • Replies: 2
    • Forum: Excel Questions
  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...
    • Shads
    • Thread
    • address property address reference range range address relative address vba
    • Replies: 3
    • Forum: Excel Questions

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