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

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

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            

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

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

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

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

I like the questions. Very good introductory questions on a variety of VBA topics. For question #8, I suspect the question intended could be better phrased "Which of these is a datatype most specifically for storing decimal integers in a variable?" (several of the datatypes listed store decima

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

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 not taking any exam ( Wrong prediction) ..think positively ...this will nt have any loss for any one Finally

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

Notice Forum Rule #3? 3) Don't post questions regarding breaking or bypassing any security measure.   WE don't have any way of knowing if you own the code or are simply trying break into the code to determine some type of proprietary information (hacking) If you are attempting to perform some il

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

I first encountered this problem in Excel2007. Not at all in Excel2003. What I discovered is that it seems to be a  Windows Priority issue. (Possibly an XP issue after all!) What seems to happen is that while the macro is running, and nothing else is going on, Excel is the "highest" priority for

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 Macr

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

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