+ Reply to Thread
Results 1 to 3 of 3

how can I take the value of several selected cells and process them in a loop ?

  1. #1
    Valued Forum Contributor
    Join Date
    02-21-2010
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    502

    how can I take the value of several selected cells and process them in a loop ?

    I am trying to take the value of several selected cells (e.g. A1:A4 or A1, A6, B5) and then process each value one by one in a loop. So, there are two step. One, to get the values. And two, to process the values in a loop. I don't know how to get the value of several selected cells and I don't know how to process these values in a loop.

    With a single selected cell it is easy. See script below:

    Please Login or Register  to view this content.
    But I can't do the same with several selected cells. I tried the following. See below. This script doesn't work, but it illustrates the line I am thinking along. Perhaps from that attempt you can understand what I am trying to do.

    Please Login or Register  to view this content.
    I became pretty good at working cell by cell but I have a long way to go to comfortably work with ranges.
    I would greatly appreciate if somebody could help me out on this one.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: how can I take the value of several selected cells and process them in a loop ?

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor
    Join Date
    02-21-2010
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    502

    Re: how can I take the value of several selected cells and process them in a loop ?

    man, how simple. Thanks a lot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Loop backwards through selected range - delete entire row from selected cells
    By scottbass in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2014, 09:21 AM
  2. Spawn a child process? to run the loop, then move on
    By GoonerJed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2013, 08:41 AM
  3. Macro to Loop Function throughout selected cells
    By Alvinz in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-20-2012, 08:57 AM
  4. How to process selected rows
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2005, 07:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1