Search results for query: *

Thanks very much to both. I really appreciated your help ans solved my problems. Fernando

I have a workbook with few sheets and macros developing some results and charts. I have to copy all the results and charts to another sheets with just values (no formulas). I'm able to copy and paste special through VBA all the Calculation sheets but copying and pasting the chart it will...

I have few macros developing and genarting worksheets and charts. Is there a way to saveas the xls to a new xls file with just data and not macros in the way that the user will just be able to see the results and not formulas and macros who produced it?? Right now I just think I can do this...

I got it!! I just solved my problem. I have two sheets sheet1 with input data and sheet 2 where I want to put the results. this is what I wanted to do and how I wrote it For i = 1 To Sheet1.UsedRange.Columns.Count / 2 Sheet2.Cells(2, i + 1).Formula = _ "=Average('Sheet1'!R1C" &...

Yes I need something like that, but I have to loop so How to do that? In the sense that I'm trying to do something like this For i = 1 To Sheet1.UsedRange.Columns.Count / 2 Sheet2.Cells(2, i + 1).FormulaR1C1 = "=AVERAGE(Sheet1!R[2]C[i+1]:R[Sheet1.UsedRange.Rows.Count]C[i+1])" Next i...

I have 3 columns in Sheet1 with 3 data series...and I'd like to implement some formulas in sheet2 using a loop. Basically, I'd like to write a loop able to implement the average formula of each columns in sheet1 and write the result in the cella A1, B1 and C1. I don't know the symtax I'd...

Thank you guys, I knew that...I wanted just to be sure... ..I'm going probably to hide the headers.. bye

I'd like to know if it's possible to change columns and rows name in Excel using programming a VBA script??? So, i'd like to programmatically change columns name A, B, C in something always different.. thanks