Results 1 to 9 of 9

Loops with numbers and text

Threaded View

v2jtb Loops with numbers and text 02-01-2010, 07:38 AM
D_Rennie Re: Loops with numbers and... 02-01-2010, 07:57 AM
DonkeyOte Re: Loops with numbers and... 02-01-2010, 08:05 AM
D_Rennie Re: Loops with numbers and... 02-01-2010, 09:14 AM
v2jtb Re: Loops with numbers and... 02-01-2010, 12:48 PM
v2jtb Re: Loops with numbers and... 02-01-2010, 01:01 PM
v2jtb Re: Loops with numbers and... 02-01-2010, 01:03 PM
v2jtb Re: Loops with numbers and... 02-01-2010, 01:12 PM
D_Rennie Re: Loops with numbers and... 02-02-2010, 08:56 AM
  1. #1
    Registered User
    Join Date
    01-29-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    94

    Loops with numbers and text

    Hi All,

    I am new to this and trying to understand loops and arrays

    I have my first loop that adds 1 to 10 on column A1 and works.....

    I can move the colum with second 1 to say C1 etc but I don't know how to move the start to say A12?

    Also I want to add text say "test" so the loop would add 1 test, 2 test etc, can this be done? I knoiw this is a simple loop but I need to get my head around the programming.

    Sub first()
        For i = 1 To 10
            Cells(i, 1) = i
        Next i
    End Sub
    Last edited by DonkeyOte; 02-01-2010 at 08:03 AM. Reason: CODE tags at all times please

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