Re: $$Excel-Macros$$ Req VBA Code

Dear Nooran sir, thanks for Replay Ineed VBA Code for Thsi Particular sheet,, On Wed, Jun 13, 2012 at 12:24 PM, NOORAIN ANSARI wrote: > Dear Veeru, > > See attachment, Hope it will help to you. > > > On Wed, Jun 13, 2012 at 12:02 PM, Veeru TOC wrote: > >> >> >> >>> Dear Team

Re: $$Excel-Macros$$ Req VBA Code

> Dear Team > > > I attached Excel file Sheet1 -Names,Sheet-2 form , when > i click command button Create Particular Name with form > -- > > > > > > *Thanks&Regards* > > * * > > * **Veerendra.Vanam* > > *TOC TEAM* > * * *Bhagyanagar Electrical & Contractors** > **

Re: $$Excel-Macros$$ I want to learn macro from basic level

That's gud     Lakshman Prasad Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Tuesday, June 12, 2012 7:23 PM Subject: RE: $$Excel-M

Re: $$Excel-Macros$$ I want to learn macro from basic level

Dear Rajan and All,   I request,   Don’t say like this "I will send you on your email id ".If you really want to send then send him  silently.   Lakshman Prasad Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ __

Re: $$Excel-Macros$$ Sheet Requirements

Thanks... Thanks & Regards, *Deba Ranjan P* On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay wrote: > Hi Dear, > > It happens with everybody specially when someone tries to learn new > concepts of IT or any other topic. So keep going and this group is good to > help you. > > Mange

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Thanks Rajan On Tue, Jun 12, 2012 at 6:11 PM, Rajan_Verma wrote: > Hi dharti > > See the attached sheet.. I have used an class module to get application > events , > > ** ** > > HTH > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From

Re: $$Excel-Macros$$ HELLO

Hi, I saw a similar thing on another block, wherein the guy warned in his next mail not to open the link and said it is a spam and has not been sent by him. How can we protect our mail from such spam? Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN

Re: $$Excel-Macros$$ HELLO

Dear Michael, Please follow... 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 13, 2012 at 4:46 AM, Michael Brumby wrote: > > this is inte

$$Excel-Macros$$ HELLO

this is intense you should check this out http://www.business15nanews.net/biz/?page=0655543 -- FORUM RULES (986+ 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 Advic

Re: $$Excel-Macros$$ Date format change by running the macro

Fully tested on provided file. The lr is the last populated row in column A and was based on the file presented. It is designed so that whatever cell you select in col A then column B ONLY to the lr will be filled with the formula and the formatting. If not, send your file personally to me... D

Re: $$Excel-Macros$$ I want to learn macro from basic level

Hi Gulzar, As Rajan has mentioned in trail mail, download the desired e-book from the link http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pdf On Tue, Jun 12, 2012 at 9:50 PM, Gulzar Naqvi wrote: > > > Hi Mr. Rajan, > > Please also send Excel Power progra

RE: $$Excel-Macros$$ I want to learn macro from basic level

Hi Mr. Rajan, Please also send Excel Power programming with VBA on my email I'd on sgna...@hotmail.com. Regards, GHNaqvi Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level To: excel-macros@googlegroups.com From: amar.gur...@gmail.com Date: Tue, 12 Jun 2012 12:47:10 + Hi

Re: $$Excel-Macros$$ I want to learn macro from basic level

It's really good to learn VBA Fundamentals. Thanks Rajan. mANgeSH. On Tue, Jun 12, 2012 at 7:23 PM, Rajan_Verma wrote: > Hi Guys > > ** ** > > Download from this Link for excel 2007 > > ** ** > > > http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pd

Re: $$Excel-Macros$$ Sheet Requirements

Hi Dear, It happens with everybody specially when someone tries to learn new concepts of IT or any other topic. So keep going and this group is good to help you. MangeSH On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan wrote: > Thanks. >i love excel very much, Actually i keep on trying the

Re: $$Excel-Macros$$ Date

Dear Chandra, Try this one DATEDIF(A2,B2,"d") for Formula1(Days) TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss) CONCATENATE(C2," Days ",HOUR(D2)," Hr ",MINUTE(D2)," Mins ",SECOND(D2)," Sec") for Formula3 Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 7:58 PM, NOORAIN ANSARI wrote

Re: $$Excel-Macros$$ Date

Dear Chandra, Please see attached sheet. On Tue, Jun 12, 2012 at 7:15 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Can you please help me with attached excel. > > Thanks in advance. > > Regards, > > Chandra Shekar B > > -- > FORUM RULES (986+ members already BANNED for

Re: $$Excel-Macros$$ Date

Hi Chandra, PFA and see if it helps Thanks, On Tue, Jun 12, 2012 at 4:45 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Can you please help me with attached excel. > > Thanks in advance. > > Regards, > > Chandra Shekar B > > -- > FORUM RULES (986+ members already BANN

RE: $$Excel-Macros$$ I want to learn macro from basic level

Hi Guys Download from this Link for excel 2007 http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20Wi th%20VBA.pdf Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rak

Re: $$Excel-Macros$$ I want to learn macro from basic level

Please send me also @ chhajersand...@gmail.com Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Rakesh Kumar Sharma Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 19:03:51 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macr

Re: $$Excel-Macros$$ I want to learn macro from basic level

Hi Rajan My mail id is n.karthi...@gmail.com kindly send the same Regards karthik.N On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma wrote: > Excel Power programming with VBA J > > ** ** > > Either you can download from internet its free or I will send you on your > email id .. > > Really

$$Excel-Macros$$ Date

Hello, Can you please help me with attached excel. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ I want to learn macro from basic level

Hi Rajan, Plz send me on my email idif possible On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma wrote: > Excel Power programming with VBA J > > ** ** > > Either you can download from internet its free or I will send you on your > email id .. > > Really nice book to start from scratch.

Re: $$Excel-Macros$$ Sheet Requirements

Thanks. i love excel very much, Actually i keep on trying the coding But really i am so sorry that i really don't have this Idea. i purchased books for VBA macros and Excel, and i am trying my best to do so. Actually i am very new to this concepts (Means VBA coding). And even i am trying to

Re: $$Excel-Macros$$ Sheet Requirements

good reply don On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: > Forgive me but as I recall you have been a part of this group for > awhile. If so, you should have learned enough to do this yourself. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *Fro

Re: $$Excel-Macros$$ Sheet Requirements

Forgive me but as I recall you have been a part of this group for awhile. If so, you should have learned enough to do this yourself. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Deba Ranjan Sent: Tuesday, June 12, 2012 6:45 AM To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

I have created custom menu tab, but if i have open two workbook and switch one to another, then i want to activate customtab menu, when i switch on applicationworkbook. this time it always goto Home tab Divaker On Tue, Jun 12, 2012 at 6:25 PM, NOORAIN ANSARI wrote: > Dear Divakar, > > Please se

Re: $$Excel-Macros$$ Date format change by running the macro

Try Sub FormulaToEndOffset1SAS() Dim lr As Long With ActiveCell lr = Cells(.Row, .Column).End(xlDown).Row With Range(Cells(.Row, .Column + 1), Cells(lr, .Column + 1)) .Formula = _ "=IF(ISERR(DATE(LEFT(A" & .Row & ",4),MID(A" & .Row & ",5,2)," & _ "RIGHT(A" & .Row & ",2))),,DATE(LEFT(A" & .Row

Re: $$Excel-Macros$$ I want to learn macro from basic level

Hi Rajan, Please send the same on my email I'd on amar.mas...@gmail.com Regards, Amar Sent on my BlackBerry® from Vodafone -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 18:15:14 To: Reply-To: excel-macros@googlegroups.com Subject:

RE: $$Excel-Macros$$ I want to learn macro from basic level

Excel Power programming with VBA J Either you can download from internet its free or I will send you on your email id .. Really nice book to start from scratch. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] O

RE: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Hi dharti See the attached sheet.. I have used an class module to get application events , HTH Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dhartiku...@gmail.com Sent: 12 June 2012 3:31 To: e

Re: $$Excel-Macros$$ Error handling matter

thanks noorain bhai, but i want some more. please provide me Divaker On Tue, Jun 12, 2012 at 5:57 PM, NOORAIN ANSARI wrote: > Dear Divaker, > > Please read CPearson site..Here is good example Error Handlers. > > http://www.cpearson.com/excel/errorhandling.htm > > > On Tue, Jun 12, 2012 at 3:05 P

Re: $$Excel-Macros$$ Error handling matter

Dear Divaker, Please read CPearson site..Here is good example Error Handlers. http://www.cpearson.com/excel/errorhandling.htm On Tue, Jun 12, 2012 at 3:05 PM, Divaker Pandey wrote: > Hi Experts, > > can you please provide me some matter on error handling in vba application. > > Divaker > > > -

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Thanks for reply ranjan, but i want that whenever i activate workbook that contains customtab, it must selected by detault. On Tue, Jun 12, 2012 at 5:52 PM, Rajan_Verma wrote: > You can read about CustomUI Editor , it basically used to manipulate and > create new ribbon in Excel 2007 and later***

RE: $$Excel-Macros$$ Error handling matter

You can google on following topics: 1). Breakpoint 2).Step Forward 3). Watch Window 4) Immediate window 5) On Error 6).Err Object property Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of

RE: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

You can read about CustomUI Editor , it basically used to manipulate and create new ribbon in Excel 2007 and later Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: 12 June 2012 3:0

RE: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: 12 June 2012 4:00 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ call addin fuction before activeworkbook close

$$Excel-Macros$$ Sheet Requirements

Dear Experts, i have attached a file which contains many sheets. in every sheets there contains data. i want a button which on clicking the whole sheet data consolidated. Please find the attached. thanks... Thanks & Regards, *Deba Ranjan P* -- FORUM

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Will inform u status tommorow, I am left from offoce for a meeting. Sent from BlackBerry® on Airtel -Original Message- From: Divaker Pandey Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 16:40:15 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ ca

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

try this one Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Run "'" + "idbiuploader.xlam" + "'!uploadingmodel" End Sub On Tue, Jun 12, 2012 at 4:22 PM, Dhartikumar Sahu wrote: > hi divakar > > i have a addin > > whenever i close any workbook , it should be run from addins >

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

hi divakar i have a addin whenever i close any workbook , it should be run from addins addinfile name: idbiuploader.xlam macro name : uploadingmodel please help.. Dhartikumar On Tue, Jun 12, 2012 at 4:00 PM, Divaker Pandey wrote: > > Hi Dharti, > > If i could understand your problem, t

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Hi Dharti, If i could understand your problem, then please use following code Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1, argument2, argumentN End Sub On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey wrote: > can

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

can you provide more details On Tue, Jun 12, 2012 at 3:31 PM, wrote: > ** > Any update. > Sent from BlackBerry® on Airtel > -- > *From: * dhartiku...@gmail.com > *Date: *Tue, 12 Jun 2012 07:15:16 + > *To: * > *ReplyTo: * dhartiku...@gmail.com > *Subject: *Re:

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Any update. Sent from BlackBerry® on Airtel -Original Message- From: dhartiku...@gmail.com Date: Tue, 12 Jun 2012 07:15:16 To: Reply-To: dhartiku...@gmail.com Subject: Re: $$Excel-Macros$$ call addin fuction before activeworkbook close .. Urgent Urgently required code please. S

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Urgently required code please. Sent from BlackBerry® on Airtel -Original Message- From: Dhartikumar Sahu Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 10:46:34 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ call addin fuction before activeworkbook c

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Hi Expert, One more question if, i want to select my Custom Menu tab on each time workbook window activation, how i can i do it. Divaker On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey wrote: > Dear Ashish, > > Thanks from my bottom of hearts. > > I salute you. > > Divaker > > > On Fri, Mar 30,

$$Excel-Macros$$ I want to learn macro from basic level

Hi Masters, If you have any attachment which can help me to learn excel macro from starting point, plz share. -- *Regards, Rakesh Kumar Sharma Contact: +91-9971024741 * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ Excel Function details collection required

Hi Divakar You can Download file from here http://www.xlfdic.com/ It will explain you most of the functions with examples and syntax Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 1:54 PM, Divaker Pandey wrote: > Hi Members, > > I have required syntax and details of each excel function

Re: $$Excel-Macros$$ Date format change by running the macro

Dear Ankur, Please if you don't mind will you make your font sytle and size as a simple Or plain one. It looks too ODD. Thanks for your understanding. Regards, On Tue, Jun 12, 2012 at 11:38 AM, ankur wrote: > *HI ASHISH > **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbec

Re: $$Excel-Macros$$ Date format change by running the macro

*HI ASHISH **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i dont know* how to stop the code after the blank cellsExperts will guide me in this issue how to remove this flawfile is attached for your reference * Sub chgDateFormat() ActiveCell.Offset(0, 1).Range("

$$Excel-Macros$$ Excel Function details collection required

Hi Members, I have required syntax and details of each excel function. Please provide me. thanks in advance. Divaker -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Date format change by running the macro

Hi Select the range and run this macro Sub kTest() Dim x With Selection x = .Address .Value = Evaluate("if(isnumber(" & x & "),TEXT(" & x & ",""\-00\-00"")+0," & x & ")") .NumberFormat = "dd-mmm-" End With End Sub Kris ExcelFox

$$Excel-Macros$$ Re: Introduce Yourself !!

Hey,I am interested to find out how microsoft excel can generate different views for the report. On Tuesday, June 12, 2012 3:18:09 PM UTC+8, VKB wrote: > > > > On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote: >> >> Hey all new and current posters, >> >> Welcome to excel group,one of

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Urgently required code please. Sent from BlackBerry® on Airtel -Original Message- From: Dhartikumar Sahu Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 10:46:34 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ call addin fuction before activeworkbook c

$$Excel-Macros$$ Re: Introduce Yourself !!

On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of excel Fans! > > I hope you enjoy your time here & find this forum to be a friendly and > knowledgeable community. Please feel fr