$$Excel-Macros$$ VBA Macro - Do While Loop

Hi Friends, Feels like worth sharing the knowledge. Do while loop in Excel VBA. https://youtu.be/JIpu6vOe9Vo Thanks & Regards, Prabhu R -- 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 @

Re: $$Excel-Macros$$ VBA MACRO NEEDED (SIMPLE??)

Hey Bil, You can do this thru formula only. Enclosed without macro solution, let us know if you still required macro. -- On Sun, Sep 18, 2016 at 8:42 AM, Bill Q wrote: > Please see attached. > > Looking for a macro to automate a repetitive task. > > 1. It is to look

$$Excel-Macros$$ VBA MACRO NEEDED (SIMPLE??)

Please see attached. Looking for a macro to automate a repetitive task. 1. It is to look for a specific text in Column C. In this case, it would be the word "GEORGE" 2. Once it encounters the word, Column B would be populated with "X". 3. The "X" would continue to be populated until it column C

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

Thank you On 13 September 2016 at 22:39, Learner Excel wrote: > No, > you can not add more thn 250 ppls > > -- > > On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote: > >> is there any option in whatsup appln to add unlimited members(in single >> group)

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

No, you can not add more thn 250 ppls -- On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote: > is there any option in whatsup appln to add unlimited members(in single > group) > paid or free ? > > On 11 September 2016 at 11:50, Learner Excel wrote: > >>

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

is there any option in whatsup appln to add unlimited members(in single group) paid or free ? On 11 September 2016 at 11:50, Learner Excel wrote: > Thanks Prabhu!.. > > Happy to here from you!>=. > > -- > > On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

Thanks Prabhu!.. Happy to here from you!>=. -- On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky wrote: > Hi Friends, > > Since i have created Whatsapp group for VBA Macro learners/experts. > > And i have added many peoples in this group. Please Msg me to 9500087194 > in

$$Excel-Macros$$ VBA Macro - Whatsapp Group

Hi Friends, Since i have created Whatsapp group for VBA Macro learners/experts. And i have added many peoples in this group. Please Msg me to 9500087194 in whatsapp to get added in this group. if anyone missed or not yet added even you requested earlier. Thanks & Regards, Prabhu R -- Are you

$$Excel-Macros$$ VBA macro - WhatsApp group.

Creating WhatsApp group for VBA macro... Pls msg me your contact, if you wants to join. Add me in WhatsApp and Msg me to - 9500087194 Regards, Prabhu.R -- 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

Re: $$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

dim ppApp  As PowerPoint.Applicationdim ppReport   As PowerPoint.Presentationdim ppSlide  As PowerPoint.Slidedim oPPTOLEObject_Text   as object Set ppReport = ppApp.Presentations.Open("PPT Path")                    ppApp.Visible = msoTrue                    'Filling text boxes in ppt            

$$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

Hi team, is there any piece of code for opening chart object and edit the content in PPT? -- Thanks & regards Satheesh -- 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 @

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

Sub create() Dim wk As Worksheet, wk2 As Worksheet Dim i As Long, k As Long, z As Long, s As Long On Error Resume Next Sheets(T1).Delete Sheets(T2).Delete On Error GoTo 0 Sheets.Add(after:=Sheets(Sheets.Count)).Name = T1 Sheets.Add(after:=Sheets(Sheets.Count)).Name = T2 Set wk = Sheets(T1)

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

Ashish Sir, you are really Great... i am very big fan of you.. thank you so much for the providing the code, this is working good. On Saturday, 22 March 2014 11:38:08 UTC+5:30, ashish wrote: Sub create() Dim wk As Worksheet, wk2 As Worksheet Dim i As Long, k As Long,

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

Dear experts, please provide the vba macro for attached excel sheet format split into separate sheets those formats are mentioned in the excel kindly do the needful thanks alot. -- 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

$$Excel-Macros$$ VBA macro to read website using internet explorer

Hi All, I am using a VBA macro to access or update a external internet page using internet explorer. The internet explorer is opened in the background and then the site is opened. However, in recent Internet explorer versions, if I access a new page, the internet explorer goes offline and

Re: $$Excel-Macros$$ VBA Macro Code - for spell of Numbers into Words

can you share sample file On Tue, Jan 28, 2014 at 1:41 PM, Camukesh2015 camukesh2...@gmail.comwrote: Hi EverReady, I have downloaded a macro code for spell numbers in Indian Rupees, in Lakhs and Crore notation. But I am facing a problem in the code. Code is working fine upto 200 crore

$$Excel-Macros$$ VBA Macro Code - for spell of Numbers into Words

Hi EverReady, I have downloaded a macro code for spell numbers in Indian Rupees, in Lakhs and Crore notation. But I am facing a problem in the code. Code is working fine upto 200 crore conversion into words but when I tried to convert above 200 crore formula showing #Value! errror.. I have

$$Excel-Macros$$ VBA macro to replace Index and Match formula

Hello, I'm new here and need some help. I need to perform stock analysis regularly, which involves the use of files with data in multiple columns and more than 100K lines of records. To provide a better illustration of the routine tasks I perform, I've attached a file for simulation

$$Excel-Macros$$ VBA Macro problem - Excel 2007

I pull data for individual customers from a source system into an Excel workbook. I have a separate Excel workbook template that contains macros, which allow me to reformat the data in the source workbook. I am trying to add another macro that will do additional formatting, but when trying to

$$Excel-Macros$$ VBA Macro to take list of multiple inputs, apply to another spreadsheet, and return value

I want to create a macro to take multiple inputs from sheet 2, apply them simultaneously to the inputs on sheet 1, take sheet 1's output and list next to the inputs on sheet 2. I want to apply this to a spreadsheet with complicated calculations. Example spreadsheet attached. Related Macros I

Re: $$Excel-Macros$$ VBA Macro to take list of multiple inputs, apply to another spreadsheet, and return value

Hi Derick , Try the below code. Sub Multiple_Inputs() For i = 1 To 20 Sheet2.Cells(i + 1, 1) = i + Sheet1.Cells(2, 1) - 1 Next i For j = 1 To 20 Sheet2.Cells(j + 1, 2) = j + Sheet1.Cells(2, 2) - 1 Next j For k = 1 To 20 Sheet2.Cells(k + 1, 3) = k + Sheet1.Cells(2, 3) - 1 Next k

Re: $$Excel-Macros$$ Vba macro code for generating years along the side of days and also by removing the months

see if it helps Sub sample() Dim i As Long Dim st As Long Dim j As Long j = 3 st = 1936 For i = 2 To Range(a65356).End(xlUp).Row If IsNumeric(Cells(i, 1).Value) And Cells(i, 1).Value Then If Cells(i, 1).Value = st + 1 Then st = st + 1 Cells(j, 10).Value = st Cells(j, 11).Value =

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

hi sir, can u please mail me the book for vba macro in my mail id i.e rathisumitra...@gmail.com thank you regards sumit rathi -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

RE: $$Excel-Macros$$ VBA macro quiz #1

@googlegroups.com Subject: $$Excel-Macros$$ VBA macro quiz #1 If you have trouble viewing or submitting this form, you can fill it out online: https://docs.google.com/spreadsheet/viewform?fromEmail=true https://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHRESnJ

$$Excel-Macros$$ VBA macro quiz #1

If you have trouble viewing or submitting this form, you can fill it out online: https://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHRESnJEemJNVmQ3Ym9SbnNvWnZDUEE6MQ VBA macro quiz #1 This quiz is sponsored by discussexcel.com. Ayush Jain Group Manager Your name *

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

- From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 6:18:11 AM Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Paul, I know the Rules of the forum...I had using this forum fro

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Paul, I know the Rules of the forum...I had using this forum fro almost from long time..appreciate your efforts in writing lengthy mail on this.. That exam itself designed by me..and I am

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

- From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 6:18:11 AM Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Paul, I know the Rules of the forum...I had using

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Hi all, I have a problem as per attached excel. Kindly guide me on how to resolve the issue by using formula/macro. Your assistance and help is very much appreciated. Thank you Best regards Sanusi -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Dear Sanusi, Pls use below formula =LEFT(B3,FIND(),B3,1)) =RIGHT(B3,LEN(B3)-FIND(),B3)) see attachment for more clarity. Please use separate thread for your fresh query instead of another thread. -- With Regards, Noorain Ansari http://

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Hi Sanusi, Please Paste the followint formulas. In D1 =LEFT(B3,2) In E1 =MID(B3,3,LEN(B3)-2) and drag up to thwe number of rows as data in B columns. Regards Prince On Wednesday, November 7, 2012 11:10:45 AM UTC+5:30, msn wrote: Hi all, I have a problem as per attached

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Dear Noorain Prince, Thank you very much for the formula solutions. Best regards Sanusi On 7 November 2012 13:51, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sanusi, Pls use below formula =LEFT(B3,FIND(),B3,1)) =RIGHT(B3,LEN(B3)-FIND(),B3)) see attachment for more clarity.

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

- From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Sun, November 4, 2012 11:55:01 PM Subject: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Dear Team , Need your help in Unprotecting

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

*To:* excel-macros@googlegroups.com *Sent:* Sun, November 4, 2012 11:55:01 PM *Subject:* $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Dear Team , Need your help in Unprotecting the VBA ( macro ) sheet..Or please let me know how to do it..this is required little

$$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Dear Team , Need your help in Unprotecting the VBA ( macro ) sheet..Or please let me know how to do it..this is required little urgent..kindly help Had attached the sheet for refference ..thanks Regards Bhanu -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ VBA Macro

Thaks MS Excel Learner Dear Swapnali. I am not talking of particular code I am talking about in general meaning of Error code. On Thu, Sep 27, 2012 at 11:16 AM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi Shrinivas, Can u provide code. Regards, Swapnil. On Thu, Sep 27,

Re: $$Excel-Macros$$ VBA Macro

Hi Shrinivas, Can u provide code. Regards, Swapnil. On Thu, Sep 27, 2012 at 9:14 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All Some days back I was trying to write macro and I could write small macro. While practising many times I found Error messagr Like Run Time Error 402

Re: $$Excel-Macros$$ VBA macro runs fine, but freezes if I try to do ANYTHING else while it's running

, To all the people you can, As long as ever you can.” - John Wesley - From: Rruffpaw shara...@hotmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, August 3, 2011 3:32:23 PM Subject: $$Excel-Macros

$$Excel-Macros$$ VBA macro runs fine, but freezes if I try to do ANYTHING else while it's running

I have a very large Excel spreadsheet (13 MB) with several macros. One of them runs a loop with multiple commands. The macro runs fine, as long as I sit back and just watch it run. If I click on another window however, it invariably freezes and I have to terminate Excel. Any ideas on how I can

$$Excel-Macros$$ VBA Macro with Input Box

Hi Where can I find some good info on : When a macro runs I want a input box for user to insert the column range A:(or B; or F: etc) and then a input box for the text to look for say ABC or 123 or xyz etc and then a third box for the column for a format to be done. Have googled but have not

$$Excel-Macros$$ VBA Macro to automatically set a print area

We have a requirement to run a templated output for a WebFocus report that include the capability to have the output ready to print. In other words, a user should be able to see the exact printout available when the Excel opens by clicking on Print Preview. Issues: 1.) The output can be anyway

Re: $$Excel-Macros$$ VBA macro to open web page then enter phonenumber and submit

Guys, Can anyone help me on this? Thank You... On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi, I need to open an internal webpage after a phone number is entered into a spreadsheet then submit these details on the webpage and the result is

Re: $$Excel-Macros$$ VBA macro to open web page then enter phonenumber and submit

plz provide us some samle data and the website where to upload the data. regards, simran On Thu, Jul 29, 2010 at 2:48 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Guys, Can anyone help me on this? Thank You... On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar

$$Excel-Macros$$ VBA macro to open web page then enter phonenumber and submit

Hi, I need to open an internal webpage after a phone number is entered into a spreadsheet then submit these details on the webpage and the result is paste on the spreadsheet. Is there a way of doing this? Thanks in advance! Manoj Kumar -- M.K.V --- The state of your life is nothing more than

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

hello friends, i had send my files to the moderator of group , you will find them shortly in our file section no need to post request here , just mail me on my id ankurpande...@gmail.com On 01/02/2010, asha abraham abrash...@gmail.com wrote: Hi Ankur, could u pls send me the VBA e-books to my

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Hi Ankur, could u pls send me the VBA e-books to my id... thanks in advance. rgds ash@ On Sat, Jan 30, 2010 at 4:10 PM, ankur ankurpande...@gmail.com wrote: hi chetan i had send some ebooks at your email id plz check it On 30/01/2010, chethan chethan...@gmail.com wrote: Hi Everybody,

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Dear Ankur, Would you mind uploading those books in the Files section of the group. This will help lots of users. Connect to manager / admin of the group for necessary help and support. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Hi Ankur, Thanks for the books. Can you give me some tips about how i can learn this programming quickly? Regards, Chethan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ VBA MACRO HELP NEEDED

Hi Everybody, i am very new to the world of VBA macros. i would like to learn macros can anybody help me out in getting the proper way to get available materials to learn the VBA from the scratch. -- -- Some

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

hi chetan i had send some ebooks at your email id plz check it On 30/01/2010, chethan chethan...@gmail.com wrote: Hi Everybody, i am very new to the world of VBA macros. i would like to learn macros can anybody help me out in getting the proper way to get available materials to learn the

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Hi Ankur, Please forward the VBA E-Book to me as well... I want to learn VBA... Thanks Vinod On Sat, Jan 30, 2010 at 4:10 PM, ankur ankurpande...@gmail.com wrote: hi chetan i had send some ebooks at your email id  plz check it On 30/01/2010, chethan chethan...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

*Can you please send me those e-books to my mail id* On Sat, Jan 30, 2010 at 4:10 PM, ankur ankurpande...@gmail.com wrote: hi chetan i had send some ebooks at your email id plz check it On 30/01/2010, chethan chethan...@gmail.com wrote: Hi Everybody, i am very new to the world of

$$Excel-Macros$$ VBA / Macro to Download pages listed on a column

Dear folks Thanks for the help so far... I wish to know if the following can be automated using VBA ? Step 1 : I have a list of URL listed in a column. I wish to download the contents of each of these pages one by one, i.e. without me clicking on each URL...or cutting and pasting the

$$Excel-Macros$$ vba macro to protect sheet (hide formula's)

hi All, thought this would be easy but I get: Run-time error 1004. You cannot use this macro on a protected sheet Anyone knows what's going on re. my code below? Just the protecting works but I would like to hide all formula's and then I get the error though my sheets are not protected.