Results 1 to 3 of 3

Thread: Creating Names for Cells Using Code (RESOLVED)

Threaded View

  1. Aug 30th, 2003, 02:49 PM #1
    Daniel McCool
    Daniel McCool is offline

    Thread Starter
    Lively Member Daniel McCool's Avatar
    Join Date
    Oct 2002
    Posts
    127

    Creating Names for Cells Using Code (RESOLVED)

    I am trying to create a loop that will pass through every cell in a column and define it a name based on the cell's value.
    VB Code:
    1. For X = start To finish

    2.             Sheets(2).Cells(X, 6).Name = Sheets(2).Cells(X, 6).Value

    3.     Next X
    I doesn't seem to like this. Any help? Thanks.
    Last edited by Daniel McCool; Aug 30th, 2003 at 11:15 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width