Hi Vaibhav,
Can You refer any good article where I can understand how to use the
Debugger in VBA ?
On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi wrote:
> Hi Kanwaljit
>
> Any luck?
>
> On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote:
>
>> yes, you an do it...
>>
>>
>>
>> On Thu, Feb 5, 201
Dont know about Superman but I m definitely Salman Khan's fan !! ;)))
Cheers!!
On Sun, Feb 8, 2015 at 10:00 PM, B Sharma wrote:
> Hii Vaibhav,
>
> Happy to know that you are a CA too. That means you are a superman in
> accounting line. Because if a person is qualified CA and have good hands on
Hii Vaibhav,
Happy to know that you are a CA too. That means you are a superman in
accounting line. Because if a person is qualified CA and have good hands on
excel/vba, that means he can do 8 hrs work in just 1 hr.
I am neither a CA nor a VBA expert but have good hands on excel, little bit
of
Thanks !
Any tip on how to the Debugger in VBA ?
On Fri, Feb 6, 2015 at 4:11 PM, Ashu k wrote:
> Hi Mr. Kanwaljeet,
>
> Find the attachment. See the power of VBA.
>
> And try to make this.
>
>
>
> Regards
> Ashu Kenith
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b
Hi Mr. Kanwaljeet,
Find the attachment. See the power of VBA.
And try to make this.
Regards
Ashu Kenith
--
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
FORU
I am from Zira, District Ferozepur, Punjab
Presently residing in Sirhind, Near Chandigarh.
On Fri, Feb 6, 2015 at 3:32 PM, Ashu k wrote:
> Hi Mr. Dhunna,
>
> Where are you from..?
>
> --
> 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 offi
Hi Mr. Dhunna,
Where are you from..?
--
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 titles, li
Hi Mr. Ashu,
That's Great !
Thanks a Lot for the Encouraging Words! Definitely I want to learn VBA. Any
guidance in this regard is Most Welcome !
On Fri, Feb 6, 2015 at 3:10 PM, Ashu k wrote:
> Hi Mr. Kanwaljit,
>
> By profession I am CA and Successfully completed Phd. too
>
> You want to lean
Hi Mr. Kanwaljit,
By profession I am CA and Successfully completed Phd. too
You want to lean VBA.
Reply me, I am ready to help you personally and professionally.
Regards
Ashu Kenith
--
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 offici
Hi Vaibhav,
Nice to know that you are a CA !
Feeling proud that poeple in our Profession are so Proficient in other
Fields too !
I am certainly working on sharpening my VBA skills though at the speed I
would desire too. Seems I am in the right Company :)
On Fri, Feb 6, 2015 at 3:00 PM, Vaibhav Jo
By profession i am in to CA too, n it is once personal interest n desire to
learn, since VBA is magical tool for everyone & if you expand your
knowledge it can be boon to CA office.
Also believe me those not belonging to core VBA are also replying & solving
Queries at par with VBA experts..
Yes i
Hi Vaibhav, Thanks for the Concern !
I understand everyone here is engaged in some profession but even then Some
people like you spare time out of their busy schedule to help people out of
trouble. I am a CA by profession and can do some good things in Excel but
not in VBA. I tried learning VBA at
Hi Kanwaljit
Any luck?
On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote:
> yes, you an do it...
>
>
>
> On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna <
> kanwal...@gmail.com> wrote:
>
>> Ok Vaibhav. Even though I have very little idea about VB (Just read the
>> codes and try to unde
yes, you an do it...
On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna
wrote:
> Ok Vaibhav. Even though I have very little idea about VB (Just read the
> codes and try to understand them) I will give it a shot.
>
> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote:
>
>> i want you to w
Ok Vaibhav. Even though I have very little idea about VB (Just read the
codes and try to understand them) I will give it a shot.
On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote:
> i want you to work on present requirement...
>
> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna <
> kanw
i want you to work on present requirement...
On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna
wrote:
> Ok Sir, I will do that.
>
> I hope I am clear on my present question.
>
> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote:
>
>> You want to learn VBA then start modifying last code w
Ok Sir, I will do that.
I hope I am clear on my present question.
On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote:
> You want to learn VBA then start modifying last code which i sent to you
> to accommodate it..
>
> Start & letus know when you get error..
>
> Cheers!!
>
>
> On Thu, Feb 5, 2
You want to learn VBA then start modifying last code which i sent to you to
accommodate it..
Start & letus know when you get error..
Cheers!!
On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna
wrote:
> Hi Experts,
>
> I have attached a sheet.
> I wish there could be a macro which when run
Hi
Chekc this attachment, press Apt + F8 and click on Macro1 to run macro.
On prompt select range B2:B15 for this data & you will get output on output
sheet..Make sure you empty column A in output sheet before running macro
else your all data will get deleted bu macro from output sheet..
Cheers
Any update plz
On 20-Jan-2015 5:22 PM, "Rakesh" wrote:
> Hi Experts,
>
>
>
> Please help to provide macro of above mentioned requirement.As in
> attached sheet On Left side i have shown the input which we have to
> fetch in macro which can range from 1 to 50. We need to select values from
> inpu
Hi
Try this...
You need to mention your actual sheet names & work book name along with
path in VB module..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 25, 2014 at 1:02 PM, Sara Lee wrote:
> I have a excel file which has 3 tabs by name A,B
I'm sure there's more information that you're not telling us.
What column has the "Chas" data?
is "Chas" the same column in all tabs? or does the macro have to locate it?
I created two files with the mentioned sheet names and put about 1000 random
numbers in each sheet.
Then I created the fo
14 20:27:03 +0530
>
> Subject: Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month
> Cell in calculation
> To: excel-macros@googlegroups.com
>
> Hi
>
> check this, if you change value in cell A1, your formual in B1 will get
> change automatically. Cell B3 to B5 i
Hi Vaibhav,
Thanks for the idea. It works.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Mon, 1 Sep 2014 20:27:03 +0530
Subject: Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell
in calculation
To: excel-macros@googlegroups.com
Hi
check this, if you change
Hi Vaibhav,
Jan total will always be in column D and so on.
Sent from my Windows Phone
From: Vaibhav Joshi<mailto:v...@vabs.in>
Sent: 01-09-2014 10:15
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Ma
Hi
How excel will know the starting month & current month for which you are
calculating formula?
On Sun, Aug 31, 2014 at 3:31 PM, Nitin Balodi wrote:
> Hi Experts,
>
> I am in fix over this part of my report automation and require your help.
>
> Please refer to attached file. Description is
Cheers!!
On Sat, May 31, 2014 at 3:15 PM, Shrinivas Shevde
wrote:
> Dear Vibhav
> Good Work Very very thanks
>
> Regards
> Shrini
>
>
> On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> PFA
>>
>> All data will be merged into Result sheet, with sheets name in first col.
>>
>>
Dear Vibhav
Good Work Very very thanks
Regards
Shrini
On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi wrote:
> Hi
>
> PFA
>
> All data will be merged into Result sheet, with sheets name in first col.
>
> Cheers!!
>
>
>
> On Sat, May 31, 2014 at 11:51 AM, Shrinivas Shevde > wrote:
>
>> Dear al
This is really cool...
Cheers!!
On Sun, May 11, 2014 at 10:24 PM, Bé Trần Văn wrote:
> TEAR SHEET: Press the button "Separation sheet and name".
>
> ELIMINATION OF SHEET: Press the button "Delete sheet detached".
>
>
>
>
>
> 2014-05-07 14:12 GMT+07:00 Shrinivas Shevde :
>
> Very very thanks
>>
TEAR SHEET: Press the button "Separation sheet and name".
ELIMINATION OF SHEET: Press the button "Delete sheet detached".
2014-05-07 14:12 GMT+07:00 Shrinivas Shevde :
> Very very thanks
>
>
> On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> Yes you can paste data in mast
Very very thanks
On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi wrote:
> Hi
>
> Yes you can paste data in master file below the existing data. However you
> can test data.
>
>
> Thanks
>
>
> On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde
> wrote:
>
>> Dear Vaibhav
>>
>> Really nice and lots
Hi
Yes you can paste data in master file below the existing data. However you
can test data.
Thanks
On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde wrote:
> Dear Vaibhav
>
> Really nice and lots of thanks
> Small query.I will get data on daily basis as i said earlier so shall i
> copy paste
Dear Vaibhav
Really nice and lots of thanks
Small query.I will get data on daily basis as i said earlier so shall i
copy paste data below the current data in data sheet.
Regards
Shrinivas
On Tue, May 6, 2014 at 11:19 PM, Vaibhav Joshi wrote:
> Hey
>
> Check out this..
>
> Cheers!!
>
>
> On M
Dear sir,
Thanks for reply but I want perfectly opposite.
Thats I have a master sheet and from that it should go to indivisual sheet.
Regards
Shrinivas
On Mon, May 5, 2014 at 8:10 PM, Bé Trần Văn wrote:
> Reference File.
>
> 2014-05-05 17:21 GMT+07:00 Shrinivas Shevde :
>
>
>> Dear all
>>
>>
Dear Praful,
Pl find the modified file as req.
Warm Regards,
Gawli Anil
On Wed, Feb 26, 2014 at 5:18 PM, Prafull Jadhav
wrote:
> Dear Ravinder Sir,
> Thanks for Reply..it is working fine.
>
> Can we make the same without selecting Range and paste range(Without message
> box)?
> Means we need no
Dear Ravinder Sir,
Thanks for Reply..it is working fine.
Can we make the same without selecting Range and paste range(Without
message box)?
Means we need not require fill the Range.
Regards,
Prafull Jadhav
9920553518
On 26 February 2014 16:59, Ravinder wrote:
> Pfa , first select "a" colum
Pfa , first select "a" column till values in sheet 1 and then select range
"a2" in sheet2
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Wednesday, February 26, 2014 3:08 PM
To: excel-macros@googlegroups.com; excelvbacli...@googlegro
Dear Rushiraj,
Yes, u can send to all
in the cells put all the emailids seperated with commas(",") and in outlook
sheet select dropdown and select that emailid's .
It should work.
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 11:20 AM, rushiraj patel wrote:
> Dear Anil,
>
> Tnxs for the ins
Dear Anil,
Tnxs for the instant reply. The macro is working so fine. One more
thing i would like to ask is can i use the same macro to send mails to
more that a mail IDs.?
like as we can put the list of emil ids to whom i wanna send mail in
addressbook sheet. As of now i have to drag down from va
so, do you need help finding what someone else already asked and answered?
Paul
-
“Do all the good you can,
By all 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 yo
I don't know exactly because I do not program powerpoint. This is an
Excel Macros grou, after all.
However it would be something like
Picture.left = (slide.width - picture.width)/2
picture.top = (slide.height - picture.height)/2
It may need ActiveWindow.width rather than slide.width
hth
Regar
my requirement is pending please help...
On Mon, Sep 24, 2012 at 12:34 PM, Manoj Kumar wrote:
> Dear Expert,
>
> i am making my presentation, i use macro to do same size of all picture
> after i want all picture show in center of slide...
>
>
> Please help me..
>
> Sub PictureSizer()
> For NumSli
Hi Maries,
I have checked the file but all numbers, no formula inside ... hence, the
macro needs to do something on the data itself not to create another sheet.
The sample I provided is to show what result I want to see not meaning it
will be 2 sections of the data, I guess using formula will n
Hi Tony,
I have done by formula... Just check the sheets cells. There is no Macro
codes inside.
Regards,
MARIES.
On Mon, May 7, 2012 at 5:13 PM, Tony Wu wrote:
> Sorry ... I didn;t see the Macro in the attachment.
> thanks,
> Tony
>
>
> On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote:
Sorry ... I didn;t see the Macro in the attachment.
thanks,
Tony
On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote:
>
> Hi,
>
> Check the attachment.
>
> Regards,
>
> MARIES.
>
> On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote:
>
>> Hello,
>>
>> I have a file for the forecast demand, so
Hi,
Check the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote:
> Hello,
>
> I have a file for the forecast demand, some parts have substitution, what
> I need is if the part has substitution, the original demand will be added
> to the new part and original dema
Try this :
Private Sub UserForm_Activate()
Me.Width = ActiveWindow.Width - 500
Me.Height = ActiveWindow.Height - 200
Me.ScrollBars = fmScrollBarsBoth
End Sub
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mari Krishn
Any progress from any member awaiting
On Wed, Feb 16, 2011 at 1:52 AM, maulik desai wrote:
> Hi Group,
>
> I JUST want Macro instend of Formulas used in sheets
>
> I want a macro which can give me the output like formulas (i dont want to
> use formulas in sheets as it becomes very heavy f
On Apr 27, 2:41 am, Swapnil Palande wrote:
> Hi Rupin,
>
> Please find attached excel for solution. Select the range and press Ctrl and
> Q.
>
> Regards,
>
> Swapnil.
>
> On Mon, Apr 26, 2010 at 2:59 PM, Rupin Goel wrote:
Thank you for your help. It seems someone was asking the same
question
49 matches
Mail list logo
