Search results

  1. chergh

    European Diaspora

    I just merely expressed my view that diaspora wasn't a cultural loss. Some may find my comment controversial or something but thats upto them. It would appear to you are the one ruining the thread with your stunningly inaccurate and fatuous analysis of my comments.
  2. chergh

    European Diaspora

    I don't care how people take it, that's upto them.
  3. chergh

    European Diaspora

    Which ever you prefer.
  4. chergh

    European Diaspora

    Hmm maybe we should look more closely at this so we can learn what happened and then use what we learn to get rid of the rest of the theists.
  5. chergh

    Cell formatting

    Search the forum this has been covered many times
  6. chergh

    Atheists and theists are the same.

    We have absolutley no idea of how an alien, godlike or not, would think etc. therefore any speculation about what they would or would not want is pointless.
  7. chergh

    formatting an excel document in access

    Yes. Goto excel record a macro of you doing it manually and then use the generated code in your code.
  8. chergh

    Customisng Ribbons? Personal.xlsx? 2007

    I haven't really used 2007 much so best I can do is point you at: http://www.rondebruin.nl/ribbon.htm Hope it helps
  9. chergh

    if statement for date

    Yeah it is something in sub you are calling that is changing the sheet Just add: sh.activate after the application.run
  10. chergh

    if statement for date

    Put the following in the ThisWorkbook object shown in the VBA Editor Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Sh.Name = "SheetName" And Target.Column = 3 Then Sh.Range("F" & Target.Row) = Date End Sub
  11. chergh

    Using Access to minipulate Excel then save and close workbook

    Try: ActiveWindow.Close false
  12. chergh

    No Americans

    I think Rabbie is right Rich, Great Britain is Scotland, England and Wales, Northern Ireland forms part of the united Kingdon.
  13. chergh

    Pick a cell in a named column

    Right idea but you can't used a named range in the way you are attempting to. Even though you have assinged a range name to the column that range doesn't return a column letter the way you want. There are two ways to approach this. The first is depending upon how comfortable you would be...
  14. chergh

    No Americans

    Re: Yes Americans Wow! you're an hero:rolleyes:
  15. chergh

    Child's toy gun sparks panic at a bank in England

    This is a bit of a non-story First it's the daily mail reporting so I expect sensationalism and disregard things like "panic stricken staff" as the daily mail is full of bullshit like this. Secondly the picutre is of a "similar" gun. In daily mail speak this probably means it's the first...
  16. chergh

    Apend Table "A" to Table "B"

    Cutting and pasting is what I would use. I only use ado in spreadsheets when I want to use SQL for data manipulation. Maintaining a spreadsheet to use ado also requires a bit of set up as when you add and remove data you need to keep the named ranges upto date.
  17. chergh

    No Americans

    Shit! I must have missed that part of the queen's speech. p.s. "your" should be "you're"
  18. chergh

    97 under Win7

    There should be have a look at http://www.sevenforums.com/tutorials/316-compatibility-mode.html
  19. chergh

    97 under Win7

    Is the issue that it won't install or won't work after installation? If it is the latter right click on the desktop icon and select properties and then under the compatibility tab try using one of the compatibility modes.
  20. chergh

    The new "spelling"

    Is english the first language of the poster?
Back
Top Bottom