ge 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@googlegrou
ACROS" 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 more o
ase
> 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 security
> measure.
>
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,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma
--
Are you =EXP(E:RT) or =NOT(EXP(
re 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
ncise, 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 another member.
> 3) Don't po
m 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,
An
; group.
>>> To unsubscribe from this group and stop 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.c
l 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 it, send an
or use this one.
http://msdn.microsoft.com/en-us/library/office/aa141422%28v=office.10%29.aspx
On Thu, Feb 13, 2014 at 6:00 PM, Anoop K Sharma wrote:
> There is a recordset property which lock the data while reading it through
> query.
>
>
> On Thu, Feb 13, 2014 at 5:41 PM, Kei
-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/groups/opt_out.
>
--
Regards,
Anoop
Sr. Developer
Facebook ID -
> "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.googl
> 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 post confidential data i
Hi Rob,
>> To solve the problem of error, you can delete this (
>> Sheets("List3").Select ), it will not affect the main macro.
>>
>> Basole
>>
>>
>>
>>
>> 2014/1/24 Rob Flott
>>
>>> Anoop,
>>>
>>> W
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/groups/opt_out.
>
--
Regards,
Anoop
Sr
to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma
--
Are you =EXP(E:RT) or =N
r 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 received this message because you are su
re 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
, 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 security
> measure.
> 4) Ackn
..@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/groups/opt_out.
>
--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www
shrini check this
http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html
On Wednesday, 20 November 2013 17:10:46 UTC+5:30, shrini wrote:
>
> Dear All
> Please find attached query.
> Is it possible to write aformula as per my requirement
>
> --
> Shrini
>
--
Are you =EXP(E:RT) or =NO
check this prabhu
http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html
On Sunday, 24 November 2013 11:32:00 UTC+5:30, Prabhu Pinky wrote:
>
> Hi Experts,
>
> How to do vlookup in VBA. i have two sheets saved in different locations.
>
> i need to do vlookup in sheet1 by referring anoth
you can try conditional formatting option, like select the columns you want
to compare or find duplicates. and go to conditional formatting highlight
the duplicate cell it will give the correct answer.
for Excel Automation visit www.excelautom
check www.excelautomate.blogpsot.in
On Wednesday, 11 December 2013 21:22:04 UTC+5:30, Brian Keith wrote:
>
> I am copying an image to an Excel worksheet, and then sizing to the scale
> I want and placing it where I want the image to show up in the worksheet
> upon printing. What happens though i
please see this site about how to write excel formulas
http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html
On Friday, 13 December 2013 05:31:13 UTC+5:30, Troy Nieto wrote:
>
> I want to display in E8 "Complete" if D8 has a strikthrough format in the
> cell, otherwise
http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html
--
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 tit
http://excelautomate.blogspot.in/2013/12/introduction-array-formulas-are.html
--
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, accura
http://excelautomate.blogspot.in/2013/12/calling-worksheet-functions-from-vba.html
--
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, a
http://excelautomate.blogspot.in/2013/11/10-quick-time-saving-excel-shortcuts.html
--
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, a
http://excelautomate.blogspot.in/2013/12/introduction-to-defined-names.html
--
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
http://excelautomate.blogspot.in/2013/12/declaring-variables.html
--
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 ti
http://excelautomate.blogspot.in/2013/12/introduction-event-programming-is-very.html
--
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,
http://excelautomate.blogspot.in/2013/12/optimizing-vba-code.html
--
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 ti
Matt, check my blog.. i have given simple way to create macros and excel
tricks
www.excelautomate.blogspot.in
On Wednesday, 4 December 2013 02:31:44 UTC+5:30, Matt Watson wrote:
>
>
>
> Hello all, joined this group today.
>
> I like to think I'm quite handy with excel, but the uses are so broad I
check this
http://excelautomate.blogspot.in/2013/11/sending-email-from-excel-using-vba.html
On Monday, 9 December 2013 18:13:22 UTC+5:30, Chethan wrote:
>
> I have to send excel as attachment to end user. But using different
> account. Like using "from" as a "Common I'd"
>
--
Are you =EXP(E:R
check this
http://excelautomate.blogspot.in/2013/12/date-functions.html
On Monday, 9 December 2013 18:20:30 UTC+5:30, rudi ansyah wrote:
>
> untuk merubah format waktu misalnya 01 - des - 2011, tidak bisa berubah ke
> 01 - 12 - 11, mohon bantuannya.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:R
>
> 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 gr
egroups.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/groups/opt_out.
>
--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.f
BA 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.
http://excelautomate.blogspot.in/2013/12/what-is-spreadsheet-application.html
On Tuesday, 3 December 2013 19:00:19 UTC+5:30, anoop kumar wrote:
>
> Why Excel Is Great for Developer's
> Check it out
>
> http://excelautomate.blogspot.in/2013/12/why-excel-is-great-for-developers
Why Excel Is Great for Developer's
Check it out
http://excelautomate.blogspot.in/2013/12/why-excel-is-great-for-developers.html
--
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
http://excelautomate.blogspot.in/2013/11/a-brief-history-of-spreadsheets.html
--
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, accura
History of Spreadsheets...
Check it out
http://excelautomate.blogspot.in/2013/11/a-brief-history-of-spreadsheets.html
On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote:
>
> Hi webies,
>
> I just started blogging, please check the excel aut
Guys,
Want to know how check it out
http://excelautomate.blogspot.in/2013/11/sending-email-from-excel-using-vba.html
Thanks,
Anoop Kumar.V
--
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
Hi Dawns,
Check http://excelautomate.blogspot.in/ for more excel tricks
On Saturday, 21 September 2013 18:44:29 UTC+5:30, DawnS wrote:
>
> This is not actually a question but just a big THANKYOU to the three
> responses to by prob. Thanks heaps guys! The key just below Esc combined
> with Cont
check here..
http://excelautomate.blogspot.in/2013/11/function-to-find-unique-items-in-list.html
On Wednesday, 16 October 2013 20:29:51 UTC+5:30, Excel ka Keeda wrote:
>
> Dear Exterts,
>
> I am stuck in my project and need your expert advice that ho can i prevent
> duplicate data entry in any c
Hi Howard,
check this site for learning simple macros in easy ways...
http://excelautomate.blogspot.in
On Sunday, 27 October 2013 08:26:00 UTC+5:30, Howard Rambin wrote:
>
> I am new to macros in Excel (wiz at lotus keyboard macros).
>
> I don't have not problem recording a simple print macro wit
Check VBA's most useful built in functions
http://excelautomate.blogspot.in/2013/11/vbas-most-useful-built-in-functions.html
On Thursday, 7 November 2013 11:13:59 UTC+5:30, rutuja patekar wrote:
>
> I am taking data from one workbook and finding the same data in different
> workbook.
>
> I am usi
Hi Rajan,
Please check here to understand Excel formulas in detail.
http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html
On Monday, 11 November 2013 15:42:14 UTC+5:30, Rajan sharma wrote:
>
> Dear experts,
>
> I have wrote formula in the attached file, but throwing e
Hi Excel Fans,
My self Anoop Kumar, working as a automation tester. I'm using Excel for my
automation activities such as mainframe validation, job submitting,
internet explorer automation, report automation etc.
Want to know more about automation visit my blog :
www.excelautomate.blogsp
Hi Jadhav,
Please check here for formats
http://excelautomate.blogspot.in/2013/11/using-custom-format-for-numbers-dates.html
On Monday, 18 November 2013 12:23:35 UTC+5:30, Prafull Jadhav wrote:
>
> Dear All,
>
> Good Afternoon !
> I have one small query regarding date format .
> Daily i am gett
Hi Mickey,
Check these posts for more about hyperlinks
http://excelautomate.blogspot.in/2013/11/how-to-create-hyperlinks-in-multiple.html
and creating dropdown list of hyper links
http://excelautomate.blogspot.in/2013/11/drop-down-list-of-hyperlinks.html
On Friday, 22 November 2013 03:31:49 UTC+
Good Evening Dharam,
Please check this blog for simple way of creating VBA macros and functions.
www.excelautomate.blogspot.in
On Sunday, 24 November 2013 10:12:30 UTC+5:30, Dharm Pd wrote:
>
>
>
> Dear All,
>
> I work in Excel from last 8 years and understand almost all function of
> Excel but
Hi,
I need to automate a web application, i can pick the HTML Elements and set
the values. But I am unable to send the keys like "ENTER","TAB" into
Internet Explorer.
I tried different types of send keys options
Please help me with answeres
With T
Guys check the most important built-in functions in VBA...
http://excelautomate.blogspot.in/2013/11/vbas-most-useful-built-in-functions.html
Good night
On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote:
>
> Hi webies,
>
> I just started blogging, please che
http://excelautomate.blogspot.in/2013/11/10-quick-time-saving-excel-shortcuts.html
check for excel short cuts
On Saturday, 23 November 2013 14:42:18 UTC+5:30, anoop kumar wrote:
>
> Introduction to VBA programming...guys please check it out
>
> http://excelautomate.blogspot.in/
On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote:
>
> Hi webies,
>
> I just started blogging, please check the excel automation blog
> www.excelautomate.blogspot.in...
> please share your comments and more information about excel macros...
>
>
Introduction to VBA programming...guys please check it out
http://excelautomate.blogspot.in/2013/11/what-is-vba-writing-your-first-vba.html
On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote:
>
> Hi webies,
>
> I just started blogging, please check the excel aut
sfully been created and
> distributed", vbInformation
>
>
> End If
>
> Next i
>
> End With
>
> End Sub
>
>
>
> --
> 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
Please post your questions also
On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote:
>
> Hi webies,
>
> I just started blogging, please check the excel automation blog
> www.excelautomate.blogspot.in...
> please share your comments and more information
Hi webies,
I just started blogging, please check the excel automation blog
www.excelautomate.blogspot.in...
please share your comments and more information about excel macros...
With Thanks,
Anoop.V
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:O
gt; Just what the doctor ordered. Thank you very much Dr. Anoop.
>>>
>>> Much appreciated.
>>>
>>>
>>>
>>> On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote:
>>>
>>>> Hi Bill,
>>>>
>>>
ge 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@googlegroup
Sum column / count column with in pivot table, Is it possible?
> Thanks & Regards,
> Sandeep Kumar Chhajer
> Mumbai
> India
>
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Anoop K Sharma
> *Sender: * excel-macros@googlegroups.com
orkbook. 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
> email to e
legroups.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/groups/opt_out.
>
--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.faceb
> 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/groups/opt_out.
>
--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anoo
r 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
PFA updated with little change as described above.
On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma wrote:
> As Requested, PFB the solved one.
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote:
>
As Requested, PFB the solved one.
Regards,
Anoop
Sr. Developer
On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote:
> please share the example
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur <
&g
x27;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
s 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/groups/opt_out.
>
--
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 http://gro
r, I don't Know Why because in access the Query works perfectly.
>>>>>>>
>>>>>>> Best Regards,
>>>>>>>
>>>>>>> *Michael*
>>>>>>>
>>>>>>> --
>>>>>>&g
allowed by SQL.
> Rich
> On Sep 19, 2013 10:21 PM, "Anoop K Sharma" wrote:
>
>> Hi Richard,
>>
>> Your query is not clear enough. Varchar is a reserved word for sql. are
>> you using max function for getting maximum value of a column?
>>
>>
Hi Richard,
Your query is not clear enough. Varchar is a reserved word for sql. are you
using max function for getting maximum value of a column?
If possible, please share your file..
Regards,
Anoop
Sr. Developer
On Thu, Sep 19, 2013 at 9:42 PM, Richard wrote:
> I have created an MS Qu
CROS" 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
>>>> 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 another member.
>>>>> 3) Don't post questions regarding
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
nsible 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.
his 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.go
om 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 https://groups.google.co
u 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 received t
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 m
Hey,
Use the Attached one... I can see the code written here a little bit
slow... it can be made faster if I could get your database
structure...
Thanks,
Anoop
Sr. Developer
On 8/9/13, Lalit Mohan Pandey wrote:
> Replace line
>
> *Erow = Me.Range(A1).End(xlDown).row + 1*
>
>
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) Jobs posting is not allowed.
e 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 at h
d 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-macr
ge 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.com.
>
g 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 y
Change the path
highlighted below.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveC
d (if you think it is required). Hide this back up
file by changing its properties. This will keep creating backup file in
same folder where your original one is located but it can't be seen as you
will hide it.
On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal wrote:
> Hi Anoop
>
> I d
legroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:R
his 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-macro
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
> email to
> excel-macros+u
cel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma
--
Are you =EXP(E:RT) or =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?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Regards,
hted 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 MAC
Try this
Sub proc_FindDate()
Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65000").End(xlUp).Row)
myVal = "N/A"
With rng
Set fndVal = .Find(myVal, LookIn:=xlValues) 'myVal is the date
to be found
If Not fndVal Is Nothing Then
frstAdd = fndVal.Address
Do
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.com.
>
1 - 100 of 172 matches
Mail list logo
