+ Reply to Thread
Results 1 to 2 of 2

AutoFill cells with the same value

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    AutoFill cells with the same value

    Hi,

    It's been a while since I've used VBA so I'm kind of stuck on this one.
    I have a worksheet with 65 cells per page (5 columns, 13 rows).
    And I have a userform, where I want to insert like number 28, and It would fill 28 cells on this page with the value from the userform.
    What I'm doing is this:
    Please Login or Register  to view this content.
    And I don't know how to make excel calculate how many rows does it have to copy the same value in to get for exaple 28 cells with the same value.
    It starts with A1 and goes to E1, then is should move down to the next row and go from A2 and so on.
    Hope someone understands what I'm trying to do?

    Thank you!

  2. #2
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: AutoFill cells with the same value

    Can someone please delete this tread?
    I just found out that what I'm doing will have no use
    Sorry

+ 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. Replies: 4
    Last Post: 01-12-2015, 11:41 AM
  2. Autofill A range of cells in VBA
    By Archangel30IL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2014, 11:48 AM
  3. autofill new cells
    By vchen001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2012, 02:40 PM
  4. Autofill cells with date
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 09:39 AM
  5. Autofill cells from a formula
    By SoCalHeat in forum Excel General
    Replies: 3
    Last Post: 04-25-2008, 12:07 AM
  6. can autofill be used on merged cells?
    By Debbie in forum Excel General
    Replies: 2
    Last Post: 06-27-2006, 09:40 AM
  7. Replies: 1
    Last Post: 06-17-2005, 04:05 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