Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

you can do this a number of 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...

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