+ Reply to Thread
Results 1 to 2 of 2

Selecting random cells and exporting contents to text file

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2013
    Posts
    1

    Selecting random cells and exporting contents to text file

    I am in need of assistance on a way to select certain cells in a sheet and export them to a TXT file. I can do it if they are all in the same row or column, but nothing I've tried works for say A1, B2, C3 and D5. Any thoughts?

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Selecting random cells and exporting contents to text file

    Try this ...

    =INDIRECT(INDEX({"A1","B2","C3","D5"},RANDBETWEEN(1,4)))

+ 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. [SOLVED] Macro to create text file and write contents of selected cells to the file
    By m@cro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 10:21 AM
  2. Consider blank cells as delimiter when exporting excel sheet to text file
    By Martijn79 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2013, 07:04 AM
  3. Replies: 3
    Last Post: 12-12-2012, 04:01 PM
  4. Replies: 2
    Last Post: 03-12-2009, 04:23 PM
  5. Exporting cells to text file
    By lefpe in forum Excel General
    Replies: 2
    Last Post: 09-18-2006, 06:27 AM
  6. Replies: 0
    Last Post: 01-18-2006, 04:01 PM
  7. [SOLVED] Exporting folder contents to excel or text format
    By Sr. Bio in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 02:55 PM

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