+ Reply to Thread
Results 1 to 6 of 6

check if sheet empty then paste value

  1. #1
    Registered User
    Join Date
    02-23-2010
    Location
    asd
    MS-Off Ver
    Excel 2003
    Posts
    27

    check if sheet empty then paste value

    hi expert,
    need ur help.... i would like to write code that will:
    1) active sheets--> is range a1 empty?
    2) range a1 = empty --> then paste value
    3) if range a1 <> empty --> open next worksheet
    4) is new sheet range a1 = empty--> then paste value

    this will loop until i have nothing to paste..
    please help....

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: check if sheet empty then paste value

    One quick question. Were are you copying from? Or is this something that is going to be stored on the clip board.

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: check if sheet empty then paste value

    Try:

    Please Login or Register  to view this content.
    Edit the copy line to match whatever you require

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: check if sheet empty then paste value

    Probably a more crisper way:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-23-2010
    Location
    asd
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: check if sheet empty then paste value

    hi stnkynts..!!!
    thanks a lot...!!! it help...!!!!!

  6. #6
    Registered User
    Join Date
    02-23-2010
    Location
    asd
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: check if sheet empty then paste value

    hi,
    i found out that i was looking for others logic which is ;
    1) if active sheet range A1 <>"" then will select next sheet and activate it and end
    2) if select next cell is error, which mean do not have next cell, it will add a new sheet and activate it....



    Please Login or Register  to view this content.

    i found above code will add new sheet then look range a1 is empty or not.

+ 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