+ Reply to Thread
Results 1 to 6 of 6

Data not starting from specific row

  1. #1
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    Data not starting from specific row

    hi,
    Code below starts putting data at row A23 but not A20. Should start at A20. Can someone please help. Thanks



    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Data not starting from specific row

    Obviously value of A is 3 in the beginning, not 0 as you expect
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    Re: Data not starting from specific row

    Quote Originally Posted by buran View Post
    Obviously value of A is 3 in the beginning, not 0 as you expect
    sorry im not quite following you

  4. #4
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Data not starting from specific row

    Please Login or Register  to view this content.
    will refer to cell A20 only if A is 0.
    If it starts to put values from A23, it means A is 3 (i.e. A23 is 3 rows offset form A20)
    from your code it's not possible to say how/when value of A become 3

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Data not starting from specific row

    Do you mean like this?

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Data not starting from specific row

    Quote Originally Posted by AB33 View Post
    Do you mean like this?
    Given the fact that we don't see full sub code I would not start playing around with value of A just before the loop. You don't know if and how it will affect rest of the code.
    I would assume A is used before that piece of code, otherwise if it is integer/long it's default value, without initialization would be 0 anyway.

+ 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] paste data on the clipboard starting at a specific cell
    By djarum11 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-17-2015, 12:34 PM
  2. Replies: 0
    Last Post: 03-29-2015, 08:11 PM
  3. Enter Data from userform into cells starting from specific cell
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2014, 04:26 PM
  4. insert data in next blank row - starting from a specific row
    By Tomtril in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2013, 07:57 AM
  5. [SOLVED] Copy Data to New Sheet, Starting in a Specific Row
    By RTOMikey in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-23-2013, 09:35 PM
  6. import data from txt to excel starting from a specific date to other date
    By dvb_24 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-22-2011, 02:35 PM
  7. Starting excel with specific templates
    By stammerman in forum Excel General
    Replies: 2
    Last Post: 07-05-2006, 05:25 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