$$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 @ https://ww

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 for a specific text in Col

$$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) >> paid or free ? >> >> On 11 September 2016

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: > >> Thanks Prabhu!.. >> >> Happy to here from yo

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 > wrote: > >> Hi Friends, >> >> Since i h

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 whatsapp to get added 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 @ https://www.facebook.com/discu

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

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

$$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 Fa

$$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 request

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 wrote: > > > 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 wo

$$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 t

$$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 purpos

$$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 t

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 Fo

$$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 ha

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).Va

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

cel-macros@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=true&am

$$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&formkey=dHRESnJEemJNVmQ3Ym9SbnNvWnZDUEE6MQ VBA macro quiz #1 This quiz is sponsored by discussexcel.com. Ayush Jain Group Manager Your name * Emai

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 wrote: > Dear Sanusi, > > Pls use below formula > > =LEFT(B3,FIND(")",B3,1)) > =RIGHT(B3,LEN(B3)-FIND(")",B3)) > > see attachment for more clarity. > Please u

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 atta

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:// noorainansari.com

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 FORU

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

t; your time and mine. > > But perhaps we've both learned something. > > > > Paul > > - > > “Do all the good you can, > > By all the means you can, > > In all the ways you can, > > In all the places y

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

t; To all the people you can, > As long as ever you can.” - John Wesley > - > > > > > > From: bhanu prakash > To: excel-macros@googlegroups.com > Sent: Tue, November 6, 2012 6:18:11 AM > Su

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

imes you can, To all the people you can, As long as ever you can.” - John Wesley - From: bhanu prakash 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 Requi

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

times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *----------------- > > > -- > *From:* bhanu prakash > *To:* excel-macros@googlegroups.com > *Sent:* Sun, November 4, 2012 11:55:01

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

le you can, As long as ever you can.” - John Wesley - From: bhanu prakash 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**

$$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

Re: $$Excel-Macros$$ VBA Macro

Hi Shrinivas, Can u provide code. Regards, Swapnil. On Thu, Sep 27, 2012 at 9:14 AM, Shrinivas Shevde wrote: > 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 " > But I cant undr

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

od 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 you can.” - John Wesley - ____ From: Rruffpaw To: MS EXCEL AND VBA 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 re

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

Sub ShowInputBOx() Range("A1").value=application.inputbox ("Please enter A value") End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Friday, July 22, 2011 1:47 PM To: excel-macros@googlegroups.com Subject:

$$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 anywa

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

please find the attached sample data... and the website :- http://www.melissadata.com/lookups/phonelocation.asp?number I want to extract zipcodes(primary) from a webpage on the basis of phone numbers and paste it into the excel sheet in the next cell front of the corrsponding phone numbers. If t

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 wrote: > Guys, > > Can anyone help me on this? > > > > Thank You... > > > > > On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar < > manoj.vishwakarma...@gmail.com> wr

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

$$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

$$Excel-Macros$$ VBA Macro that send emails with 5 attached files from one directory

Hello there I already have prepared the macro that gets the mail Addresses and names and prepares the email to me, however I don´t know how to attach all files from a certain directory. The method would be “With myItem .attachement.add “file to be attached” End wi

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 wrote: > Hi Ankur, could u pls send me the VBA e-books to my id... > thanks in a

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 wrote: > hi chetan > > i had send some ebooks at your email id plz check it > > > > On 30/01/2010, chethan wrote: > > Hi Everybody, > > > > i am very new to the world

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 tricks

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 d

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 wrote: > hi chetan > > i had send some ebooks at your email id plz check it > > > > On 30/01/2010, chethan wrote: > > Hi Everybody, > > > > i am very new to the world of VBA macros. i would like to lear

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 wrote: > hi chetan > > i had send some ebooks at your email id  plz check it > > > > On 30/01/2010, chethan wrote: >> Hi Everybody, >> >> i am very new to the wor

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 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 VBA from the sc

$$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 importan

$$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 sameon

$$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.

$$Excel-Macros$$ VBA Macro Excel Add Text In Cell

I need a macro that will add periods at specific locations in a cell of text in Excel. My example is an item number f123456789 that I need to look like f.123.456.789. Any suggestions? I have code written but it is bulky and I know there is an easier way. Thanks for any and all help. --~--~---