$$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move

2012-10-17 Thread Sundarvelan N
Dear Gurus, Please help me in repeating the macro for each cursor move. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-17 Thread Vignesh S R
Hi All,, Thanks for the timely help.. Regards, Vignesh.S.R -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Pls help me on this.

2012-10-17 Thread अनिल नारायण गवली
Dear noorian, Pls help me awaiting for your reply On Mon, Oct 15, 2012 at 5:37 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Groups and Noorian, I want a macro that import other worksheets in a excel workbook by using filedailogbox . 1) when filedailogbox opens i have to select

$$Excel-Macros$$ Solve the problem

2012-10-17 Thread Rajesh Agarwal
Dear Sir I want to put formula on column B. Rgds -- *Rajesh Kumar Agarwal* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Solve the problem

2012-10-17 Thread Aamir Shahzad
PFA Aamir Shahzad On Wed, Oct 17, 2012 at 3:16 PM, Rajesh Agarwal rajey...@gmail.com wrote: Dear Sir I want to put formula on column B. Rgds -- *Rajesh Kumar Agarwal* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members

Re: $$Excel-Macros$$ Pls help me on this.

2012-10-17 Thread Paul Schreiner
Was the solution I provided insufficient?   Paul - “Do all the good 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

Re: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move

2012-10-17 Thread Paul Schreiner
You explanation is somewhat vague.. By breaking it down into individual definitions: Repeating the macro implies that you have a macro in mind.. good start. cursor is a general term referred to the type-in bar, usually a vertical bar (|) or underscore (_). cursor move would then be movement

Re: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move

2012-10-17 Thread Sundarvelan N
Please find the attached file for your reference Opne the file enable the macro and press ctrl+m and click any where in the excel you will find my requirement. I need this task should be completed by mouse/keyboard move. Thanks N.Sundarvelan 9600160150 On Wed, Oct 17, 2012 at 5:26 PM, Paul

Re: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move

2012-10-17 Thread Paul Schreiner
Your attachment didn't contain any macros. So, ctrl-m didn't have any affect. I also noticed that you have not ASKED for anything. What you've done is provided a reference. which consists of an excel file with one row and column highlighted in blue. You then instructed us to open your reference,

RE: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move

2012-10-17 Thread Rajan_Verma
Will you please elaborate ? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: 17 October 2012 11:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro Help: Repeat

RE: $$Excel-Macros$$ Solve the problem

2012-10-17 Thread Rajan_Verma
Is it you are looking for? =NETWORKDAYS(A2,A2+25,$E$2:$E$17) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh Agarwal Sent: 17 October 2012 3:46 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ For Indian Accountants Taxation professional. Check ISPANVALID

2012-10-17 Thread Sam Mathai Chacko
Similar Thread here too On Wed, Oct 17, 2012 at 7:24 PM, Vabz v...@vabs.in wrote: Hi I have created a function to find our invali PAN. This Function Highlights invalid character with Red Font Also mentions error. Please refer attachment for details. Pl share your comments. Cheers..

Re: $$Excel-Macros$$ For Indian Accountants Taxation professional. Check ISPANVALID

2012-10-17 Thread Sam Mathai Chacko
http://www.excelfox.com/forum/f13/validating-pan-indian-format-409/ On Wed, Oct 17, 2012 at 8:39 PM, Sam Mathai Chacko samde...@gmail.comwrote: Similar Thread here too On Wed, Oct 17, 2012 at 7:24 PM, Vabz v...@vabs.in wrote: Hi I have created a function to find our invali PAN. This

Re: $$Excel-Macros$$ For Indian Accountants Taxation professional. Check ISPANVALID

2012-10-17 Thread Vabz
Hi Sam Thanks for information, Its me who got customised from initial posting. Rgds//Vabs On Wednesday, October 17, 2012 8:40:34 PM UTC+5:30, Sam Mathai Chacko wrote: http://www.excelfox.com/forum/f13/validating-pan-indian-format-409/ On Wed, Oct 17, 2012 at 8:39 PM, Sam Mathai Chacko

Re: $$Excel-Macros$$ VBA code to export from excel to word *

2012-10-17 Thread ashish koul
Hi Hilary I would suggest first you create proper tables in excel and . Avoid merge cells ,etc. Then in world create a template again with proper tables , etc . so that you know the row and column no of each cells Once u know the rows and columns of word u can write macro to export data from

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting)

2012-10-17 Thread ashish koul
share excel file and word document or visit http://www.excelvbamacros.com/2011/11/find-row-and-column-number-of.html http://www.excelvbamacros.com/2011/10/copy-range-from-excel-and-paste-as.html On Wed, Oct 17, 2012 at 10:07 AM, amar takale amartak...@gmail.com wrote: Pls help me for this

Re: $$Excel-Macros$$ VBA code to export from excel to word * *

2012-10-17 Thread Hilary Lomotey
Thanks Ashish Really really grateful for your effort. PDF however will not work for me, i managed to use this code below and its working for me about 95%,, which is ok. the only issue with this code is that after exporting to word, you have to double click it in it for it to preview it in the

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

2012-10-17 Thread Hilary Lomotey
try this Sub exportToWord() Dim SheetName As String, NumLines As Integer Dim WordApp As Object Set WordApp = CreateObject(Word.Application) WordApp.Visible = True Worksheets(SheetName).Range(frontcover).Copy 'you can replace the next line of code with

Re: $$Excel-Macros$$ Query related to Salary binding up

2012-10-17 Thread Haseeb A
Hello Ankit, Attached is a one way. This is not a best one, some one will have better options. I have added two columns. One is Dpmt% 2nd one is No: of Dpmt, which is return through a formula. No:of Dpmt column, MUST NOT be empty or zero. Better to use dynamic range or convert your range to

$$Excel-Macros$$ Re: Suproduct not equal range

2012-10-17 Thread Haseeb A
Hello Chandru, Fiirst of all, I am not sure where is these conditions in the sample, you provided. (a1:a5=1)*(a1:a5=4). I only can see two columns in the sample. ColA: 10;20;30;40;50. ColB 100;200;300;400;500. Anyway, you can use ISNA(MATCH or COUNTIF to check LIST 2 is NOT contains in

Re: $$Excel-Macros$$ Excel Graph Problem

2012-10-17 Thread prkhan56
Hello there, Thanks for the reply Can you guide me how to setup my data please? Regards Rashid Khan On Tuesday, October 16, 2012 9:31:53 PM UTC+4, Sushil Kumar wrote: Hi Rashid, Your graph not correct and graph looks the image of waterfall chat so you need to setup the cross of x-axes and

RE: $$Excel-Macros$$ VBA Code Related Question

2012-10-17 Thread Asa Rossoff
Hi Amar, In your attached file, there is no VBA code attached to the worksheet itself, thus there is nothing to copy or move. The VBA code in your file (of which there is a lot) is in various other objects: several standard modules, perhaps 15 or 20 class modules, several userforms, and the

$$Excel-Macros$$ Fwd: FW: FYIP

2012-10-17 Thread Shrinivas Shevde
**Dear Group Members, I am using Excel 2010 .I was trying to copy paste a data from one workbook to another workbook. I am getting following message Can anyone explain me what is this problem and how to overcom it. It is not a shoe stopper ** Regards Shrinivas

Re: $$Excel-Macros$$ Fwd: FW: FYIP

2012-10-17 Thread अनिल नारायण गवली
R u using Mozilla firefox then manage Addon . Regards, Gawli anil On Thu, Oct 18, 2012 at 10:23 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: **Dear Group Members, I am using Excel 2010 .I was trying to copy paste a data from one workbook to another workbook. I am getting following

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting)

2012-10-17 Thread amar takale
Hi Ashish Thanks for reply for solution is very good.I will attached file in which One table I want to copy this table in word through VBA code Button as it with formatting.If there are increase person name Then I will change only range table then automatically that range table copy paste in

$$Excel-Macros$$ Hard to find Status for me...

2012-10-17 Thread Manoj Kumar
Dear Expert. Please help me.. File attached below.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,