Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

Congratulations! , J.Mothilal, Vellore On Fri, Jun 3, 2011 at 4:04 PM, SANJAY SONI sanjaysoni2...@yahoo.co.inwrote: Dear Ashish G, Congratulations on a great success. It is really appreciable for winning consecutive 6 times as MOST HELPFUL MEMBER. * Best Regards, * *Sanjay ** * **

$$Excel-Macros$$ Hyperlink for Sheet in a Cell - changes

Hi Is it possible to have say a cell with hyperlink to sheet (that is ok) but also if the name in that cell changes it stays as a hyperlink to a another sheet. eg if A1 has 'Sheet2' hyperlinked, and then A1 changes to 'sheet3' will the hyperlink change to sheet 3 ? Thanks Charlie --

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

Hi Part of a another code - I want to find the value(text) in active cell (value changes often) in workbook (except current WS and one other worksheet 'home) and delete. Could be more than one instance. Thanks Charlie --

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

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$$ How to record a macro

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 :

$$Excel-Macros$$ Goal seek in macros

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

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

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

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

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 04,

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

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$$ Excel File icon changed.. wanted to retrive

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 anil.bha...@tatacommunications.com Hi All, I am still facing

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

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) setiyowati.d...@gmail.com wrote: please check and try this VBA code if it helps Sub DoSomething() *   ' siti Vi*    

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

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 samde...@gmail.com wrote: Just a minor tweak to STDEV(i)'s code.

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

Hi Guys Thanks for that - magic. I understand now how it works. Thanks Charlie On Jun 5, 12:04 pm, STDEV(i) setiyowati.d...@gmail.com 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