+ Reply to Thread
Results 1 to 3 of 3

copy entire excell sheet cells values into string array

  1. 03-03-2014, 02:50 AM #1
    laltoo2405
    laltoo2405 is offline
    Registered User
    Join Date
    02-27-2014
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    6

    Lightbulb copy entire excell sheet cells values into string array

    Can anyone tell me how to copy the content of cells from an excell->sheet1 to an string array
    Reply With QuoteRegister To Reply
  2. 03-03-2014, 02:01 PM #2
    Alf
    Alf is offline
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: copy entire excell sheet cells values into string array

    Perhaps this link could be of help?

    http://blog.contextures.com/archives...ia-in-a-range/

    Alf
    Reply With QuoteRegister To Reply
  3. 03-03-2014, 09:17 PM #3
    mc84excel
    mc84excel is offline
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: copy entire excell sheet cells values into string array

    Quote Originally Posted by laltoo2405 View Post
    Can anyone tell me how to copy the content of cells from an excell->sheet1 to an string array
    Will Variant Array do? (Code below assumes Sheet1 is the ActiveSheet)
    Please Login or Register  to view this content.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************
    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. Search string in a column then copy entire rows to another sheet
    By vannylette in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2013, 12:16 PM
  2. [SOLVED] Copy the entire row from one sheet to another if column A contains string B
    By roman87 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 10-17-2013, 09:09 AM
  3. Multiple loops based on non-zero values and copy entire row to new sheet
    By nadiar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2013, 01:46 PM
  4. [SOLVED] Copy entire row from one sheet to another if cells in column A are equal
    By Scal in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2013, 12:27 PM
  5. search for a string in an entire column and copy a range of cells from corresponding row
    By behnam2016 in forum Excel General
    Replies: 7
    Last Post: 01-09-2013, 02:28 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1