Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by shetlandbob

  1. shetlandbob

    Merging Excel

    dont know how to auto do it without VBA - some of the other folk here might? In VBA you could insert a new column between A and B and then loop through your data using the following code: ActiveCell.FormulaR1C1 = ActiveCell.Offset(0, 1) & Chr(10) & ActiveCell.Offset(0, 2) %etc....... (for all...
  2. shetlandbob

    CTRL + C do not work

    does the same happen if you use the menu (file-edit-...) to copy and paste? What happens if you try to paste in a new (word) document, or a different application, other MS application? This may appear irrelevant to you, but this information can help to narrow down where the problem is Robert...
  3. shetlandbob

    Getting the boot drive letter with VBA

    You can also get Special Folders directly, e.g. Sub GetSpecialFolder() Set wShell = CreateObject("WScript.Shell") SpecialFolderPath = wShell.SpecialFolders(5) Set wShell = Nothing End Sub Robert Cumming www.consultantengineer.co.uk
  4. shetlandbob

    CTRL + C do not work

    it could also be that a shortcut key (to the omega sign) has been assigned to the ctrl-v. But as xlbo has stated more informationis required to give a definitive answer Robert Cumming www.consultantengineer.co.uk
  5. shetlandbob

    Grey part of plot area

    Neither fo I! I guess you would need to have dynamically changing plot areas then? Can you create your graph in the format you want? Robert Cumming www.consultantengineer.co.uk
  6. shetlandbob

    Grey part of plot area

    do you know how to manually change the color of the sections? If so do it and record your actions into a macro. Move this code into the OpenWorkbook event, and set an if statement on the date in the graph with the date on your computer. Your code will have to assume certain columns represent...
  7. shetlandbob

    combining collections

    get a bigger tin, pour one into the other! Ok, sarcasim over - more info needed Robert Cumming www.consultantengineer.co.uk
  8. shetlandbob

    Change Event needed

    Hit alt f11 to get to VBA mode, under microsoft excel objects select the sheet you data is on. Then rather than general select worksheet from the drop down list (this is macros associated with this sheet only). in the second drop down list select Change - this will create a sub routine that is...
  9. shetlandbob

    Clear Cells in VB

    use Worksheet_Change instead Robert Cumming www.consultantengineer.co.uk
  10. shetlandbob

    Prompt user to find file & return path as text????

    do I detech an echo coming on..... FAQ Robert Cumming www.consultantengineer.co.uk
  11. shetlandbob

    excel formula - round problem

    well that clears it up then! Robert Cumming www.consultantengineer.co.uk
  12. shetlandbob

    excel formula - round problem

    what are you actually trying to do? Break the formula up into smaller segments and try to debug where it is going wrong Robert Cumming www.consultantengineer.co.uk
  13. shetlandbob

    excel formula - round problem

    round(K$28,4) Since you are formatting in percentage you need to take this into account a value of 0.52% is a number to 4 decimal places so therefore you get: 0.52% round(value,2)= 1.00% 0.52% round(value,3)= 0.50% 0.52% round(value,4)= 0.52% Robert Cumming www.consultantengineer.co.uk
  14. shetlandbob

    Prompt user to find file & return path as text????

    There are many posts on this so search, or have a look in the FAQ, clue in the "VBA How To" section Robert Cumming www.consultantengineer.co.uk
  15. shetlandbob

    copying a chart in Excel

    edit links would be if the source data is in a different workbook. I was under the impression it was the same workbook - different sheets? Robert Cumming www.consultantengineer.co.uk

Part and Inventory Search

Back
Top