$$Excel-Macros$$ get more and more knowledge

2011-06-04 Thread rosini
Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition,

Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

2011-06-04 Thread sswcharlie
Hi Guys Thanks for that - magic. I understand now how it works. Thanks Charlie On Jun 5, 12:04 pm, "STDEV(i)" wrote: > Dear GoldenLance, > > Thank you very much for your great sugestion.. > > user just *selects/activates a cell* where the criteria is written, and run > the macro... > > kindes

Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

2011-06-04 Thread STDEV(i)
Dear GoldenLance, Thank you very much for your great sugestion.. user just *selects/activates a cell* where the criteria is written, and run the macro... kindest regards, STDEV(i) On Sat, Jun 4, 2011 at 5:57 PM, GoldenLance wrote: > Just a minor tweak to STDEV(i)'s code. Based on the origina

Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

2011-06-04 Thread GoldenLance
Just a minor tweak to STDEV(i)'s code. Based on the original subject, I might change sCriteria = "MyCriteriaText" to sCriteria = ActiveCell.Value On Jun 4, 2:24 pm, "STDEV(i)" wrote: > please check and try this VBA code if it helps > > Sub DoSomething() > *   ' siti Vi* >    Dim w As Workshee

Re: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

2011-06-04 Thread Jorge Marques
Hi friend, i think you have to go to File > Info and then at your right there is Properties > Advanced Properties (i don´t know if these are the exact names, my excel is in portuguese). See if it helps, cheers 2011/6/4 Anil Bhange > Hi All, > > > > I am still facing problem, there is no Proper

Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

2011-06-04 Thread STDEV(i)
please check and try this VBA code if it helps Sub DoSomething() * ' siti Vi* Dim w As Worksheet, xCel As Range Dim sCriteria As String sCriteria = "MyCriteriaText" '<< please edit For Each w In Worksheets If Not w.Name = ActiveSheet.Name Then If Not LCase(w.Name

RE: $$Excel-Macros$$ Goal seek in macros

2011-06-04 Thread Rajan_Verma
See if it help Worksheets("Sheet1").Range("Polynomial").GoalSeek _ Goal:=15, _ ChangingCell:=Worksheets("Sheet1").Range("X") -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ritesh Jain Sent: Saturday, June

RE: $$Excel-Macros$$ How to record a macro

2011-06-04 Thread Rajan_Verma
RItesh, I think you are very new to excel.. Press ALT + T M R to start Recording A Dialogue Box will open and Ask For Macro Name and ShortCut Key what you want to assign for that with the location where you want to store that Macro.. If you select Personal Macro Workbook .. that macro will be avai

$$Excel-Macros$$ Goal seek in macros

2011-06-04 Thread Ritesh Jain
Dear Friends, How can i use goal seek in macros in Microsoft excel? For eg: I prepare balance sheet of XYZ Co. and the component of the balance sheet are: Assets: Advances40 Investments 25 Bank Balance 25 Fixed Assets 15 Other Assets

$$Excel-Macros$$ How to record a macro

2011-06-04 Thread Ritesh Jain
Dear Friends, Can somebody please guide me on how to record macros in excel? Regards, Ritesh Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/e

RE: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

2011-06-04 Thread Anil Bhange
Hi All, I am still facing problem, there is no Properties button in excel.. I am using Excel 2010... Please help me.. my all files preview shows internal data and not the default excel picture Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups