Search results

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

Take a look at: http://www.access-programmers.co.uk/forums/showthread.php?t=99353

Is the control in a subform? If so I think this is a known bug, but there is a fix http://support.microsoft.com/kb/977033

I don't use 2007 but this seems like it should work: Sub mcrRemoveDuplicates() ActiveSheet.Range("C1").currentregion.RemoveDuplicates Columns:=6, Header:=xlYes end sub

Copying data backwards and forwards between hidden sheets is not a good solution IMO. If your users commonly sort sheets in a particular ways then you could create macros to sort the sheets automatically and then your users just need to click one button to get the layout they want.