Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread ashish koul
r u using right button also On Wed, Feb 9, 2011 at 7:53 PM, ashish koul koul.ash...@gmail.com wrote: can you share your workbook On Wed, Feb 9, 2011 at 6:57 PM, rcamarda robert.a.cama...@gmail.comwrote: Ashish, 1. Your code worked from your example. 2. in my other tests, I added added

Re: $$Excel-Macros$$ Insert Rows based on IF condition

2011-02-08 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ help pls : find first non empty row in range

2011-02-08 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-08 Thread ashish koul
to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ $$Excel and macros$$

2011-02-07 Thread ashish koul
Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com

Re: $$Excel-Macros$$ Intercompany company reconciliation report

2011-02-07 Thread ashish koul
check sheet3 paste names and email id it will automatically send emails to them. it working at my place On Mon, Feb 7, 2011 at 4:34 PM, Jagadeesh B S jagg...@gmail.com wrote: Dear ashish koul when I click the run macro i can see that a new blank excel is getting generated, but what I need

Re: $$Excel-Macros$$ Extract text from parentheses

2011-02-07 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish

Re: $$Excel-Macros$$ how to count names

2011-02-06 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ all data in file

2011-02-06 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Unique records

2011-02-06 Thread ashish koul
at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul

Re: $$Excel-Macros$$ Creating an array of email addresses and using Outlook to send copy of excel worksheet to each

2011-02-05 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Ashish Koul : Most helpful member : Jan11

2011-02-03 Thread ashish koul
Thank you all... On Thu, Feb 3, 2011 at 12:36 PM, Umesh Dev umesh.d...@gmail.com wrote: congrats Ashish Regards Umesh Dev On Wed, Feb 2, 2011 at 8:25 PM, Ayush jainayus...@gmail.com wrote: Ashish Koul has been selected as *'Most Helpful Member'* for the month of Jan 2011. He has

Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

2011-02-03 Thread ashish koul
Format text Regards, Aamir Shahzad On Wed, Feb 2, 2011 at 3:53 PM, ashish koul koul.ash...@gmail.comwrote: type this in cell f5 =TEXT(E5,) On Wed, Feb 2, 2011 at 1:09 PM, solomon raju faithful1...@gmail.comwrote: Hi All, How can we extract month in text. Can someone define some

Re: $$Excel-Macros$$ Intercompany company reconciliation report

2011-02-03 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin

Re: $$Excel-Macros$$ Eliminate duplicates and close gaps in series

2011-02-03 Thread ashish koul
at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

Re: $$Excel-Macros$$ Counting words or letters

2011-02-03 Thread ashish koul
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul

Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

2011-02-02 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-02 Thread ashish koul
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Sorting a list; adding blanks when either side is not present

2011-02-01 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think

Re: $$Excel-Macros$$ QUERRY

2011-01-31 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Please help

2011-01-30 Thread ashish koul
, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Please help

2011-01-29 Thread ashish koul
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-28 Thread ashish koul
-- regards seba On 27 jan., 17:31, ashish koul koul.ash...@gmail.com wrote: Sub consolidatefromdifferentworkbooks() Application.DisplayAlerts = False 'On Error GoTo abc Dim ask As Workbook Dim ask2 As Workbook Dim ASK3

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-27 Thread ashish koul
On Thu, Jan 27, 2011 at 11:37 AM, ashish koul koul.ash...@gmail.com wrote: Sub consolidatefromdifferentworkbooks() Application.DisplayAlerts = False 'On Error GoTo abc Dim ask As Workbook Dim ask2 As Workbook Dim ASK3 As Workbook Set ASK3 = ActiveWorkbook Dim i As Long Dim j As Long

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-27 Thread ashish koul
you. regards, seba On 27 jan., 07:07, ashish koul koul.ash...@gmail.com wrote: Sub consolidatefromdifferentworkbooks() Application.DisplayAlerts = False 'On Error GoTo abc Dim ask As Workbook Dim ask2 As Workbook Dim ASK3 As Workbook Set ASK3 = ActiveWorkbook Dim i As Long

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-27 Thread ashish koul
a fresh new workbook and name the workbook with that name of the person Regards, Shannur --- On *Thu, 1/27/11, ashish koul koul.ash...@gmail.com* wrote: From: ashish koul koul.ash...@gmail.com Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks To: excel-macros

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-27 Thread ashish koul
shannur can you attch the sample workbook On Thu, Jan 27, 2011 at 9:13 PM, ashish koul koul.ash...@gmail.com wrote: use 2 for second sheet or 3 for 3 rd sheet like sheets(2).select or you can also sheets(abc).select Workbooks.Open Filename:=Sheets(1).Range(a i).Value Set ask2

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-27 Thread ashish koul
Application.DisplayAlerts = True End Sub - regards seba On 27 jan., 16:44, ashish koul koul.ash...@gmail.com wrote: shannur can you attch the sample workbook On Thu, Jan 27, 2011 at 9:13 PM, ashish koul koul.ash...@gmail.com wrote: use 2 for second sheet or 3 for 3 rd

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-27 Thread ashish koul
= True End Sub On Thu, Jan 27, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote: put sheetnames always in double quotes Sheets(PRIPRAVA_PROJEKTA). On Thu, Jan 27, 2011 at 9:23 PM, Seba sebastjan.hri...@gmail.com wrote: Hi, I made the following change for sheet name and I get

Re: $$Excel-Macros$$ Help With UserForms

2011-01-27 Thread ashish koul
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ How to make query of cells?

2011-01-26 Thread ashish koul
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot

Re: $$Excel-Macros$$ Email Macro Based on an Address in a specific Cell

2011-01-26 Thread ashish koul
To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

Re: $$Excel-Macros$$ keep one column constant while changes the second

2011-01-26 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-26 Thread ashish koul
that only the 1st row contains any data. I hope this helps a bit. Thank you for the help. Best regards, seba On 17 jan., 18:38, ashish koul koul.ash...@gmail.com wrote: send us the sample workbook On Mon, Jan 17, 2011 at 12:10 AM, Seba sebastjan.hri...@gmail.com wrote: Hello

Re: $$Excel-Macros$$ macro for adding comments to cells

2011-01-26 Thread ashish koul
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Email Macro Based on an Address in a specific Cell

2011-01-26 Thread ashish koul
to a location? Thank you for your excellent assistance learning Excel. John On Wed, Jan 26, 2011 at 7:40 AM, ashish koul koul.ash...@gmail.comwrote: try this see if it helps With OutMail .to = ActiveSheet.Range(b I).Text .CC = ActiveSheet.Range(c I).Text On Wed, Jan

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-26 Thread ashish koul
to open the module/code, it's protected by password :( Nonetheless, thanks for the help. On 1/26/2011 10:33 PM, ashish koul wrote: try this macro see if it helps On Wed, Jan 26, 2011 at 4:22 PM, Seba sebastjan.hri...@gmail.com wrote: Hello, how can I upload the file, as I see

Re: $$Excel-Macros$$ Calculate Difference between two dates

2011-01-26 Thread ashish koul
below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Calculate Difference between two dates

2011-01-26 Thread ashish koul
OR USE =INT((A1-B1)*24) On Thu, Jan 27, 2011 at 11:54 AM, ashish koul koul.ash...@gmail.com wrote: =TEXT(A1-B1,[HH]:MM) On Thu, Jan 27, 2011 at 10:48 AM, Jitendra Verma jitendra.kumarve...@gmail.com wrote: Hi, How do we calculate the difference between two dates in Hours. Dates

Re: $$Excel-Macros$$ Macro to sort data in Ascending/Descending order

2011-01-25 Thread ashish koul
below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Extract date from one cell

2011-01-24 Thread ashish koul
follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

Re: $$Excel-Macros$$ Help

2011-01-21 Thread ashish koul
, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -- *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashish koul *Sent:* Wednesday, January 19, 2011 8:33 PM *To:* excel

Re: $$Excel-Macros$$ Auto Reference

2011-01-21 Thread ashish koul
at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

Re: $$Excel-Macros$$ Re: Sumproduct Query ********** Ashish Koul

2011-01-20 Thread ashish koul
at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

Re: $$Excel-Macros$$ Separate the values in different columns

2011-01-19 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

2011-01-19 Thread ashish koul
at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

Re: $$Excel-Macros$$ Help

2011-01-19 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

2011-01-19 Thread ashish koul
With appWord Regards ROHAN On Wed, Jan 19, 2011 at 8:10 PM, ashish koul koul.ash...@gmail.comwrote: hi i tried its working fine at my place attaching the working macro again 19, 2011 at 5:57 PM, Prathima R prathima@gmail.com wrote: Hi , I tried this macro but I am unable find

Re: $$Excel-Macros$$ Need Help

2011-01-17 Thread ashish koul
, Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

Re: $$Excel-Macros$$ good evening all experts can u solve my problem

2011-01-17 Thread ashish koul
to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-17 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Query

2011-01-17 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think

Re: $$Excel-Macros$$ Array If

2011-01-17 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10

Re: $$Excel-Macros$$ latest entry/ Value By formula in excel

2011-01-16 Thread ashish koul
Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830

Re: $$Excel-Macros$$ How to Fill Tag No in empty Cells

2011-01-16 Thread ashish koul
).Value Sheets(Sheet2).Cells(i, 10).Value = Sheets(Sheet2).Cells(i - 1, 10).Value Sheets(Sheet2).Cells(i, 11).Value = Sheets(Sheet2).Cells(i - 1, 11).Value End If Next i End Sub On Sun, Jan 16, 2011 at 8:39 PM, ashish koul koul.ash...@gmail.com wrote: Sub Macro1() Dim i As Long

Re: $$Excel-Macros$$ How do you identify row number and column number of active cell?

2011-01-14 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Extract data between two dates

2011-01-13 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin

Re: $$Excel-Macros$$ IF two criteria then count occurrences of TRUE

2011-01-13 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Offset Range Copy

2011-01-13 Thread ashish koul
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul

Re: $$Excel-Macros$$ Offset Range Copy

2011-01-13 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Formula of the week - share your best formula

2011-01-13 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Clear Contents based on another cell value

2011-01-12 Thread ashish koul
follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

Re: $$Excel-Macros$$ Want a formula that find the value as positive or pending as per horizontal and vertical.

2011-01-10 Thread ashish koul
Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul

Re: $$Excel-Macros$$ Can the filter criteria come from the value of a cell?

2011-01-10 Thread ashish koul
, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ How to assign macro to an Active X Controls Command Button

2011-01-09 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile

Re: $$Excel-Macros$$ Fwd: need help

2011-01-08 Thread ashish koul
/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Multiple Selection of cells copying the same using macro

2011-01-07 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread ashish koul
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

Re: $$Excel-Macros$$ Help Required

2011-01-06 Thread ashish koul
. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-05 Thread ashish koul
page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

2011-01-05 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread ashish koul
email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Copy files in folder except one file

2011-01-05 Thread ashish koul
/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

2011-01-03 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http

Re: $$Excel-Macros$$ APIs in Excel Macros

2011-01-03 Thread ashish koul
=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ APIs in Excel Macros

2011-01-03 Thread ashish koul
http://www.applecore99.com/api/api001.asp On Tue, Jan 4, 2011 at 8:44 AM, ashish koul koul.ash...@gmail.com wrote: check out these links see if it helps you http://www.informit.com/articles/article.aspx?p=366892# http://it.toolbox.com/blogs/sap-bi-blog/using-bex-analyzers-api-via-vba

Re: $$Excel-Macros$$ Top poster of the Month- Dec'10 : Ashish Koul

2011-01-01 Thread ashish koul
welcome ayush, happy new year to you and everyone in the group... On Sat, Jan 1, 2011 at 1:37 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very happy to announce that Ashish Koul is the top poster for the month of Dec'10. He has topped with 37 posts this month. Ashish

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread ashish koul
b is column no 2 g is column no 7 target.row will select the row On Thu, Dec 30, 2010 at 1:39 PM, ashish koul koul.ash...@gmail.com wrote: **Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread ashish koul
B to G (not want to lock entire row) than what will the code. I want to understand the diff in codes. :) Thanks once again for your help. Regds, Manish On Dec 30, 10:31 am, ashish koul koul.ash...@gmail.com wrote: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread ashish koul
://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

$$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

2010-12-30 Thread ashish koul
*Wishing you all Very happy and prosperous New Year* -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

Re: $$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

2010-12-30 Thread ashish koul
. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul

Re: $$Excel-Macros$$ insert a sheet into right side short cut?

2010-12-29 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-29 Thread ashish koul
To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

Re: $$Excel-Macros$$ Formula required to find the highest lowest values in each month

2010-12-26 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com

$$Excel-Macros$$ Wishing you all Merry Christmas ! ..

2010-12-24 Thread ashish koul
Wishing you all Merry Christmas ! .. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Run a macro every time excel is opened

2010-12-18 Thread ashish koul
. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-18 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-17 Thread ashish koul
://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think

$$Excel-Macros$$ Fwd: VBA/MSAccess Developers Required. Job Location: Gurgaon( see if anyone interested)

2010-12-17 Thread ashish koul
if the above opportunity is suitable Regards Samatha 9901999156 k.sama...@samcomm.com www.samcomm.com *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P

$$Excel-Macros$$ Fwd: Hiring Reporting- Data Analyst for GLobal Leader ( if anyone interested )

2010-12-17 Thread ashish koul
To apply against the above opening kindly send across your updated resume at (ades...@spectral.in) For more details please call Adesh @ 9911669600 Regards! Team HR, Spectral Consultants www.spectral.in -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

$$Excel-Macros$$ Fwd: Urgent Requirement of VBA Programmer ( if anyone interested )

2010-12-17 Thread ashish koul
Management Service F-210, IInd Floor, M B Road, Lado Sarai, New Delhi - 110030 Phone: 011-42664189 Fax: 011-41014181 Mail- he...@vcmsindia.com, URL: www.vcmsindia.com *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

$$Excel-Macros$$ Fwd: VBA Macros_Bangalore ( if anyone interested )

2010-12-17 Thread ashish koul
/ShowRegistrationForm Sponsored LinksTry visual studio 2008. It's Freehttp://clk.atdmt.com/INM/go/127861030/direct/01/ -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul

$$Excel-Macros$$ URgent Opening_VBA Developer ( if anyone interested )

2010-12-17 Thread ashish koul
CV.Please mention your Current CTC : Expected Salary : Be modest while writing your expectations -- Regards Deepika Sharma 9560800034 Executive Sourcing Stepup Services www.stepupservices.in -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com

$$Excel-Macros$$ Fwd: VBA/MSAccess Developers Required. Job Location: Gurgaon ( if anyone interested )

2010-12-17 Thread ashish koul
/ -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Missing Entries

2010-12-16 Thread ashish koul
link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before

Re: $$Excel-Macros$$ Problem regarding sum

2010-12-16 Thread ashish koul
follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830

Re: $$Excel-Macros$$ Need to find the second to final row in order to copy detail lines

2010-12-16 Thread ashish koul
To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

Re: $$Excel-Macros$$ need help for insert .swf signature into outlook mail signature

2010-12-14 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Need help to get the collection date with the help of formula

2010-12-14 Thread ashish koul
, Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400

<    7   8   9   10   11   12   13   14   >