+ Reply to Thread
Results 1 to 3 of 3

Fill down a column for as many cells having data in column A

  1. #1
    Registered User
    Join Date
    04-20-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    96

    Fill down a column for as many cells having data in column A

    Hi all,

    I need help to figure out what's wrong with the code below. I'm trying to fill cells down starting with C2, with the first 2 letters of the book's name, for as many rows having data in column A. However, when trying to run the code, I get an error message, saying "Compile error: Invalid or unqualified reference".

    I'm not knowledgeable enough to figure out what needs to be changed or if there's a better approach to the task at hand.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Fill down a column for as many cells having data in column A


    Hi !

    Very difficult with a partial code ‼ Just try to remove the single dot before Cells and Rows

  3. #3
    Registered User
    Join Date
    04-20-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: Fill down a column for as many cells having data in column A

    Hi Marc,

    Thanks! I did what you said, but still get the same message. I put the above code as all what the macro does for testing purposes, and that's what I get. I had tried to code below to fill a single cell, and it works like a charm, so I tried to adjust it to fill down the series, but no luck so far.

    So, this code below works, and fills out a single cell, C2 in this case, the challenge is to make the code fill down the cells with the same content (the first 2 letters of the book's name)

    Please Login or Register  to view this content.

+ 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. If cell in Column G = X then fill 123 in Column H (and skip already filled cells)
    By MP1286 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2016, 01:14 PM
  2. Replies: 13
    Last Post: 07-06-2016, 02:59 AM
  3. If any cell in column contains value then fill blank cells in column with !
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2016, 02:14 PM
  4. Fill Array with data in visible cells in column
    By jeroenv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2014, 08:30 AM
  5. Fill cells in one column based on specific words or letter from another column
    By dokkadokka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2013, 07:04 AM
  6. Insert column and fill column upto where data is in previous column
    By aka189 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2012, 06:07 AM
  7. Replies: 4
    Last Post: 03-03-2005, 09:06 PM

Tags for this Thread

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