CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Threaded View

  1. #1
    Join Date
    Feb 2004
    Posts
    218

    help with excel macro

    Code:
    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Dim x
    For x = 1 To 1000
    If Cells(1, 1) <> "" Then
    Cells(2, 1) = "hi"
    End If
    If Cells(2, 2) <> "" Then
    Cells(3, 2) = "hello"
    End If
    End Sub
    When I run this code, the cpu become busy, what happen? thank you.
    Last edited by lwong; April 20th, 2006 at 11:55 PM.

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured