Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

2016-11-04 Thread Ashish Koul
sible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To

Re: $$Excel-Macros$$ Query on formula

2016-09-16 Thread Ashish Koul
ps.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Ashish Koul
y way of to put it across like > > *Dim wordto find as string wordtofind=*" " > , thanks > On Monday, April 11, 2016, Ashish Koul <koul.ash...@gmail.com> wrote: > >> Sub sample() >> 'https://msdn.microsoft.com/en-us/library/office/ff839746.aspx >> Dim

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Ashish Koul
ular word so for example if there is a > word retail in multiple columns and rows it should be highlighted with > yellow color everywhr , only that word not a cell row or column, thanks > > > On Monday, April 11, 2016, Ashish Koul <koul.ash...@gmail.com> wrote: > >> after mat

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Ashish Koul
t; > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and sto

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

2016-03-21 Thread Ashish Koul
see attachment On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma <vatspoojav...@gmail.com> wrote: > Hi Ashish, > > This is not working.It is giving 0 value. > > Regards, > Pooja Sharma > On 21 Mar 2016 19:30, "Ashish Koul" <koul.ash...@gmail.com> wrote: &g

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

2016-03-21 Thread Ashish Koul
unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish Koul* *Visit* http://www.

Re: $$Excel-Macros$$ VBA to save each page of a mail merge document seperately

2016-03-19 Thread Ashish Koul
AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > F

Re: $$Excel-Macros$$ Assigning names to sheet

2015-12-26 Thread Ashish Koul
gle Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https:

Re: $$Excel-Macros$$ Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

2015-12-23 Thread Ashish Koul
this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Faceboo

Re: $$Excel-Macros$$ PERSONAL MACRO WORKBOOK

2015-11-27 Thread ashish koul
this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook <https://www.facebook.com/excelvbacodes> Join Us on Facebook <http://w

Re: $$Excel-Macros$$ excel-VBA-GEarth integrated but not able to display name for placemark through VBA,Plz HELP

2015-11-27 Thread ashish koul
Share the sample file On Nov 27, 2015 1:41 PM, "shilpag" wrote: > Hi > I have developed a small desktop application with excel data which > will be displayed on to Google Earth by VBA code. > The google earth is displaying coordinates (values are looped by macro )

Re: $$Excel-Macros$$ Combine Name then Time and date stamp for reference number

2015-11-12 Thread ashish koul
> email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish

Re: $$Excel-Macros$$ Macro to populate a column with data from another column

2015-11-10 Thread ashish koul
it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regard

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-01 Thread ashish koul
the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit th

Re: $$Excel-Macros$$ How to do a summary of a large table

2015-10-10 Thread ashish koul
t, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *

Re: $$Excel-Macros$$ Filter rows with com

2015-09-26 Thread ashish koul
> To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Face

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

2015-09-12 Thread ashish koul
Can u pls share a sample file On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" wrote: > Thank you Basole for your message! > I have been already using your recommendation on my code, but it still > takes a lot of memory. > > Regards, > Isabel > > > > On Saturday, September 12,

Re: $$Excel-Macros$$ Macro to strip LinkedIn Company Page Followers.

2015-08-26 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https

Re: $$Excel-Macros$$ Excel Dashboard

2015-08-24 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http

Re: $$Excel-Macros$$ To seek help on fuzzy text matching of list of 30000 text values from a list of 300000 text values

2015-08-14 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

2015-07-27 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

2015-07-27 Thread ashish koul
email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes

Re: $$Excel-Macros$$ is it possible to reduce this sorting code

2015-07-09 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook

Re: $$Excel-Macros$$ Query (Outlook VBA)

2015-06-03 Thread ashish koul
. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about

Re: $$Excel-Macros$$ Macro to print first spreadsheet as PDF

2015-06-03 Thread ashish koul
+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us

Re: $$Excel-Macros$$ How To: Email macros to another user?

2015-05-27 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http

Re: $$Excel-Macros$$ Outlook Signature Problem using VBA

2015-05-27 Thread ashish koul
-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook

Re: $$Excel-Macros$$ Count if in an active status

2015-05-16 Thread ashish koul
://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you

Re: $$Excel-Macros$$ Count if in an active status

2015-05-14 Thread ashish koul
. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ Assistance with Dynamic Dashboard reporting

2015-04-13 Thread ashish koul
it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit

Re: $$Excel-Macros$$ Converting excel files to .txt format with delimiter comma

2015-02-23 Thread ashish koul
delimittxt.WriteLine Right(line, Len(line) - 1) Next delimittxt.Close Set delimittxt = Nothing Set fs = Nothing End Sub see if it helps On Mon, Feb 23, 2015 at 9:47 PM, ashish koul koul.ash...@gmail.com wrote: Do you wanna export range in comma delimit text file?. On Mon, Feb 23, 2015

Re: $$Excel-Macros$$ Converting excel files to .txt format with delimiter comma

2015-02-23 Thread ashish koul
. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https

Re: $$Excel-Macros$$ Re: Run time error...

2015-02-13 Thread ashish koul
* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ How to set a default in Page setup Sheet

2015-01-10 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook

Re: $$Excel-Macros$$ Need Help

2014-12-24 Thread ashish koul
-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think

Re: $$Excel-Macros$$ VBA

2014-08-15 Thread ashish koul
. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http

Re: $$Excel-Macros$$ How to remove vb code after you make a copy

2014-06-28 Thread ashish koul
* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Help with 5 line charts from one pivot table

2014-06-24 Thread ashish koul
-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook

Re: $$Excel-Macros$$ Macro Help

2014-06-07 Thread ashish koul
6, 2014 at 10:13 AM, ashish koul koul.ash...@gmail.com wrote: Try this Private Sub Worksheet_Change(ByVal Target As Range) Dim arr, i As Long arr = Range(a2:d Range(a65356).End(xlUp).Row - 1) 'On Error GoTo err: Application.EnableEvents = False If Target.Count 1 Then Application.Undo

Re: $$Excel-Macros$$ Macro Help

2014-06-05 Thread ashish koul
email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Coloms in many workesbooks to rows in a master workbook?

2014-05-31 Thread ashish koul
https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP

Re: $$Excel-Macros$$ Here is a Great Challenge - Retrieve data in from a multiple urls in one step

2014-05-13 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us

Re: $$Excel-Macros$$ Graph Query

2014-05-09 Thread ashish koul
. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com

Re: $$Excel-Macros$$ Re: VBA Compare only visible rows

2014-04-30 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http

Re: $$Excel-Macros$$ VBA Compare only visible rows

2014-04-30 Thread ashish koul
for you to share a sample file with dummy data - I've attached my tiny test file, but unfortunately due to sensitive information I can't attach the large master list. Hope this helps clarify for you. Ben Regards Ashish koul On Wednesday, April 30, 2014 11:56:06 AM UTC-7, ashish wrote

Re: $$Excel-Macros$$ Is there any way to change the font with the Forms - ListBox?

2014-04-29 Thread ashish koul
Hi Try this way http://www.jkp-ads.com/articles/Excel2007FileFormat01.asp Regards Ashish Koul On Tue, Apr 29, 2014 at 9:32 PM, Rob Flott robfl...@gmail.com wrote: For whatever reasons the size of my ActiveX ListBox expands and shrinks on an inconsistent basis forcing me to use the Forms

Re: $$Excel-Macros$$ Re: Additional Control

2014-04-21 Thread ashish koul
at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups

Re: $$Excel-Macros$$ Additional Control

2014-04-18 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages

Re: $$Excel-Macros$$ Out Of Office

2014-04-18 Thread ashish koul
emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish

Re: $$Excel-Macros$$ Re: Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

2014-04-16 Thread ashish koul
. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp

Re: $$Excel-Macros$$ Need a help on sumproduct for MTD data

2014-04-11 Thread ashish koul
://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment

Re: $$Excel-Macros$$ Specific dates Grouping(urgent) excel or vba

2014-04-10 Thread ashish koul
. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Need VBA Code to extract pdf file from URL.

2014-04-10 Thread ashish koul
-rdenc=AZMLNgnrGp9ggxRiSuOJgUHMUCMa4SNXrgVisQk6U6ARpgZeEBLxWw5Sx8-z67s2RYilxKHosxGcUVcrgIDUUOQWpb82ECeR6UWfNwmrADeYx2dP6SgHDr6E25Id8XF8Ntuoeu_ikMOXRWZjTC0b3pxjs=1 Dim sURL As String Dim LocalFilename As String Dim filename As String Const folder_name = C:\Documents and Settings\Ashish Koul\Desktop

Re: $$Excel-Macros$$ What am I missing????

2014-04-10 Thread ashish koul
ignore the previous one and try ths one =SUM(OFFSET(A3,0,0,1,MATCH(ReportPeriod,$A$1:$M$1,0))) On Thu, Apr 10, 2014 at 7:30 PM, ashish koul koul.ash...@gmail.com wrote: try ths not tested but shuld work =SUM(OFFSET(A3,0,1,1,MATCH(ReportPeriod,$A$1:$M$1,0))) On Thu, Apr 10, 2014 at 6:21

Re: $$Excel-Macros$$ What am I missing????

2014-04-10 Thread ashish koul
On Apr 10, 2014, at 3:15 AM, ashish koul koul.ash...@gmail.com wrote: Change your formula in Col P =INDEX($B3:$M3,MATCH(ReportPeriod,$B$1:$M$1,0)) on sheet Data On Wed, Apr 9, 2014 at 9:31 PM, Steve Weaver steveweaver1...@gmail.comwrote: Here is what I'd like to accomplish

Re: $$Excel-Macros$$ Creating UserForm on Upper, Lower and Proper case

2014-04-10 Thread ashish koul
to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes

Re: $$Excel-Macros$$ Can too many calculations corrupt a workbook?

2014-04-08 Thread ashish koul
-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in

Re: $$Excel-Macros$$ Can too many calculations corrupt a workbook?

2014-04-08 Thread ashish koul
Ashish On Tue, Apr 8, 2014 at 11:55 PM, ashish koul koul.ash...@gmail.com wrote: Hi Matt, Please try this addin On Tue, Apr 8, 2014 at 11:25 PM, Matt Watson mattwatson.m...@gmail.comwrote: I have a formula and macro rich workbook. It has about 21 worksheets that I work in. I mostly

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-08 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp

Re: $$Excel-Macros$$ Help to merge text from difference cell

2014-04-08 Thread ashish koul
/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

2014-04-07 Thread ashish koul
. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Help to merge text from difference cell

2014-04-05 Thread ashish koul
from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

2014-04-05 Thread ashish koul
://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

2014-04-05 Thread ashish koul
. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before

Re: $$Excel-Macros$$ Delete button on Sequence Column

2014-04-05 Thread ashish koul
emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul

Re: $$Excel-Macros$$ Macro for copying from a notepad and creating a record in excel

2014-04-05 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us

Re: $$Excel-Macros$$ Show links which to other Data source

2014-04-02 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp

Re: $$Excel-Macros$$ All text box need to be enter

2014-04-02 Thread ashish koul
an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http

Re: $$Excel-Macros$$ Show links which to other Data source

2014-04-01 Thread ashish koul
* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ Save only a few sheets

2014-03-30 Thread ashish koul
. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp

Re: $$Excel-Macros$$ Macro for IF AND condition

2014-03-30 Thread ashish koul
. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP

Re: $$Excel-Macros$$ Re: How to match a combobox result with an textbox

2014-03-29 Thread ashish koul
emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul

Re: $$Excel-Macros$$ How to match a combobox result with an textbox

2014-03-29 Thread ashish koul
https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about

Re: $$Excel-Macros$$ Re: VBA Macro for data split as per the specified format

2014-03-29 Thread ashish koul
email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2014-03-29 Thread ashish koul
Sub test() Dim filenm As String, folderpath As String folderpath = C:\Documents and Settings\Ashish Koul\Desktop\sample files\ filenm = Dir(folderpath) While (filenm ) If InStr(filenm, .doc) 0 Then Call copytables(folderpath filenm) End If filenm = Dir Wend

Re: $$Excel-Macros$$ Re: VBA Macro for data split as per the specified format

2014-03-23 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros

Re: $$Excel-Macros$$ VBA Macro for data split as per the specified format

2014-03-22 Thread ashish koul
an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

2014-03-20 Thread ashish koul
://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

2014-03-17 Thread ashish koul
/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups

Re: $$Excel-Macros$$ query2

2014-03-16 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages

Re: $$Excel-Macros$$ How to convert 1 (numeric value) to One (alpha value)

2014-03-16 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897

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

2014-03-16 Thread ashish koul
-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P

Re: $$Excel-Macros$$ Dynamic Attachment with Email Send

2014-03-16 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join

Re: $$Excel-Macros$$ Help!!(Dashboard)

2014-03-15 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros

Re: $$Excel-Macros$$ Need an address split up formula.....

2014-03-15 Thread ashish koul
-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros

Re: $$Excel-Macros$$ Save an Excel file as XML

2014-03-15 Thread ashish koul
://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

2014-03-10 Thread ashish koul
com o Meio Ambiente, * *antes de imprimir qualquer documento.* 2014-03-08 10:25 GMT-03:00 ashish koul koul.ash...@gmail.com: you can use =HYPERLINK formula. Can you please share a sample file On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos caroline@gmail.com wrote: I have two

Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

2014-03-10 Thread ashish koul
share how output will look like Sent on my BlackBerry(R) from Vodafone -- *From: * ashish koul koul.ash...@gmail.com *Date: *Sun, 9 Mar 2014 22:42:50 +0530 *To: *excel-macrosexcel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Excel Forum available

Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

2014-03-09 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us

Re: $$Excel-Macros$$ IF statements in VBA

2014-03-09 Thread ashish koul
://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups

Re: $$Excel-Macros$$ cell tooltip

2014-03-08 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

2014-03-08 Thread ashish koul
. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP

  1   2   3   4   5   6   7   8   9   10   >