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

Hi All, Can it be possible or I have to do same process which I am doing. Regards, Ankit On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal wrote: > Dear All, > > I have a salary sheets where there are three column i.e. Name, Department > and salary. I need department wise salary sheet but there i

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

HI ayush, Thanks its working but I need to like tables ,say 5x5 table size,can you please help me in this.! On Monday, October 15, 2012, Ayush Jain wrote: > Hey Vignesh > > This can simply be achieved by saving the excel file as html file by VBA code. > > Here is the code reference. > Activework

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

Hey Vignesh This can simply be achieved by saving the excel file as html file by VBA code. Here is the code reference. Activeworkbook.Sheets(1).range("A1").value = "This is my First HTML PAGE USING EXCEL MACRO" Activeworkbook.saveas "C:\Scripts\Test.htm", xlHTML Hope it helps. Let us know if yo

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

hi, Anybody can help how to create the Excel macro for creation of HTML page. Sample html file like " This is my First HTML PAGE USING EXCEL MACRO" -- Vignesh .S.R -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED f

RE: $$Excel-Macros$$ Learn Array formula's

Find few more Here are links to some online tutorials: * Array Formulas by Chip Pearson http://www.cpearson.com/excel/ArrayFormulas.aspx * Introduction to Array Formulas by Colin Legg. (His website www.colinlegg.co.uk may have an updated vesion b

RE: $$Excel-Macros$$ Learn Array formula's

Try this http://www.cpearson.com/excel/ArrayFormulas.aspx Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: Monday, October 15, 2012 01:39 PM To: excel-macros@googlegro

Re: $$Excel-Macros$$ Re: Ctrl+End Command

Dear Prince - matter has been resolved, but I want to brief what is the actual scnario, actually when you have got thousand of rows, file size automatically increase when you insert formulas or insert other formatting, & when you delete some unnecessary rows excel still captaure the rows, solution

RE: $$Excel-Macros$$ FW: oct'12 disconnection data.xlsx

Thanks kuldeep, But my query was How did lock it, and how can I lock it again From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: Monday, October 15, 2012 5:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ FW: o

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

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 the required file and automatically all the sheets name should displayed in a box from that i have to select one sheet and import that in

Re: $$Excel-Macros$$ FW: oct'12 disconnection data.xlsx

Hi Neeraj, Right Click in worksheet & click a ungroup sheet. see below snapshot: [image: Inline image 1] [image: Inline image 2] Regards, Kuldeep Singh On Mon, Oct 15, 2012 at 5:26 PM, Neeraj wrote: > Dear experts,. > > ** ** > > Kindly find the attached sheet, why the filter data lock

Re: $$Excel-Macros$$ Ctrl+End Command

got it thanks. Aamir Shahzad On Mon, Oct 15, 2012 at 4:34 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi Aamir, > > ** ** > > After deleting the rows and column close the excel and re-open the file..* > *** > > ** ** > > Then it will not got to the same address. > > **

RE: $$Excel-Macros$$ Ctrl+End Command

Hi Aamir, After deleting the rows and column close the excel and re-open the file.. Then it will not got to the same address. Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahz

$$Excel-Macros$$ Re: Ctrl+End Command

Hi Amir, I feel excel is correct in this senario, as it is pointing which was the last cell of used range, It doesnt matter it holds any value or not.But tell me what actual postion you want it should Go. regards Prince On Monday, October 15, 2012 11:53:12 AM UTC+1, Aamir Shahzad wrote: > >

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

Hi Chandru, Yes, you are correct some product always work on equal size of range. regards Prince On Monday, October 15, 2012 6:21:12 AM UTC+1, Chandru wrote: > > hi Group Member > > i have small doubt how to use Sumproduct Not Equal Rangelike >A B > 110100 >

$$Excel-Macros$$ Ctrl+End Command

Dear Group, When we use the Ctrl+end command, excel automatically move the last used cell, but when we delete the some rows or data excel still go where last cell was used, what should we do for this? Regards, Aamir Shahzad -- Join official facebook page of this forum @ https://www.facebook.co

$$Excel-Macros$$ Re: Combo [ Formula + Macro Bible] - [Prince 9953872217]

Thank you for sharing those guides. Appreciate . On Saturday, October 13, 2012 7:33:27 PM UTC+3, prince sethi wrote: > > > > -- > > > Regards > > [image: Description: cid:image003.png@01CBFC21.609970A0] > > > > -- Join official facebook page of this forum @ https://www.facebook.com/discus