Re: $$Excel-Macros$$ shortcut key .

The same is applicable for removing filter also. --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 12:17 PM, vijayajith VA wrote: > Sorry . that is for put filter and remove filter.i need to clear checked > items .in filtered coloumn. > > > On Sun, Dec 18, 20

Re: $$Excel-Macros$$ shortcut key .

Sorry . that is for put filter and remove filter.i need to clear checked items .in filtered coloumn. On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . wrote: > Alt+D+F+F > > --- > Ms.Exl.Learner > --- > > > On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA

Re: $$Excel-Macros$$ shortcut key .

Alt+D+F+F --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote: > Hello sir > > Can you tell me what is shortcut key for data clear(filter)? > > > Thanks > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use co

Re: $$Excel-Macros$$ shortcut key .

HI andy, A Filter button [image: Applied filter icon] means that a filter is applied.-I want to clear ths applied filter .for that i need short cut key .i refered your link. i dint get it please hlp me Thanks for your reply On Sun, Dec 18, 2011 at 10:55 AM, Aindril De wrote: > Hi > > Try thi

Re: $$Excel-Macros$$ shortcut key .

Hi Try this: http://dmcritchie.mvps.org/excel/shortx2k.htm Cheers, andy On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote: > Hello sir > > Can you tell me what is shortcut key for data clear(filter)? > > > Thanks > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use c

$$Excel-Macros$$ shortcut key .

Hello sir Can you tell me what is shortcut key for data clear(filter)? Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not ge

Re: $$Excel-Macros$$ VBA select data in BOLD

Did you run it on the file I sent you? I just retested xl2003, xl2007, xl2010 and it worked just fine on all. Send YOUR file. Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Saturday, December 17, 2011 6:17 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Mac

Re: $$Excel-Macros$$ VBA select data in BOLD

On Sun, Dec 18, 2011 at 9:18 AM, dguillett1 wrote: Attached wbook Hi Don This happens when I run the code- Highlights *SearchFormat:=* with msg: Compile error Named argument not found r1 = Range(Cells(1, "g"), Cells(lr, "g")).Find(What:="", After:=Cells(sr, "G"), LookIn:=xlValues, Lo

RE: $$Excel-Macros$$ Compare character types in 2 character string

Hi StephenM, Sorry, correction: =ISERROR(VALUE(LEFT(A1,1)))=ISERROR(VALUE(RIGHT(A1,1))) is the correct formula for the below! :) Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Saturday, December 17, 2011 3:

RE: $$Excel-Macros$$ Compare character types in 2 character string

Hi StephenM, =isnumber(left(a1,1))=isnumber(right(a1,1)) That will return TRUE if the first and last character are the same type (numeric or non-numeric). It will return FALSE if they are different types. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@go

RE: $$Excel-Macros$$ urgent,can anyone teach me "Private Const LLKHF_ALTDOWN = &H20 "meaning

Hi Garcia, The key words and symbols in that line of code have the folowing meanings: PRIVATE - Scope of the constant is limited to the current module. Other modules cannot access the constant. CONST - Define/declare a constant (like a variable, but the value cannot be modified. It has a co

Re: $$Excel-Macros$$ Mid Function

Hello Amir, you can use below formula as well. =LEFT(MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1 but i think below formula is much shorter than this 1.  :) > > From: Aamir Shahzad >To: exc

Re: $$Excel-Macros$$ Help on isblank & iferror

as desired =IF(ISBLANK(A2),"",IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$A$3,1,0)),"Not Received",SUMIF(Sheet1!$A$2:$A$3,A2,Sheet1!$B$2:$B$3))) See the attached sheet. Aamir Shahzad On Fri, Dec 16, 2011 at 5:44 PM, Vijayendra Rao wrote: > Hi All, > > I want to put isblank and iferror formula in one cell.

Re: $$Excel-Macros$$ Help on isblank & iferror

=IF(A3="","",IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),"not recieved")) Don Guillett SalesAid Software dguille...@gmail.com From: Vijayendra Rao Sent: Friday, December 16, 2011 6:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on isblank & iferror Hi All, I want to put isbla

Re: $$Excel-Macros$$ Need a macro to update charts automatically

Please explain your need Don Guillett SalesAid Software dguille...@gmail.com From: Atul vishwakarma Sent: Thursday, December 15, 2011 8:29 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Need a macro to update charts automatically Hi Friends, I need a macro to update charts automati

Re: $$Excel-Macros$$ help to make pivot table

http://www.contextures.com/xlpivot01.html http://www.contextures.com/xlpivot04.html http://www.contextures.com/tiptech.html On Sat, Dec 17, 2011 at 9:46 AM, Ruchi Sharma wrote: > plzz tell me how to make a pivot table > > > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1)

Re: $$Excel-Macros$$ VBA select data in BOLD

Hi Don & Noorain Thanks for your comments and ideas. I am taking one of our address lists and reducing the information in it as we will be doing everything by email and phone. Address etc not now required. Will also once this first task finished then classify into Catergory types for industries et

$$Excel-Macros$$ Help on isblank & iferror

Hi All, I want to put isblank and iferror formula in one cell. Can you please help. Attached sheet for your reference. Regards, Vijayendra 94491 67631 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urge

$$Excel-Macros$$ Worksheet Combobox to list available macro

Hi, Does someone know how to list macros from current opened workbooks in a worksheet control combobox? More precisely, I'd like to make a reference or create an alias to a macro. For instance: in the project window in the Vba editor in another OPENED workbook I have a few macros like : ArchPastV

$$Excel-Macros$$ Compare character types in 2 character string

I have extracted 2 characters from a longer string. I need to determine if both characters are the same type (both alphabetic, or both numeric), else if they are a different character types. The order of character types does not matter, just if they are both the same type. Please correct my terms

Re: $$Excel-Macros$$ Mid Function

Try the following formula: =IF(ISERR(MID(A2,FIND(" ",A2)+1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)), FIND(" ",A2),FIND(" ",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1)),"",MID(A2,FIND(" ",A2)+ 1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",A2),FIND(" ",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1)) Norman On Sat, D

Re: $$Excel-Macros$$ Almost all calculator in one sheet

thanx ankit, this is awesome. and quite usefull. On Thu, Dec 1, 2011 at 9:45 AM, Pranav N wrote: > Thanks. > > -Nas > > > On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal < > ankit.agrawal...@gmail.com> wrote: > >> Hello All, >> >> In our daily life we calculate so many thing & use differen

Re: $$Excel-Macros$$ Median in Pivot Table

Hi Noorain, Thanks for your response but I am disappoint to know that we cannot make user define function within Pivot -- Atul On Thu, Dec 15, 2011 at 11:05 AM, NOORAIN ANSARI wrote: > Dear Atul, > > Please see below link, hope it will help to u. > > http://www.digdb.com/excel_add_ins/median_p

$$Excel-Macros$$ help to make pivot table

plzz tell me how to make a pivot table -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

Re: $$Excel-Macros$$ Mid Function

Thanks Asa Aamir Shahzad On Sun, Dec 18, 2011 at 12:36 AM, Asa Rossoff wrote: > Hello Aamir, > > You can use: > > =MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2)) > > > > Because the third argument to MID is the starting position, we can start > the search for the second space a

RE: $$Excel-Macros$$ Mid Function

Hello Aamir, You can use: =MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2)) Because the third argument to MID is the starting position, we can start the search for the second space after the first space. ~Asa From: excel-macros@googlegroups.com [mailto:excel-macros@google

$$Excel-Macros$$ Mid Function

Dear Group, When I am extracting the "Insulators" text by below mentioned mid function it shows only "Insulat", Please suggest what amendment required in this formula. Ceramic Insulators #124-TD45-87 =MID(A2,FIND(" ",A2),FIND(" ",A2)) -- Regards, Aamir Shahzad -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ regarding addins in vba

Noorain sb, What about excel 2010 add in , if I want to create one add in (password protected) where I can save all desired macros, UDF & if any buttons for create customized commands. Regards, Aamir Shahzad On Sat, Dec 17, 2011 at 11:10 PM, NOORAIN ANSARI wrote: > pfa > > > 2011/12/17 NOORAIN

Re: $$Excel-Macros$$ regarding addins in vba

Thanks Noorain On Sat, Dec 17, 2011 at 11:40 PM, NOORAIN ANSARI wrote: > pfa > > > 2011/12/17 NOORAIN ANSARI > >> Dear Vijay, >> >> Please try it >> >> file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm >> http://www.ozgrid.com/Services/ExcelAdd-insPage.htm >> >> -- >> Thanks & regards, >

Re: $$Excel-Macros$$ regarding addins in vba

pfa 2011/12/17 NOORAIN ANSARI > Dear Vijay, > > Please try it > > file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm > http://www.ozgrid.com/Services/ExcelAdd-insPage.htm > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Dear Aamir, Thanks... *=VLOOKUP(D7,INDIRECT(TEXT(D5,"")&"!B2:C4"),2,FALSE)* in above formula Indirect function is providing us full month name which are also sheetname. after using indirect function range is converting like October!B2:C2,November!B2:C2,December!B2:C2, which is our

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Ofcorse it can hve macros, the idea behind it to store invoice data. If macros is being used then to make it more good other then active sheet can be hiden. Vickey -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Does this have to be a formula or can you use macros? Don Guillett SalesAid Software dguille...@gmail.com From: vickey Sent: Saturday, December 17, 2011 3:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value

Re: $$Excel-Macros$$ Re: Help On Print

attach or send me your file with a better explanation and examples. Don Guillett SalesAid Software dguille...@gmail.com From: Shrinivas Shevde Sent: Friday, December 16, 2011 10:42 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Help On Print Dear Rohan Thanks for the h