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 v...@vabs.in wrote:
Hi Kanwaljit
Any luck?
On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi v...@vabs.in wrote:
yes, you an do it...
On Thu,
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
Dont know about Superman but I m definitely Salman Khan's fan !! ;)))
Cheers!!
On Sun, Feb 8, 2015 at 10:00 PM, B Sharma sharma@gmail.com 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
Thanks !
Any tip on how to the Debugger in VBA ?
On Fri, Feb 6, 2015 at 4:11 PM, Ashu k direct2as...@gmail.com 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
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
I am from Zira, District Ferozepur, Punjab
Presently residing in Sirhind, Near Chandigarh.
On Fri, Feb 6, 2015 at 3:32 PM, Ashu k direct2as...@gmail.com 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
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,
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
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
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
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 direct2as...@gmail.com wrote:
Hi Mr. Kanwaljit,
By profession I am CA and Successfully completed Phd. too
Hi Kanwaljit
Any luck?
On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi v...@vabs.in 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
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
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 understand them) I will give it a shot.
On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi v...@vabs.in
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 kanwal...@gmail.com
wrote:
Hi Experts,
I have attached a sheet.
I wish there could be a macro
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 v...@vabs.in wrote:
i want you to work on present requirement...
On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh
i want you to work on present requirement...
On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com
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 v...@vabs.in wrote:
You want to learn VBA then
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 v...@vabs.in 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
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..
Any update plz
On 20-Jan-2015 5:22 PM, Rakesh rksharma...@gmail.com 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
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
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 lee.sar...@gmail.com wrote:
I have a excel file which has
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
: $$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 is just for explanation, which you can
delete.
Cheers!!
On Mon, Sep
Hi Vaibhav,
Jan total will always be in column D and so on.
Sent from my Windows Phone
From: Vaibhav Joshimailto:v...@vabs.in
Sent: 01-09-2014 10:15
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro
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 nitinbal...@live.com wrote:
Hi Experts,
I am in fix over this part of my report automation and require your help.
Please refer to attached file.
Dear Vibhav
Good Work Very very thanks
Regards
Shrini
On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi v...@vabs.in 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
Cheers!!
On Sat, May 31, 2014 at 3:15 PM, Shrinivas Shevde shrinivas...@gmail.com
wrote:
Dear Vibhav
Good Work Very very thanks
Regards
Shrini
On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
PFA
All data will be merged into Result sheet, with sheets name in
This is really cool...
Cheers!!
On Sun, May 11, 2014 at 10:24 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
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
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 shrinivas...@gmail.com:
Very very thanks
On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Yes you
Very very thanks
On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi v...@vabs.in 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
shrinivas...@gmail.comwrote:
Dear Vaibhav
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 betnmtdongna...@gmail.comwrote:
Reference File.
2014-05-05 17:21 GMT+07:00 Shrinivas Shevde
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 v...@vabs.in wrote:
Hey
Check out this..
Cheers!!
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 shrinivas...@gmail.comwrote:
Dear Vaibhav
Really nice and lots of thanks
Small query.I will get data on daily basis as i said earlier so
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;
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 ravindervbacli...@gmail.com wrote:
Dear Praful,
Pl find the modified file as req.
Warm Regards,
Gawli Anil
On Wed, Feb 26, 2014 at 5:18 PM, Prafull Jadhav
prafulltjad...@gmail.com wrote:
Dear Ravinder Sir,
Thanks for Reply..it is working fine.
Can we make the same without selecting Range and paste range(Without message
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 rushiraj2...@gmail.comwrote:
Dear Anil,
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
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
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 wumu...@gmail.com wrote:
Hello,
I have a file for the forecast demand,
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 wumu...@gmail.com wrote:
Sorry ... I didn;t see the Macro in the attachment.
thanks,
Tony
On Saturday, May 5, 2012 9:23:46 AM UTC-4,
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
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
On Apr 27, 2:41 am, Swapnil Palande swapnilp1...@gmail.com 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 rupin.investm...@gmail.comwrote:
Thank you for your help. It
45 matches
Mail list logo
