Results 1 to 3 of 3

To start macro in row 8, what would I change

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    To start macro in row 8, what would I change

    This adds a period to the left and the right of each row of numbers in column A.
    Got it from someone on the board, but have not figured out what to change if data does not start in row 1
    To start macro in row 8, what would I change?
    Sub test
    Dim LR&, r&
    LR = Range("A" & rows.count).end(xlup).row
    For r = 1 to LR: Cells(r, 1) = "." & Cells(r, 1).value & ".": Next
    End sub
    Last edited by vlady; 11-07-2012 at 02:38 AM. Reason: put code tags on your codes. thanks

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