Re: $$Excel-Macros$$ Help with saving files with path in cell B2

Hi Ashish, First of all congrats! You are a big help to all of us :) Also, Thanks a lot for your help. you. I tweaked your code a bit and got it to work the way I needed. now I have another problem: I am combining files from different location into one sheet (a new workbook). The list of files

Re: $$Excel-Macros$$ Help with saving files with path in cell B2

try this http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook On Sun, Jul 3, 2011 at 11:33 AM, Nasim nbeiz...@gmail.com wrote: Hi Ashish, First of all congrats! You are a big help to all of us :) Also, Thanks a

$$Excel-Macros$$ Re: required open xl addin

http://openexcel.googlecode.com/files/OPEN_XL.zip Best Regards Ashish Jain http://www.eXceLitems.com http://www.OpenExceL.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

See if it help http://www.mrexcel.com/tip069.shtml From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of karunanithi ramaswamy Sent: Saturday, July 02, 2011 9:29 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent Help

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

you are talking about *Permutation* given number : 1 2 3 4 5 total arrangement of permutation *=FACT(5)* = *120* == 12345 21345 31245 41235 51234 12354 21354 31254 41253 51243 12435 21435 31425 41325 51324 12453 21453 31452 41352 51342 12534 21534 31524 41523 51423 12543 21543

Re: $$Excel-Macros$$ Leave tracker help required

HI Vasant Sorry for the late reply thanks you very much for the effort,. Like to tell you that everything is perfect except one change need to do is that when ever Emp taken leaves continuously like say (15th June to 23rdJune ) so when I click for output it should give me only one entry but

$$Excel-Macros$$ Assistance required

Hi All, I am good with excel 2007 now I want to learn VBA coding in order to create automation tool. Please suggest some ideas. Thanks Regards, Vikas Verma Bank of America delhi.ve...@gmail.com 337199 -- --

$$Excel-Macros$$ Valuable Info

Hi, Register on the below link (FETISE) and get a instant 500/- rs off on any purchase of the product ..its really good and once after registered please refer to your friends and get paid and own your gifts. http://www.fetise.com/men/register2.php?refcode=81TJ5KG0G3 Thank you Surya --

Re: $$Excel-Macros$$ Assistance required

try these video tutorials and websites http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/ http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ On Sun, Jul 3, 2011 at 3:39 PM, vikas verma delhi.ve...@gmail.com wrote: Hi All, I am good with excel 2007

$$Excel-Macros$$ How to use Event Change to Change Color of Row

Hi all,I need to know how to use Event Change to Change Color of Row according to changing in specified Column cells.for example:I have column S any cell in it take code A,B,C,D,R W.I need when any cell change in the column S taken one of the previous 6 codes, then the Row of it change to

Re: $$Excel-Macros$$ help

workbook is not having any macro it contains UDF user defined function. write =vrate(b1) in d1 and then drag down the formula. it work like excel formula if you press alt + f11 and press on module 1 you can see the code Option Explicit Function vRate(iResult As Integer) As Variant Select

Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count = 1 And Target.Column = 19 Then Range(a Target.Row).Interior.Color = RGB(192, 192, 192) Range(b Target.Row).Interior.Color = RGB(192, 192, 192) Range(d Target.Row).Interior.Color = vbYellow Range(c Target.Row).Interior.Color

Re: $$Excel-Macros$$ Excel Pop-ups

pls declare I as Long then try On Sun, Jul 3, 2011 at 8:41 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Please fill up this format with Some Example data so that we can help * * * * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of

RE: $$Excel-Macros$$ Assistance required

www.akoul.blogspot.com https://www.facebook.com/ExcelLover https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897 https://www.facebook.com/microsoftexcel https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2; ref=ts

RE: $$Excel-Macros$$ help

Function procedure can not be Run By F5 if they have any Arguments, they can only return a value on worksheet and to variable. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Sunday, July 03, 2011 4:12 PM To:

RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row

Please Read this Article http://www.cpearson.com/excel/Events.aspx From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ahmed galal Sent: Sunday, July 03, 2011 5:46 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to use Event Change to

Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row

try using conditional formatting. On Sun, Jul 3, 201r1 at 5:45 PM, Ahmed galal ahmed.ga...@live.com wrote: Hi all, I need to know how to use Event Change to Change Color of Row according to changing in specified Column cells. for example: I have column S any cell in it take code A,B,C,D,R

Re: $$Excel-Macros$$ Assistance required

Hi Vikas, Look the Below Link http://excelvbatutor.com/vba_tutorial.html *Best Regards,* *Venkat* * * On Sun, Jul 3, 2011 at 3:39 PM, vikas verma delhi.ve...@gmail.com wrote: Hi All, I am good with excel 2007 now I want to learn VBA coding in order to create automation tool. Please

Re: $$Excel-Macros$$ help

Thankyou very much sir I got it... On Sun, Jul 3, 2011 at 4:11 PM, vijayajith VA vijayajith...@gmail.comwrote: HI Sir, I am unable to run the program...if i press f5 or run the program. it will ask Create macro please see the attached sheet. thankyou --

Re: $$Excel-Macros$$ Unsolved Queries

Hi, rajan Please can you explain event procedure ... I have gone thr several sites but still i dont kn how to use event procedures Thankyou On Sun, Jul 3, 2011 at 8:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Dear All, If you have any Unsolved Queries From Long time On Group ,

$$Excel-Macros$$ Re: Custom Function

By working this function using debug. print (immediate window) and studying the use of arrays, I was able to obtain the UDF I was hoping to create. It takes a series of trade results (stock/futures/ options/...blackjack), such as -100, 500, 1500, -600 etc, and returns the optimal fixed fraction of

Re: $$Excel-Macros$$ Sumif across multiple worksheets

Hello Susan, If you just have 3 sheets, Sheet1, Sheet2 Sheet3. use this; =SUMPRODUCT(SUMIF(INDIRECT('Sheet{1,2,3}'!D:D),C Wagner,INDIRECT('Sheet{1,2,3}'!E:E))) Or, Enter all sheet names in a range, say in J2:J3, then use this; =SUMPRODUCT(SUMIF(INDIRECT('$J$2:$J$4'!D:D),C

$$Excel-Macros$$ workbook location on status bar

Hi, Is there a code or a build-in option to have the location path of a workbook permanently showing on the Excel status bar? Thanks Pascal -- -- Some important links for excel users: 1. Follow us on TWITTER for

$$Excel-Macros$$ Attachments to Group

Hi I want to post a message with .xls file attached. Where is the button to add attachments to email ? Thanks Charlie -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Attachments to Group

mail your workbook to excel-macros@googlegroups.com and add file as attachement On Mon, Jul 4, 2011 at 2:56 AM, sswcharlie swch...@gmail.com wrote: Hi I want to post a message with .xls file attached. Where is the button to add attachments to email ? Thanks Charlie --

Re: $$Excel-Macros$$ workbook location on status bar

'--Thisworkbook Module:-- Dim OldStaBar As String Private Sub Workbook_Open() OldStaBar = Application.DisplayStatusBar Application.DisplayStatusBar = True Application.StatusBar = ThisWorkbook.FullName End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean)

Re: $$Excel-Macros$$ Unsolved Queries

Event Procedure *Event*- An *Event* is an action initiated either by user action or by other VBA code. As noted above, events are generated by: · *The Workbook * · *The Worksheets * · The Application (User form) ·

RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row

Thanks ashish for code it helped me a lotnow i developed the code to be: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 19 And Target.Count = 1 Then Select Case Target.ValueCase ATarget.EntireRow.Interior.Color = RGB(192, 192, 192)Case CTarget.EntireRow.Interior.Color =

RE: $$Excel-Macros$$ workbook location on status bar

Paste it on Workbook code module Private Sub Workbook_Open() Application.StatusBar = ThisWorkbook.Path End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkatesan c Sent: Monday, July 04, 2011 7:37 AM To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Excel VBA for BOM

Hi, FYI, Sorry, the previously attached file already contains the macro, but its not full proof. It is not highlighting rows 137 to 142. because its not in sorted order. Rash -- -- Some important links for excel