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+unsubscr...@googlegroup
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 https://groups.google.com/group/excel-macros.
> For more optio
ppIE.document.getElementByid("gb_70").Click
End With
End Sub
On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah wrote:
> Thanks Gaurav, but I don't want to navigate I want it to click that button.
> On Aug 25, 2016 6:40 PM, "Gaurav Devrani" wrote:
>
>>
wrote:
> Please suggest solutions... I just started vba crawling
> On Aug 25, 2016 6:17 PM, "Gaurav Devrani" wrote:
>
>> Please disregard my email.
>>
>> On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah wrote:
>>
>>>
>>>
>>&g
rs 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+unsubscr...@googlegroups.com.
>
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
> ema
>
>
> *With regards,**Pravin Gunjal*
> *Mobile: 77100 *
> *97250*
>
>
>
>
> On Wed, Aug 17, 2016 at 4:05 PM, Gaurav Devrani
> wrote:
>
>> Hi Pravin,
>>
>> I think this query was already posted few weeks back. Please check the
>> attachment
understand
your query. If those are multiple excel files , you can also create a loop
on those files using FSO (File system object) and copy that data. Let me
know. Waiting for your response Shrini.
Regards
Gaurav Devrani
On Wed, Aug 10, 2016 at 12:40 AM, Shrinivas Shevde
wrote:
> Dear
you need to
write code to do that process and just paste that data in column A in the
attached file that i sent earlier. you can check that code in case you want
to know about the range where code is running, Let me know if i am not able
to answer your question.
Regards
Gaurav Devrani
8586932754
On
Hi Shrini,
Please check the attached file. Let me know if this does not solve your
query.
Regards
Gaurav Devrani
On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde
wrote:
> Dear all
> I have data in Column A in 1to 6 rows . I want to copy paste in Column F
> but in column F 2 rows are
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-
ial 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"
Hi ,
Please check the attached file.
Regards
Gaurav Devrani
On Wed, Apr 15, 2015 at 3:54 PM, Umar Abeer
wrote:
> Hi Mandeep,
>
> Many thanks. It serves the purpose but is there any way we can use
> index/match or any range formula to achieve the same?
>
> BR
> Aby
>
&
the
data except Pivot. To access pivot table data i need a macro to ask for
password and then only I should be able to get access of pivot. If it does
not make any sense.. Please let me know. i will explain again. Help me
Guys..
--
*Thanks & Regards*
*Gaurav Devrani*
--
Are you =EXP(E:RT
Hi Rameshwari ,
Please check the file. Let me know if it does not work for you.
Regards
Gaurav Devrani
On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari
wrote:
> Hello team,
>
> I stuck with one formula, please help me on this. Formula based on some
> criteria.
>
>
>
>
y, 12 March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote:
>>
>> Hi Mandeep,
>>
>> Please check the attached file. let me know if I am missing something.
>>
>>
>> Regards
>> Gaurav Devrani
>>
>>
>>
>> On Thu, Mar 12, 2015 at 1:43
,LOWER(MID(A1,
>> ROW(INDIRECT("1:"&LEN(A1))),1)),UPPER(MID(A1,ROW(INDIRECT("
>> 1:"&LEN(A1))),1)
>>
>> Cheers!!
>>
>> On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani
>> wrote:
>>
>>> Hi Guys,
>>>
>>
Hi Mandeep,
Please check the attached file. let me know if I am missing something.
Regards
Gaurav Devrani
On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja
wrote:
> Quuery for autofit
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TI
I am
sure that in your code "Index" is referring to the sheet name that you want
to unhide.
Regards
Gaurav Devrani
On Wed, Mar 4, 2015 at 7:34 AM, Yahya Muhammad wrote:
>
> Dears
>
> Any solution, please !
>
> On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad
> wr
Hi Paul,
Thanks for the amazing macro you sent. it worked like a charm.. Thanks
again.
Regards
Gaurav Devrani
On Fri, Feb 27, 2015 at 1:04 AM, Paul Schreiner
wrote:
> Are you wanting a macro made to work like a function?
> Like:
>
> =CaseSwap(A1)
>
> where CaseSwap is:
&
Thanks Paul for your quick reply. Yes I was also trying to create a macro
but Just wanted to confirm before, if that's possible in excel functions.
No worries. I really appreciate your quick response once again. Thank you.
Regards
Gaurav Devrani
On Thu, Feb 26, 2015 at 10:16 PM, Paul Schr
Hi Guys,
I have a query . In this sentence.. "This iS a tEst" .
All Upper case alphabets should be lower case and All Lowercase alphabets
should be in Upper case. Please help me . I want that to be done in excel
formulas.(If thats possible).
Thanks & Regards
Gaurav Devrani
--
Superb Vaibhav. Thanks for sharing this with us.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht wrote:
> Hi.
>
> Very nice...
>
> Thankx & Rgds,
>
> Chandra Singh Bisht
>
>
>
> On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote:
Try this in B5 of sheet2 and drag right.
=IF((COLUMN()-1)<=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),""))
On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani
wrote:
> Yes Sure.. I will get back to you with that formula. No worr
Yes Sure.. I will get back to you with that formula. No worries.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila wrote:
> Hi Gaurav,
>
> Thank you for you help. Quick question, is there a way of using a formula
> instead of a code to do what you have done.
Hi ,
I guess you also want to merge the header cells in sheet 2 for all
entries.. Please refer to this new sheet.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani
wrote:
> HI Enock,
>
> Please check the attached file and let me know if I missed
HI Enock,
Please check the attached file and let me know if I missed something.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila wrote:
> Hi Guys,
>
> I want a formula that populates values in a worksheet, on a single row
> based on two values entered on
okay... Thanks Vaibhav.
On Sat, Feb 14, 2015 at 5:43 AM, Vaibhav Joshi wrote:
> I mean free file..
>
> On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani
> wrote:
>
>> Hi Vaibhav,
>>
>> What is FF? Can you please tell me ? Dont have any idea about that please.
&
Hi Vaibhav,
What is FF? Can you please tell me ? Dont have any idea about that please.
On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi wrote:
> Cheers, also you could have created FF & save it as .doc.
>
>
>
> On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani
> wrote:
>
Cool. :)
On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant
wrote:
> Thaks for the complete answer, it works like a charm!
>
> On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani
> wrote:
>
>>
>> Hi,
>>
>> Please check the file ,
>>
>> On Wed
Hi,
Please check the file ,
On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant
wrote:
> Variables identified as type = "double" should be treated differently in
> order to adjust to a expected format...
>
> On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani
> wrote:
>
&
oups.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.
>
--
Thanks & Regards
Gaurav Devrani
--
Are you =EXP(E:RT) or =NOT(
. Thanks.
Thanks
Gaurav
On Mon, Feb 2, 2015 at 10:04 PM, Anil Gawli wrote:
> Dear Gaurav,
>
> Pls share the file
>
> regards,
> Anil
>
> On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani
> wrote:
> > Can anyone help me on this? I have a specific data and want to send tha
Can anyone help me on this? I have a specific data and want to send that
data to multiple recipients (have around 50 emails) but when i run my
macro. It sends them individually instead of sending in a single Email. So
much time consuming. Is there anyway to get it fixed.(like; Cc, Bcc for 50
or mor
l the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -----
>
>*From:* Gaurav Devrani
> *To:* excel-macros@googlegroups.com
> *S
areness.♣♣♣*
>
>
> On Mon, Feb 2, 2015 at 5:58 PM, Gaurav Devrani
> wrote:
>
>> And Please check the filter again. I guess I dint put that filter on the
>> entire sheet. Please select true values as well and then filter it again.
>> Sorry for the wrong file.
>
And Please check the filter again. I guess I dint put that filter on the
entire sheet. Please select true values as well and then filter it again.
Sorry for the wrong file.
On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani
wrote:
> :)
>
> On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Jos
:)
On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi wrote:
> Great Tip by Gaurav..
>
> On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani
> wrote:
>
>> Please check the attached file, Let me know If I am missing on something.
>> I guess you were trying to copy only those ro
xcel
>
> 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 quick attention or may not be answered.
> 2) Don't post a question in the thread of another
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/optout.
40 matches
Mail list logo
