+ Reply to Thread
Results 1 to 5 of 5

Deleting cell no value by clear Content

  1. #1
    Forum Contributor
    Join Date
    09-22-2007
    Posts
    119

    Deleting cell no value by clear Content

    Hi, let some one help me the macro code for deleting the area
    that it found blank cells in the row of column B & column C & column D
    my excel file data begin in column A -column G at row4-row 125
    (or may be more than 125 )
    In column A is the date value, that will change as any another date.
    so, in the example ,the area of A84-G125 will Clear Content.(please, not delete rows)
    After Deleting my data will remain A4:G83
    thank.
    Attached Files Attached Files
    Last edited by pichai; 08-24-2008 at 03:49 AM.

  2. #2
    Forum Contributor SOS's Avatar
    Join Date
    01-26-2004
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    327
    Hi pichai,

    Try this code

    Please Login or Register  to view this content.
    Post back if you need any more nelp
    Hope this helps

    Seamus

  3. #3
    Forum Contributor
    Join Date
    09-22-2007
    Posts
    119
    Hi, Thank your code is best.

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    This is a bit shorter

    Please Login or Register  to view this content.
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Maybe

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem editing cell content
    By speakers_86 in forum Excel General
    Replies: 4
    Last Post: 10-03-2007, 05:00 AM
  2. read cell content and use with Hyperlinks.Add Cell
    By apoc [t.i.m.] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2007, 10:02 AM
  3. using cell content to reference a worksheet tab name in second workbook
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2007, 09:32 AM
  4. put cell content into formula
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2007, 05:29 AM
  5. Cell content to open another file on server
    By Damianoneill in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-06-2006, 09:41 AM

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