+ Reply to Thread
Results 1 to 4 of 4

Formula in vba to contain a range which is stored in a variable

  1. 05-23-2018, 01:51 PM #1
    h3llblax
    h3llblax is offline
    Registered User
    Join Date
    05-23-2018
    Location
    Mumbai
    MS-Off Ver
    2016
    Posts
    5

    Formula in vba to contain a range which is stored in a variable

    Currently working on a project in which I have a variable "SelRange" which contains a certain range of cells of the sheet. I want to enter a formula in a particular cell such that it sums this particular range which is stored in "SelRange" how can that be done?
    Reply With QuoteRegister To Reply
  2. 05-23-2018, 02:00 PM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Formula in vba to contain a range which is stored in a variable

    Does SelRange contain the values from the range or the address of the range?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 05-23-2018, 02:12 PM #3
    h3llblax
    h3llblax is offline
    Registered User
    Join Date
    05-23-2018
    Location
    Mumbai
    MS-Off Ver
    2016
    Posts
    5

    Re: Formula in vba to contain a range which is stored in a variable

    Address of the cells
    Reply With QuoteRegister To Reply
  4. 05-23-2018, 02:37 PM #4
    h3llblax
    h3llblax is offline
    Registered User
    Join Date
    05-23-2018
    Location
    Mumbai
    MS-Off Ver
    2016
    Posts
    5
    Quote Originally Posted by Norie View Post
    Does SelRange contain the values from the range or the address of the range?
    Address of the cells
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Handling Errors from Formula result, stored in a variable.
    By adibukovi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2018, 10:29 AM
  2. [SOLVED] Get Last column in range stored as variable
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2017, 03:00 AM
  3. [SOLVED] Formula using stored variable
    By fireflydreams in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2015, 10:36 AM
  4. Correct syntax to add a workbook name that is stored in a variable into a formula
    By lordterrin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-25-2014, 03:46 PM
  5. [SOLVED] Compare what cell is stored in a Range variable.
    By GaidenFocus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2012, 03:05 PM
  6. Range for Vlookup: refer to columns stored in a variable
    By stefy1984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-10-2012, 06:24 PM
  7. Help with a Formula to Print a stored variable
    By Modify_inc in forum Excel General
    Replies: 4
    Last Post: 12-16-2010, 09:59 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1