+ Reply to Thread
Results 1 to 3 of 3

A macro that reads number in a cell and uses it....?

  1. #1
    Registered User
    Join Date
    10-07-2008
    Location
    Australia
    Posts
    2

    A macro that reads number in a cell and uses it....?

    Can anyone tell me how i go about making a macro that can read a number in a cell and then inserts that many number of rows. What I am trying to do is an engineering application in soils. I want to put in how many sub layers of the soil there is, and then use the macro to create that many lists of soil descriptors. So if i put in 3 as amount of sub layers, then 3 separate lists will appear. Any help will be much appreciated. Thanks.

  2. #2
    Registered User
    Join Date
    10-06-2008
    Location
    China
    Posts
    7
    you can making a macro like this
    Please Login or Register  to view this content.
    Last edited by eagleyzw; 10-07-2008 at 02:49 AM. Reason: not use the code tag

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Place the number of Rows in A1, then select the cell where you want to insert the rows.

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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