$$Excel-Macros$$ Re: attendance sheet

Excellent work..I have a suggestion for u that when you want to present data in % percentage. Don't need to multiply by 100. Just go to farmate, number and percentage. Date: Wed, 15 Jul 2009 00:15:10 +0530 Subject: $$Excel-Macros$$ Re: attendance sheet From:

$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

Hi Mahesh Simply Select the Row and press ctrl + .. each + will add one row... given below is the macro for the same.. just select any cell in the row above which you want the new rows... == Sub InsertMultipleRows() number_of_rows = InputBox(Prompt:=How

$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

Hi Mahesh, Insert the below code in a new module. '___ ___ Sub Macro1() Range(A1).Activate ' Change A1 to Starting of Your Data and the column having

$$Excel-Macros$$ Re: tranpose question

Hello. Try the following macro : Sub test() Dim c As Range, myRow As Long myRow = 14 Range([A14], [D65000].End(xlUp)).Clear For Each c In Range([A4], [A4].End(xlDown)) Cells(myRow, 1) = c Cells(myRow, 2) = c.Offset(, 1) [C3].Copy Cells(myRow, 3) Cells(myRow, 4) =

$$Excel-Macros$$ Re: attendance sheet

Hello Yes Shafiq, you are correct. Wonder how sometimes we thing of the bigger picture but forget the basics -:) -:) Thanks for reminding me. -:) Thanks -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi On 7/15/09, shafiq online

$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com

$$Excel-Macros$$ Required help on subtotal function.

Hello Guys, can somebody help me on attach file. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`·.·´¨)¸.·´ `·.¸.·«*:·. .·:* *:·. *«*:·. .·:* *:·. --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: how to get the week no in a function

Hi Subbu, Assuming you have the date in Cell A1, use the following formula:- =WEEKNUM(A1) Use following for Week Day =WEEKDAY(A1,2) Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi -

$$Excel-Macros$$ Re: tranpose question

Hi Skanda, Solved workbook is attached herewith. Steps are also given in Sheet 1. Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 2:13 AM, Skanda

$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA

$$Excel-Macros$$ Re: how to get the week no in a function

Hello fnds I m sandeep. i m new member of excel maros group. i m from delhi. can some budy help me to learn maros functions. i will realley appricate, if u send me any matarial which is helpfull to learn macro or function's plzz send me ... Regards: ╚►♥ѕαη∂єєρ♥◄╝

$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

$$Excel-Macros$$ Re: 1Hardcode a cell value to the code(macro code) |||||||||||||| 2code to save only a particular cell value at the time of closing the workbook

Hello Mr. Bharghav, 1. To assigne a cell value to the macro, use following:- Sub test() Dim a As String a = Range(a1).Value End Sub ' here the value which is there in Cell A1 has been assigned to macro for characted a. 2. Go to Tools - Protection - Allow users to Edit Ranges. click on New and

$$Excel-Macros$$ Re: Required help on subtotal function.

Hi Rabindara, Solution is attached. Please have a look. Naveen Sharma On 7/15/09, Rabindra Thapa rabinthapa2...@gmail.com wrote: Hello Guys, can somebody help me on attach file. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨)

$$Excel-Macros$$ Feedback Web Page

Hi All, Can anyone help me with a feedback web page. Wherein if somebody post a feedback i can reveice in Mail, Access or Excel. I know this is not the right group to ask the question but if anyone can help then would be very grateful. Regards, Saurabh Patel DISCLAIMER:The information

$$Excel-Macros$$ Re: 1Hardcode a cell value to the code(macro code) |||||||||||||| 2code to save only a particular cell value at the time of closing the workbook

Hi, I think it will work better without using any variable. Try using the below code Sub PasteAsValue() Range(A1).Copy Range(A1).PasteSpecial xlPasteValues End Sub Regards, Manish Purohit Imagination is more important than knowledge. Knowledge is limited. Imagination

$$Excel-Macros$$ Re: Feedback Web Page

Dear Saurabh, Yeah your query is a little misplaced. however we are always happy to Help. [?] The easiest way to do this is to use the Form Mail system. This is free to work with as well. However there are various versions available and you can choose any as per your requirement. This Form Mail

$$Excel-Macros$$ Disable Select Multiple Items and All in PivotTable Report Filter

I would like to disable the 'Select Multiple Items' and '(All)' features from a PivotTable Report Filter (Page items). I do not know how to do it. I have data for multiple years that I would like to be able to see using the filter, but it makes no sense to add data together from different

$$Excel-Macros$$ Re: Required help on subtotal function.

Attached is a solution. Subtotal is not what you want to use. This is done with dynamic named ranges and data validation. Norman On Wed, Jul 15, 2009 at 6:07 AM, Rabindra Thapa rabinthapa2...@gmail.comwrote: Hello Guys, can somebody help me on attach file. -- Regards, Rabindra Thapa

$$Excel-Macros$$ Re: Separate Fields in fastest way

Hi, find the attach solution for your problem. Sandeep On Wed, Jul 8, 2009 at 10:50 AM, Deepak Rawat deepakrawa...@gmail.comwrote: Dear friends have attached a file in which all fields are merged and have to separate all fields as soon as possible. pl suggest me the way. there is another

$$Excel-Macros$$ Re: Is there any way to increase the size of an image in a excel cell when onmouseover?

You could put a copy of the image in a cell comment (the same cell with the small version of the image) Once you have added the cell comment, click edit comment, make sure you are on the outline of the comment, then click format comment, select colors and lines, drop down Color to Fill Effects,

$$Excel-Macros$$ Count the number of times Macro ran - Urgent Question

Hello, A newbie here and I think this should be really easy for othersI have a macro which reset cell value to 0 and I have created a text box and assign this macro to it. So everytime I click that box it resets D1 value to 0. I just want to have a count the number of times macro -

$$Excel-Macros$$ Count the number of times Macro ran - Urgent Question

Hello, A newbie here and I think this should be really easy for othersI have a macro which reset cell value to 0 and I have created a text box and assign this macro to it. So everytime I click that box it resets D1 value to 0. I just want to have a count the number of times macro -

$$Excel-Macros$$ $$$$$Plz Help !!!!!!!!!!!!!!$$$$$

Hello fnds I m sandeep. i m new member of excel maros group. i m from delhi. can some budy help me to learn maros functions. i will realley appricate, if u send me any matarial which is helpfull to learn macro or function's plzz send me .. -- Regards: ╚►♥ѕαη∂єєρ♥◄╝

$$Excel-Macros$$ Count days in a month

I have a set of dates in a column say {dates} and they go from today until 1/1/2000 (for example). I want to write a macro/vba to count the # of days in each month. I went through manually and checked the cells that were for the beginning /ending of the months and wrote:

$$Excel-Macros$$ How do I protect a module code so that user's cannot view the code or tamper with it?

Thanks Mog -- ** Omoghene Obahor www.obahor.com Cell: 214-493-7403 Fax: 866-338-1397 As a Man Thinks So is He ** --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Count days in a month

Do you want number of records for each months... Srinivasan E On Wed, Jul 15, 2009 at 10:45 PM, faheem3 fahe...@gmail.com wrote: I have a set of dates in a column say {dates} and they go from today until 1/1/2000 (for example). I want to write a macro/vba to count the # of days

$$Excel-Macros$$ BEST EXCEL TIPWEEK # 29Submit your TIP here only

Dear Members, Thanks to all contributors in the Week 28 competition. Let us begin week # 29 quiz with more spirit. Last Date of Submission of tips : 19th July 2009. PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE CONSIDERED FOR PRIZES. DO NOT START NEW THREADS OR POST FOR

$$Excel-Macros$$ Re: Count days in a month

pls find the attachment... Srinivasan E On Thu, Jul 16, 2009 at 6:56 AM, Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com wrote: Do you want number of records for each months... Srinivasan E On Wed, Jul 15, 2009 at 10:45 PM, faheem3 fahe...@gmail.com wrote: I have a

$$Excel-Macros$$ Best Excel Tip Award of Week # 28 goes to ****SASTRY B****

Hello Everyone, Please congratulate Sastry B for winning the Best Excel Tip award of Week # 28. The tip is all about using data list which increases over the time. I liked the way Sastry B has described the tip in the worksheet. MANY MANY CONGRATULATIONS SASTRY !! KEEP IT UP

$$Excel-Macros$$ Macros

Hiii ... I want to learn the macro functions, so if u have any files regarding basics of macro then plz mail to me. Thanks in Avance Regards vebhav jain --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the

$$Excel-Macros$$ Re: Dynamic Lookup.......Nobody can solve this.........too hard I guess

Cai lon me chung may, spam nhieu the Carl Ross kwi...@gmail.com wrote: -- Forwarded message -- From: Carl Ross kwi...@gmail.com Date: Sat, Jul 11, 2009 at 11:31 AM Subject: $$Excel-Macros$$ sorry, the file is attached now To: excel-macros@googlegroups.com I have