View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Reposting - Why would this not Clear Cells

If you are using Microsoft's unreliable web interface to the newsgroup and
it isn't letting you find your previous posts, then it would make sense for
you to access the newsgroup by a different route.

Google provides a searchable archive. you can see the group at
http://groups.google.co.uk/group/mic.../topics?lnk=sg

The groups can be accessed directly through NNTP, either through a server
provided by your ISP, or through Microsoft's at msnews.microsoft.com
news:microsoft.public.excel.misc will probably give you a wizard to connect
if you haven't already got newsgroups set up.
http://office.microsoft.com/en-us/he...873021033.aspx gives
information, as do the following:
http://j-walk.com/ss/help/newsgrp.htm
http://www.cpearson.com/excel/links.htm
http://www.mvps.org/dmcritchie/excel/xlnews.htm
and many others
--
David Biddulph

"Roger" wrote in message
...
Hi Dave,

Can I pester you to paste the information in this post. I honestly
cannot
find my first post and that's why I place it again.

I'm not sure it something loopy is going on with the Discussion Post area,
but I cannot find my first post. There seemed to be a lull in listings
after
someone pasted around 5PM Central and as far as I can see from my listing,
there is no first post for me - this is really weird.

I'd appreciate it if you could paste the responses again or anything else
would be a great help.

Thanks - Roger

"Dave Peterson" wrote:

You have a couple of replies to your first post.

Roger wrote:

Hello,

I?Tm looking to run this on the noted row after entries have been
made. Only
problem is ?" it doesn?Tt work.

Can you tell me what I?Tm doing wrong? I?Tm just trying to clear a
cell if it
has the value ?oNo? in the cell.

Thank you - Roger

Sub NoNo()
For Each c In Worksheets("Front Page").Range("F15:F60").Cells
If c.Value =?No" Then c.Selection.ClearContents = True
Next
End sub


--

Dave Peterson