Re: $$Excel-Macros$$ Require specific entry in a cell or nothing

Use data validation and specify the exact requirement. On Sat, Dec 18, 2010 at 4:07 AM, Richard richard.m...@gmail.com wrote: Is is possible to require a specific entry in a cell, or nothing? If someone makes an entry in a cell, I want it to be ABC (all upper case) and nothing else. It's OK

$$Excel-Macros$$ Create a new work book and copy the data from the excising work book

Hi experts Is it possible to create a new work book and copy the required to it from the excising file using a macro. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Run a macro every time excel is opened

I want a macro to run every time when an excel file is opened. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

Re: $$Excel-Macros$$ Create a new work book and copy the data from theexcising work book

Yes, Send your data sheet with ur requirements. Sent on my BlackBerry® from Vodafone -Original Message- From: Rajesh K R rajeshkainikk...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 18 Dec 2010 17:24:19 To: excel-macrosexcel-macros@googlegroups.com Reply-To:

$$Excel-Macros$$ Fwd: Solution to a Problem

-- Forwarded message -- From: Inderbir Singh inder...@gmail.com Date: Fri, Dec 17, 2010 at 2:08 PM Subject: Solution to a Problem To: xcel-mac...@googlegroups.com Hi Friends , I have a very big problem . I need to convert the following Text file into a Excel file in the following

Re: $$Excel-Macros$$ Run a macro every time excel is opened

write the code in workbook open module On Sat, Dec 18, 2010 at 5:04 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: I want a macro to run every time when an excel file is opened. -- -- Some important links

$$Excel-Macros$$ Re: Run a macro every time excel is opened

Create a sub called sub workbook_open in this workbook and call your macro. On Dec 18, 3:34 am, C.G.Kumar kumar.bemlmum...@gmail.com wrote: I want a macro to run every time when an excel file is opened. -- -- Some

$$Excel-Macros$$ AUTOFILTER

WHAT IS THAT MEANS With ActiveSheet.AutoFilter.Filters(2) IN AUTOFILTER CODE -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ unlock excel sheet

Dear sir, I forget my excel password and how can open my excel sheet so dear sir plz unlocked my excel sheet Thanks regards Rajiv Kumar -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ MS ACCESS

DEAR ALL, I WOULD LIKE TO MS ACCESS THROUGH ONLINE. CAN ANY ONE SUGGEST URL SITE OR SEND PDF FILE. THANKS IN ADVANCE KARTHIK -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

Re: $$Excel-Macros$$ Facing calculation issue using Time type in excel

Thanx Paul. On Thu, Dec 16, 2010 at 1:31 AM, Paul Schreiner schreiner_p...@att.netwrote: Keep in mind that Excel doesn't know time. It knows numbers. Time is simply the fractional part of a day 9:30 is 0.3958333 of a day. 10:00 is 0.417 of a day. so, 9:30 - 10:00

Re: $$Excel-Macros$$ problem in sumif

Hi Rajesh, You are welcome! --- Ms.Exl.Learner --- On Sat, Dec 18, 2010 at 4:56 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: hi Thanks for ur answer, i checked the formula , it is working well Regards Thanks Rajesh Kainikkara On 12/18/10,

Re: $$Excel-Macros$$ Missing Entries

Hi Vebhav, Have a look in the attached file. Hope it helps! --- Ms.Exl.Learner --- On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain vebhav.j...@gmail.com wrote: Hi All, Please help me in finding the missing entries from the below data. ListA

Re: $$Excel-Macros$$ Need ans for 3 que

hey deepak, thanks man but any idea about 1st que? 1. how can i get to know if a specific cell has formula or normal value? i.e if A1 has value or formula? From: Rohan Young rohan.j...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, 17 December, 2010 9:49:55 AM Subject: Re:

Re: $$Excel-Macros$$ Need ans for 3 que

hey Ashish, this link is too good man. THANKS A LOT DUDE. u made my day. awesome stuffs but can u or somebody help me with below 1 line Dim FSO As Object Set FSO = CreateObject(scripting.filesystemobject) what does this line do. From: ashish koul koul.ash...@gmail.com To:

$$Excel-Macros$$ Macro security help

hey guys i think this must tough. 1. is there any functionality through which i can get to know if anybody has done Alt +F11 i.e. edit on my macro. 2. how can i get to know if a specific /cells have formula or value? thanks, hanumant --

Fwd: $$Excel-Macros$$ cumulative sum in pivot table

Hi Alisha, Find attached file saved in excel 2003. Regards Kantilal -- Forwarded message -- From: alisha malhotra alisha.malhotr...@gmail.com Date: Wed, Dec 15, 2010 at 6:44 PM Subject: Re: $$Excel-Macros$$ cumulative sum in pivot table To: excel-macros@googlegroups.com Hi

$$Excel-Macros$$ Excel userform Vlookup List iteam help

Dear experts I want use userform and in that a list iwant to use iteam from that list.More i want to use vlookup function or similar code when in list box we enter known iteam then by vlookup its info shold populated on user form and that data should copy to another sheet. Thanks --

Re: $$Excel-Macros$$ Need ans for 3 que

use this function Function checkformula(x As Range) checkformula = x.HasFormula End Function check the attachment On Sun, Dec 19, 2010 at 1:49 AM, hanumant shinde arsfan2...@yahoo.co.inwrote: hey deepak, thanks man but any idea about 1st que? 1. how can i get to know if a specific