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...
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.