Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi good to see you noel... Cheers!! On Wed, Feb 4, 2015 at 4:12 AM, sss1008 wrote: > Hi I'm Noel from the Philippines. I'm a computer programmer. I'd been > doing projects VBA for Access and Excel. I'm glad to be part of this > forum. > > On Friday, June 8, 2012 at 3:21:59 PM UTC-4, Ayush Ja

Re: $$Excel-Macros$$ Data handling

Hi Sri Check this... You need to delete column B once you get data from Macro.. Cheers!! On Wed, Feb 4, 2015 at 10:30 AM, Shrinivas Shevde wrote: > Dear Paul/Vaibhav > Thanks for reply. > > *To Vaibhav,* > Macro you send is just merging the data from all sheets in one sheet.My > requirement

Re: $$Excel-Macros$$ Data handling

Dear Paul/Vaibhav Thanks for reply. *To Vaibhav,* Macro you send is just merging the data from all sheets in one sheet.My requirement is something different which I tried to explain below To Paul, Do you have any experience with macros? *Yes but I can write very basic macro.* or are you asking on

$$Excel-Macros$$ VBA Mailto Link that createa a reply email with the original email appear to the reply email body

Hi, I had this Access Database that sends out an email with a mailto link in the body of it and the email details. Once click the link text, it must create a reply email with the original email appear in the body of the reply email. How can i add it to the mailto code: Ex: mailto:na...@gmai

$$Excel-Macros$$ Re: Introduce Yourself !!

Hi I'm Noel from the Philippines. I'm a computer programmer. I'd been doing projects VBA for Access and Excel. I'm glad to be part of this forum. On Friday, June 8, 2012 at 3:21:59 PM UTC-4, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the la

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

Yes agree with paul On Feb 3, 2015 9:45 PM, "Paul Schreiner" wrote: > That usually is a problem with "References". > > try these steps: > > Stop execution of macro > in VB Editor, select Tools-> References... > > you'll find several libraries selected. > But you might see one that says "Missi

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

That usually is a problem with "References". try these steps: Stop execution of macro in VB Editor, select Tools-> References... you'll find several libraries selected. But you might see one that says "Missing" (or something like that). The problem is that once the compiler hits this missin

Re: $$Excel-Macros$$ Search value and paste row code problem

try below code. Sub Button3_Click() Dim wSheet As Worksheet Dim wBook As Workbook Dim rFound As Range Dim bFound As Boolean Dim lngNextRow As Long Dim strMyString As String strMyString = Application.InputBox("Enter the number you wish to find") On Error

$$Excel-Macros$$ Search value and paste row code problem

Hi all, Thank you in advance for all your help it is really appreciated. I have the following code which looks for a certain value into all the open workbooks and then pastes the entire row into a sheet from the current workbook named 'RESULTS'. The problem is that it does not copy the row con

Re: $$Excel-Macros$$ Reset Macro After Excel Start up

thanks Paul, i have sent you the file On Tue, Feb 3, 2015 at 3:27 AM, Hilary Lomotey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup rule >

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

Try replacing Left with Left$ On Tue, Feb 3, 2015 at 7:03 PM, Pravin Gunjal wrote: > Hi > > I have downloaded the DBF save add-in but while saving got the attached > error in VB. > Could anyone please check and update me on this issue. > > Thank you > Pravin Gunjal > > -- > Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Data handling

Hi Use this sheet to merge all sheets data in one sheet.. Cheers!! On Tue, Feb 3, 2015 at 1:02 PM, Shrinivas Shevde wrote: > Dear All > Please help me for following problem > I used to get the data in 2 sheets Trial1 and Trial 2 > I need to conoslidate this data in 3rd sheet "results" > It is

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

Thank you Mr.Paul to suggest me best in coding. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Feb 3, 2015 at 5:50 PM, Paul Schreiner wrote: > The problem is: > When you insert a row in your ta

Re: $$Excel-Macros$$ multi mailer

Very good. The issue is this: when sending the email, the values for: .To= .CC = .BCC = need to be strings, separated by ";" You can "build" it using something like: Dim AddrList As String Dim C As Integer, R As Integer R = 3 AddrList = "" For C = 3 To 12 If (ActiveSheet.Cells(R, C).Value <

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

The problem is: When you insert a row in your table, column "D" doesn't "inherit" the properties of the previous row, but instead reverts to the "General" format of the rest of the column. There's a couple ways of handling this. I tried both and they both seem to work: Select the entire colum

Re: $$Excel-Macros$$ Help required - alternate sorting

Hi, check this file.. Put formula countif in next columncopy & paste down, you can see there is Separate set of sequential numbering for Dr & Cr. Once it is ok, copy & paste value for formula column & sort data AtoZ .. Cheers!! On Tue, Feb 3, 2015 at 5:25 PM, singla.kris...@gmail.com < singla.

Re: $$Excel-Macros$$ Data handling

Do you have any experience with macros? or are you asking one of us to CREATE one and show you how to use it? (which is POSSIBLE, but implies more of a time commitment) to do either, we'd need to know what your two worksheets look like and what exactly you want the results to look like. Paul

Re: $$Excel-Macros$$ Help required - alternate sorting

Send with Excel file where you want to do this. Pramod On 3 Feb 2015 17:25, "singla.kris...@gmail.com" wrote: > Hi, > > Can somebody please help me in a small macro. My sheet have a column with > some values and I want to sort them alternately. > > Current > Dr. > Cr. > Dr. > Dr. > Cr. > Cr. > C

Re: $$Excel-Macros$$ Reset Macro After Excel Start up

Can you send the file directly to my address? (instead of broadcasting it to the entire group) Or.. there's a couple of things you can try: - After opening the workbook, hit "escape" or ctrl-break (ctrl-pause on some keyboards) This SHOULD open the panel asking to debug or continue. There's

$$Excel-Macros$$ Help required - alternate sorting

Hi, Can somebody please help me in a small macro. My sheet have a column with some values and I want to sort them alternately. Current Dr. Cr. Dr. Dr. Cr. Cr. Cr. Dr. Required Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Thanks in advance Krishan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d

$$Excel-Macros$$ Reset Macro After Excel Start up

Hello Experts, i have a program that i have designed in excel. the issue is that when i open the program i cant do anything unless i go to VBA and press on the reset button before i can proceed. when means a procedure is running but looking thru the codes i dont see any proceedure that runs, pleas

Fwd: $$Excel-Macros$$ Colour the Group Rows

Hello, Amazing macro Thanks a lot -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 7:01 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@googlegroups.com" Hi Check this...I have created to Macros, one for clearing format, press