Results 1 to 4 of 4

macro :Cant find project or library

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2011
    Location
    nottingham
    MS-Off Ver
    Excel 2003
    Posts
    10

    macro :Cant find project or library

    I am trying to run this macro in Excel 2007 and it stops at the Chr$ This works in excel 2010 but I need to get it to work in 2007 version

    can anyone point me in the right direction?

    Sub Macro1()
      Dim OneCell As Range
        For Each OneCell In Range(Range("B1"), Range("B" & Rows.Count).End(xlUp))
           If Not IsEmpty(OneCell) Then
              OneCell.Offset(0, 1).Font.Name = "Wingdings"
              OneCell.Offset(0, 1).Value = Chr$(252)
           End If
        Next OneCell
    End Sub
    Kindest regards Alex
    Last edited by kamikizzy; 05-30-2011 at 03:01 PM.

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