+ Reply to Thread
Results 1 to 2 of 2

Apply formula to selected cell range

  1. 05-06-2015, 04:48 AM #1
    cmb80
    cmb80 is offline
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Apply formula to selected cell range

    Hi all, I want to apply the below formula to any given selected range of cells using a macro.

    Can someone advise what change(s) I need to make to the code for this to work

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 05-06-2015, 04:53 AM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Apply formula to selected cell range

    If the cells are already selected, you can use

    Please Login or Register  to view this content.
    Otherwise, if you have a range specified in a range variable called, say, "rng", use

    Please Login or Register  to view this content.
    cheers, teylyn
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    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. apply formula to each cell in range - relative references
    By BuZZarD73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2014, 11:45 AM
  2. VBA macro to apply formula for selected cells and enter result below selection
    By Petrachabrova in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2014, 07:39 AM
  3. [SOLVED] VBA Apply Formula to All Cells In Range
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-20-2014, 09:25 AM
  4. How to loop through cells in a range and then apply a formula to an offset to that range.
    By AndrewMac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2013, 03:00 PM
  5. apply formula to selected cells via macro
    By Axe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2009, 11:19 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