Search results

Well if you're going to make uninformed assumptions about my motives you should expect to be wrong a lot.

Not sure I follow. My position is I am against moderators making up their own rules for their threads just because they can enforce it. Unless moderators are going to extend this right to all thread authors and make any edits requested by the thread author. As far as I am aware there are board...

There might be a blank string or something in one of the cells. try changin the line where contents are cleared to: summSheet.Range("A2:IV" & lastRow).ClearContents

I thought this was meant to be a community or something so why not use that as an analogy. In most communities it is not the diktat of community leaders that decides the rules but rather the consensus of the community which is then implemented by the community leaders.

Re: Not a good way to manage a site... Yep, looks like we are free to do as bob tells us in his threads.

Re: Not a good way to manage a site... It is rather dictatorial. Maybe we should just spam the thread in protest... or we could pray for bob to change his mind :p

You want to delete your own posts? surely you can do that already:confused:

You're just to uptight and precious about you're threads. Did you ever look into some yoga classes as I suggested to help you unwind a little?

Like this, the change is highlighted in blue. Sub blah() Dim ws As Worksheet Dim summSheet As Worksheet Dim lastRow As Long Set summSheet = ThisWorkbook.Worksheets("Sheet1") lastRow = summSheet.UsedRange.Rows(summSheet.UsedRange.Rows.Count).Row summSheet.Range("A2:CH" &...

Ah I stopped there when I drove Route 66 in 2007. Even by American standards the portion size seemed insane.

My favourite dining experience is undoubtedly The Fat Duck in Bray. It's an amazing experience and given it's nature not some where I would go more than once every five years or so. They only have a tasting menu and the meal lasts about 5 hours. For a good meal my favourite place is a gastropub...

Now something a little more helpful. Best way to solve issues with select statement is to not use them. Sub blah() Dim ws As Worksheet Dim summSheet As Worksheet Dim lastRow As Long Set summSheet = ThisWorkbook.Worksheets("Sheet1") lastRow =...

:eek:.........

Scientist have successfully created the first self-replicating, synthetic bacterial cell. http://www.zdnet.com/photos/scientists-build-first-synthetic-bacteria-photos/425927 I now admit intelligent design does exist thought it seems to be distinctly human and not divine.

I think you are getting confused as far as I know xslt is nothing to do with excel but is used to translate xml documents between different schemas.

Just trolling you ;)

Ahh you must be a bnp voter then

You don't know what trolling is? you must a christian or something

If you don't have it you really should it's an absolutley sublime puzzle game with a superb sense of humour.

Look up the "showmodal" property of the userform in help