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

Cai lon me chung may, spam nhieu the Carl Ross wrote: >-- Forwarded message -- >From: Carl Ross >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 attached a workbook if an

$$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 wrote: > Hi Mahesh, > > Open the code and repeat the following line twice (i.e. one more time) as > it is already there in the code:- > > Selecti

$$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: Count the number of times Macro ran - Urgent Question

Hi, You just need to find a unused cell near by, and use it as a recorder. If the unused cell is, say, E1, then your macro would look like this: Sub resetval_SCRUSH() Range("d1") = "0" Range("E1") = Range("E1") + 1 End Sub You may need to start by putting 0 (zero) into E1, but try without

$$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$$ 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 wrote: > >> >> I have a set o

$$Excel-Macros$$

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 SUBMISSI

$$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 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 in each month.

$$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$$ $$$$$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: =COUNTIFS(dates,"<11/1

$$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 - RESET

$$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 - RESET

$$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 Effe

$$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 wrote: > 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 problem, i want to

$$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 wrote: > Hello Guys, > > can somebody help me on attach file. > -- > > Regards, > Rabindra Thapa > ¨`·.·´¨) Always > `·

$$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 years

$$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$$ Re: 1>Hardcode a cell value to the code(macro code) |||||||||||||| 2>code 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. Imaginatio

$$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 conta

$$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 wrote: > > Hello Guys, > > can somebody help me on attach file. > -- > > Regards, > Rabindra Thapa > ¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep > (¨`·.·´¨)¸.·´ Smiling! > `·.¸.·´ > (¨`·.·´¨) (¨`·.·´¨) >

$$Excel-Macros$$ Re: 1>Hardcode a cell value to the code(macro code) |||||||||||||| 2>code 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 Ne

$$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 dilipan...@yahoo.

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

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 wrote: > 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

$$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: 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$$ Required help on subtotal function.

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

$$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 wrote: > Hi folks, > > Gud M

$$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 wrot

$$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) = c.O