+ Reply to Thread
Results 1 to 2 of 2

Code to run if cell not blank

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    Code to run if cell not blank

    Range("D10000").Select
                    Range(Selection, Selection.End(xlDown)).Select
                    Application.CutCopyMode = False
                    Selection.Copy
                    Range("A10030").Select
                    ActiveSheet.Paste
    I want the above code only to run if D10001 is not blank ,,, can anyone help?

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by khalid79m
    Range("D10000").Select
                    Range(Selection, Selection.End(xlDown)).Select
                    Application.CutCopyMode = False
                    Selection.Copy
                    Range("A10030").Select
                    ActiveSheet.Paste
    I want the above code only to run if D10001 is not blank ,,, can anyone help?
    Please read forum rules and put this question in Excel Programming forum.

+ Reply to Thread

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