Results 1 to 9 of 9

Importing selected cells into VBA

Threaded View

tryer Importing selected cells into... 10-12-2008, 05:00 PM
VBA Noob Do you mean a range of cells... 10-12-2008, 05:16 PM
tryer Yes, sorry if I didn't... 10-12-2008, 05:21 PM
VBA Noob See if this helps Dim c... 10-12-2008, 05:23 PM
tryer Thanks Noob that works a... 10-12-2008, 05:45 PM
VBA Noob Add c.Clear after NewSrt... 10-12-2008, 05:46 PM
  1. #1
    Valued Forum Contributor
    Join Date
    11-16-2004
    Location
    Devon UK
    MS-Off Ver
    2010
    Posts
    357

    Importing selected cells into VBA

    Can you help with how to import into vba just the data in the currently selected cells?

    What I want to do is to manually select a range of rows (in a single column) and upon running the macro put the data from each cell into the uppermost cell with each seperated with a comma.

    I can manage the combining of the data but don't now the selection is read into VBA
    Last edited by tryer; 10-13-2008 at 03:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. average of cells from user selected range of worksheets
    By ge0rge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2008, 07:34 AM
  2. bug: cells selected as mouse moves
    By urungus in forum Excel General
    Replies: 5
    Last Post: 08-28-2008, 09:39 PM
  3. Manual calculating selected cells only
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2008, 04:05 AM
  4. importing text but it spreads across cells
    By robin.a in forum Excel General
    Replies: 2
    Last Post: 10-15-2006, 12:36 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