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!

Register Log in
  • 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!

Search results for query: *

  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
  16. shetlandbob

    copying a chart in Excel

    change the source of the chart. Right click - goto source data and manually change the sheet name that the source data refers to. If the format of the sheets is the same then this should work. Its tedios - but..... Or You could be clever and record a macro that does it and set the sheet...
  17. shetlandbob

    Data Validation

    well you learn something new everyday - and probably promptly forget again! ;) Robert Cumming www.consultantengineer.co.uk
  18. shetlandbob

    Data Validation

    If column B is fixed format/szie you could do it with if statements, however it would be messy and I imagine that it is not? Therefore if column B is dynamic then I think youd proabbly need to use vba to search through a column b and react accordingly. Robert Cumming...
  19. shetlandbob

    Prompting user to provide file name and path

    ...ways, the best is to preset the extension when you call the save dialog Dim filter As String Sheets("Sheet4").Copy filter = "Excel Files (*.xls),*.xls," myfile = Application.GetSaveAsFilename("mMyInitialName", Filter) ActiveWorkbook.SaveAs Filename:=myfile, _...
  20. shetlandbob

    auto plot distribution of data

    Hi, I have the following type of data set: 0.94 0.94 0.94 0.94 0.92 0.94 0.94 0.24 0.66 0.86 0.24 0.94 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.94 0.94 0.94 0.94 0.92 0.94 0.94 0.94 0.66 0.22 0.96 0.94 0.94 0.96 0.96 0.96 And I want to easily generate a plot that will summarise the...

Part and Inventory Search

Back
Top