Re: $$Excel-Macros$$ Calling a Macro

You're welcome Harry... What error were you getting ? Regarding the type of controls, below link throws some light - http://www.ozgrid.com/Excel/Excel-controls-forms-toolbox.htm Cheers! AJ On Tue, Apr 13, 2010 at 7:50 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Aj, > > Th

$$Excel-Macros$$ Boolean for Dependents?

Does code exist that returns a True when a cell has one or more dependents? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ Calling a Macro

Aj, Thanks for the solutions, i will try to test it extensively, as i am not sure, why i was getting that error, though i was using pretty much similar command. Would you be able to highlight, some differences between the command button created from the Visual Basic Toolbar and from a Forms toolb

Re: $$Excel-Macros$$ Does anybody have games

Thank you :) On Apr 8, 11:08 pm, janet dickson wrote: > More games for all > > > > On Tue, Apr 6, 2010 at 10:07 PM, Nani Ram <06n...@gmail.com> wrote: > > Hi All, > > > Does anybody have games in excel sheet, if so please send me. > > > Thanks, > > Naniram > > > -- > > > -

$$Excel-Macros$$ Re: Changing multiple spreadsheets

Hi DeanL, Paul gave a great answer, but I am not sure you are going to be happy with it... Can you please send one of those workbooks aka spreadsheets and specify clearly what "piece of code in the back" should have which modification... I will give you in return a .vbs that iterates through those

$$Excel-Macros$$ Re: Need help on the below xl file

Here it is... Greetings, Paul Willekens '=== Sub GetCenters() Dim cLevel1 Dim cLevel2 Dim cLevel3 Dim cLevel4 Dim cLevel5 Dim cLevel6 Dim cRaw Dim cTest Dim lDone Dim nCenter Dim nRowIn Dim nRowOut nRowIn = 2 nRowOut = 5 cRaw

$$Excel-Macros$$ Wildcards with Instr FUnction

Can we use wildcards with instr function.If yes how ? I also need help in MS Acsess ? Can u pls guide me to the right way -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and l

Re: $$Excel-Macros$$ Refresh Autofilter Automatically

Thanks Paul. This was what I needed. I used the code in the first sheet. Regards Yahya On Mon, Apr 12, 2010 at 5:54 PM, Paul Schreiner wrote: > You could create a Sheet Activate event that would refresh your filter: > > on the sheet tab name, right-click > > Private Sub Worksheet_Activate()

$$Excel-Macros$$ Convert to unique rows

I'm not sure of the term to use for what I want to do. I have 412 rows summarizing the number of pieces of different equipment at a given place. I need to put each piece of equipment on a distinct row. I have uploaded a file manos_sample_data that shows a FROM & TO sample. Can anyone assist with ho

Re: $$Excel-Macros$$ Re: Datewise,townwise data??

Hi Praveen Are we speaking about the same sheet, because in the one you sent I have 9704 rows, not 7094... Did you apply the formulae in columns D and E first, for all 121 rows? If it doesn't function, please send the excel sheet in annex for me to examen it Kind regards, Paul Willekens -

$$Excel-Macros$$ simple way to make an add-in automatically install?

Hello, I have created a very simple excel add-in that contains three small macros to clean up some exported data from a specific contact management program. I would like to be able to distribute this add-in to other people that use the contact management program. I am trying to make it as user fr

Re: $$Excel-Macros$$ Changing multiple spreadsheets

Hi Paul, Thank you so much for the quick reply. It is a standard module that contains the code and your solution appears to work wonderfully. Many thanks, Dean... On Apr 12, 10:29 am, Paul Schreiner wrote: > Your use of terms is a bit confusing. > A "workbook" is the term used for an excel "fi

Re: $$Excel-Macros$$ Changing multiple spreadsheets

Your use of terms is a bit confusing. A "workbook" is the term used for an excel "file" (typically ending in .xls for pre-excel 2007) A "spreadsheet" is a term commonly used for a specific Worksheet of a "workbook" (represented by a sheet "tab" at the bottom of the workbook window) By stating tha

$$Excel-Macros$$ Changing multiple spreadsheets

Hi everyone, I have a user who has several thousand spreadsheets in a single directory and she needs to alter each one's code. Does anyone know a way to iterate through every spreadsheet in the directory and change a piece of code in the back of each spreadsheet without having to do each one manu

Re: $$Excel-Macros$$ Refresh Autofilter Automatically

You could create a Sheet Activate event that would refresh your filter: on the sheet tab name, right-click Private Sub Worksheet_Activate() ActiveSheet.AutoFilter.ApplyFilter End Sub that way, whenever you change to the sheet, it would automatically refresh the filter. Or,on the other sheet, c

$$Excel-Macros$$ Refresh Autofilter Automatically

Hi I have autofilter set to filter on column D. The data in column D is updated from another worksheet. If I update the other worksheet the cells in Column D do change, but to refresh the autofilter, it has to be done manu

$$Excel-Macros$$ Pivot Problem

Hello Group, *Overview:* I have a issue to discuss. I have got an excel sheet which contains over 150,000 trial balance account subheads made up of data from different branches (All Branches). So there are multiple account heads that are repeating. I have constructed a Pivot table out of the data

$$Excel-Macros$$ Re: Need help on the below xl file

Hi Paul, Its working superb!! Thanks a lot for your code. How do I make changes in the code if I need the below: * If I need rollup code description instead of rollup code, how do I get it. * If I need both rollup code and description(concatenating), how do I get it. Please help me out. Reg

$$Excel-Macros$$ CAN I HAVE EVENTS IN personal.xlsb

Hi can i place events like worksheet_change etc in personal.xlsb file so that for every excel the sheet_change validations apply.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

Re: $$Excel-Macros$$ Re: Something is missing

Abhishek, I know about spellcheck feature. red-underlines are useful and time saving.. Anand On Mon, Apr 12, 2010 at 1:20 PM, Abhishek Jain wrote: > I think it is available.The only thing is it does not red-underlines the > miss-spelled words as MS Word does. > > > Abhishek > > On Mon, Apr 12

Re: $$Excel-Macros$$ Re: Something is missing

I think it is available.The only thing is it does not red-underlines the miss-spelled words as MS Word does. Abhishek On Mon, Apr 12, 2010 at 11:54 AM, Anand Desai wrote: > Ayush, > > Spellcheck the way available in MS Word.. my be useful.. I m not sure any > facility is available or not? > >

Re: $$Excel-Macros$$ Re: Something is missing

Ayush, Spellcheck the way available in MS Word.. my be useful.. I m not sure any facility is available or not? Anand On Mon, Apr 12, 2010 at 11:33 AM, Abhishek Jain wrote: > Thanks Ayush. > > My tuppence: > > Extracting unique vales from a range with a function or formula is missing. > Using Ad

Re: $$Excel-Macros$$ Re: Datewise,townwise data??

dear Paul, the macro is not giving the result it just shows a message that " Done at 7094th row" pls help thx and reg Praveen On Sun, 11 Apr 2010 20:31:58 +0530 wrote > Hi Praveen, Siti's formulae for column D and E are fine and should be applied first. But then I suggest to run this mac