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

2016-11-04 Thread Ashish Koul
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 stop receiving emails from it, send an > email to excel-macros+unsubscr...@googleg

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

2016-09-16 Thread Ashish Koul
st 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 on Facebook <

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

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

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

2016-04-11 Thread Ashish Koul
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 wrote: > >> after match wht u wanna do highligh

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

2016-04-11 Thread Ashish Koul
d material and their links is not allowed. > > 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. &

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 wrote: > Hi Ashish, > > This is not working.It is giving 0 value. > > Regards, > Pooja Sharma > On 21 Mar 2016 19:30, "Ashish Koul" wrote: > >> =VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),

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

2016-03-21 Thread Ashish Koul
oups.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 Li

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

2016-03-19 Thread Ashish Koul
ed material and their links is not allowed. > > 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 M

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

2015-12-26 Thread Ashish Koul
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://group

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
his 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 Facebook <https://ww

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

2015-11-27 Thread ashish koul
ribed 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 post to this group, send email to excel-macros@googlegroups.com. > Visit this group

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 ) > but i am not able to sho

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

2015-11-12 Thread ashish koul
om 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*

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

2015-11-11 Thread ashish koul
ed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message

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

2015-11-10 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*

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

2015-11-01 Thread ashish koul
d 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 post to this group, send email to excel-macros@googlegroups.com. > Visit this group

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

2015-10-10 Thread ashish koul
d 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 Kou

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

2015-09-26 Thread ashish koul
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 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, 2015 at 9:20:05 AM

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

2015-08-26 Thread ashish koul
ou 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 post to this group, send email to excel-macros@googlegroups.com. > Visit

Re: $$Excel-Macros$$ Excel Dashboard

2015-08-24 Thread ashish koul
eceiving 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. >

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
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 http://groups.google.com/group/excel-macros. > For more options,

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

2015-07-27 Thread ashish koul
run the code only when cell k2 is changed to a yes or no. > > thanks again. > > Sent by Outlook <http://taps.io/outlookmobile> for Android > > > > On Mon, Jul 27, 2015 at 5:13 AM -0700, wrote: > > its perfect! thanks a lot... :) > > Sent by Outlook <

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

2015-07-27 Thread ashish koul
d. > > 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 fr

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

2015-07-09 Thread ashish koul
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 stop receiving emails from

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

2015-06-03 Thread ashish koul
gt; 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 Facebo

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

2015-06-03 Thread ashish koul
u 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 post to this group, send email to excel-macros@googlegroups.com. > Vi

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

2015-05-27 Thread ashish koul
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 http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/o

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

2015-05-27 Thread ashish koul
L 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 http://groups.google.com/group/excel-m

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

2015-05-16 Thread ashish koul
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 stop rec

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

2015-05-14 Thread ashish koul
roup, 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.

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

2015-04-13 Thread ashish koul
ps.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 Fac

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

2015-02-23 Thread ashish koul
t line = line & delimittype & arr(j, i) Next 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 wrote: > Do you wa

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

2015-02-23 Thread ashish koul
use 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 post to this group, send email to excel-macros@googlegroups.com. > V

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

2015-02-13 Thread ashish koul
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://ww

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

2015-02-13 Thread ashish koul
rom 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* *As

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

2015-01-10 Thread ashish koul
gt; "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 http

Re: $$Excel-Macros$$ Need Help

2014-12-24 Thread ashish koul
ntion or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted

Re: $$Excel-Macros$$ VBA

2014-08-15 Thread ashish koul
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 http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d

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

2014-06-28 Thread ashish koul
ssing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and >

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

2014-06-24 Thread ashish koul
se 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 post to this group, send email to excel-macros@googlegroups.com. > Visit th

Re: $$Excel-Macros$$ Macro Help

2014-06-07 Thread ashish koul
gt; > > On Fri, Jun 6, 2014 at 10:13 AM, ashish koul > 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

Re: $$Excel-Macros$$ Macro Help

2014-06-05 Thread ashish koul
t 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 stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. >

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

2014-06-01 Thread ashish koul
t;> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any sec

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

2014-06-01 Thread ashish koul
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of a

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

2014-06-01 Thread ashish koul
ks is not allowed. > > 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 un

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

2014-06-01 Thread ashish koul
is not allowed. > > 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

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

2014-06-01 Thread ashish koul
J6:j9").Copy Destination:=ThisWorkbook.Sheets(1).Cells(2, i) wkb.Close , False End Sub On Sun, Jun 1, 2014 at 12:36 PM, ashish koul wrote: > ok wait 2 min > > > On Sun, Jun 1, 2014 at 12:34 PM, Michael Lovin wrote: > >> office 2010 >> >> &g

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

2014-06-01 Thread ashish koul
;>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get

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

2014-05-31 Thread ashish koul
gt; 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever

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

2014-05-31 Thread ashish koul
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 http://groups.google.com/group/excel-macros. > For mo

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

2014-05-13 Thread ashish koul
e 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 stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.c

Re: $$Excel-Macros$$ Graph Query

2014-05-09 Thread ashish koul
ails 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

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

2014-04-30 Thread ashish koul
allowed. > 6) Sharing copyrighted material and their links is not allowed. > > 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

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

2014-04-30 Thread ashish koul
use > exit for as soon as condtion is met - That would be an excellent > addition, but It would still be great to eliminate all the hidden rows from > the compare. > > Also is it possible for you to share a sample file with dummy data - I've > attached my tiny test file, but un

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

2014-04-30 Thread ashish koul
omation Expert) Contact: +91-399977* >>>> >>>> ……... >>>> >>>> *"It's Never Too Late To Follow Your Dreams"* >>>> >&g

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 wrote: > For whatever reasons the size of my ActiveX ListBox expands and shrinks on > an inconsistent basis forcing me to use the Forms ListBox i

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

2014-04-21 Thread ashish koul
"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 http://groups.google.c

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

2014-04-18 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/exc

Re: $$Excel-Macros$$ Additional Control

2014-04-18 Thread ashish koul
. > 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 http://groups.google.com/group/excel-macros. > For more opti

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
, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5)

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

2014-04-11 Thread ashish koul
roup, 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<http://www.

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

2014-04-10 Thread ashish koul
r bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > membe

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

2014-04-10 Thread ashish koul
t; On Apr 10, 2014, at 3:15 AM, ashish koul 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 wrote: > >> >> >> Here is what I'

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 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:2

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

2014-04-10 Thread ashish koul
Fexcel%2Fdownloadfile.aspx&h=TAQEit-rd&enc=AZMLNgnrGp9ggxRiSuOJgUHMUCMa4SNXrgVisQk6U6ARpgZeEBLxWw5Sx8-z67s2RYilxKHosxGcUVcrgIDUUOQWpb82ECeR6UWfNwmrADeYx2dP6SgHDr6E25Id8XF8Ntuoeu_ikMOXRWZjTC0b3pxj&s=1> Dim sURL As String Dim LocalFilename As String Dim filename As String Const folder_na

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

2014-04-10 Thread ashish koul
ost 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<ht

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

2014-04-08 Thread ashish koul
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 http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.

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

2014-04-08 Thread ashish koul
edge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You r

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 wrote: > Hi Matt, > > Please try this addin > > > > On Tue, Apr 8, 2014 at 11:25 PM, Matt Watson wrote: > >> I have a formula and macro rich workbook. It has about 21 worksheets that >> I work in. I mostly

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

2014-04-08 Thread ashish koul
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 post to this group, send email to excel-mac

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

2014-04-07 Thread ashish koul
le 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 post to this g

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

2014-04-05 Thread ashish koul
ibe 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 http://groups.google.com/group/excel-macros. > For more options, visit

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

2014-04-05 Thread ashish koul
ups > "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 http:

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

2014-04-05 Thread ashish koul
l 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<http://www.facebook.com/pages/Ex

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

2014-04-05 Thread ashish koul
#x27;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 stop receiving email

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

2014-04-05 Thread ashish koul
n > 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* *Ash

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

2014-04-05 Thread ashish koul
oglegroups.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<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/151803898

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

2014-04-02 Thread ashish koul
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 post to this group, send email to excel-macros@googlegroups.com.

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

2014-04-02 Thread ashish koul
> measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not respon

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

2014-04-01 Thread ashish koul
up. > 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 http://groups.google.com/group/excel-macros. > For more option

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

2014-03-30 Thread ashish koul
aring copyrighted material and their links is not allowed. >>> >>> 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 t

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

2014-03-30 Thread ashish koul
a 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 stop receiving emails from it, send an > e

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

2014-03-30 Thread ashish koul
roup 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 http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google

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(folderpat

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

2014-03-29 Thread ashish koul
t;>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> Regards, >

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

2014-03-29 Thread ashish koul
Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. >

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

2014-03-29 Thread ashish koul
eived 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 post to this group, send email to e

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

2014-03-23 Thread ashish koul
d or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any los

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

2014-03-21 Thread ashish koul
l and their links is not allowed. > > 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" gr

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

2014-03-20 Thread ashish koul
roup, 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. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

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

2014-03-16 Thread ashish koul
> > 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 g

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

2014-03-16 Thread ashish koul
/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread ti

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

2014-03-16 Thread ashish koul
; 6) Sharing copyrighted material and their links is not allowed. > > 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 > "

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

2014-03-16 Thread ashish koul
then try left and find function combined On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai wrote: > Yes Ashish... > > > On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote: > >> is ACT common in all >> >> >> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai

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

2014-03-16 Thread ashish koul
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 http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com

Re: $$Excel-Macros$$ formatar colunas com especificidade melhor

2014-03-16 Thread ashish koul
cel-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<http://www.facebook.com/pages/Excel-VBA-Code

Re: $$Excel-Macros$$ query2

2014-03-16 Thread ashish koul
sage 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 post to this group, send email to excel-macros@googlegroups

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

2014-03-15 Thread ashish koul
el-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<http://www.facebook.com/pages/Excel-VBA-

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

2014-03-15 Thread ashish koul
p. > 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 http://groups.google.com/group/excel-macros. > For more opt

  1   2   3   4   5   6   7   8   9   10   >