Re: $$Excel-Macros$$ Time Stamp Limited to Target Cells Within a Specic Range

Hi PFA Cheers! On Fri, Apr 25, 2014 at 4:47 PM, Mark Lefcowitz mlefcow...@gmail.comwrote: I want to be able to point-and-click to individual cells within a specified worksheet range and inset a now() timestamp: Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Re: $$Excel-Macros$$ RE: help required urgently

Hi You can format cell as DD-Mmm- or you can use formula =text(ref,DD-Mmm-) where ref is your reference cell. Thanks On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan neerajchauhan...@gmail.comwrote: Dear experts, We have given below date format how to convert right format of

Re: $$Excel-Macros$$ Need Formula

Hi you can do using combination of Index Match function. Thanks On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi, is there any solution in someproduct formula to get intersect text value in 2D range: Below is the data; Bran Model - 1 Model - 2 Model -

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

Hi What exactly you are looking for in VBA. Thx On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey divake...@gmail.com wrote: Hi Expert, can any one please share code to retrieve already applied conditional formatting on a cell or range of excel workbook through vba. Thank Regards,

Re: $$Excel-Macros$$ Extract Data on basis of different Criterias

HI Pl share sample file. Thanks On Wed, Jul 3, 2013 at 7:30 PM, SG sonal...@gmail.com wrote: Hi Experts, I want to create a report in which data would be extracted on basis of atleast 4 filters from base data sheet.please help me with a macro example. Thanks in advance. -- Are you

Re: $$Excel-Macros$$ Query in For Each Next

Hi X refer to each cell in range A1 to D5. Thanks On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Good Morning.. I got below macro from net ..Can you explain me what x stand here... *Sub Upper_()* *For Each x In Range(A1:D5)* *'For Each x In

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, chhajersand...@gmail.com wrote: Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And

Re: $$Excel-Macros$$ Need Help to lock cursor or sheet display.

Hi You can hide all unwanted col rows and protect workbook so that user will not be having access to that portion. Thanks On Mon, Jul 1, 2013 at 9:25 AM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, I have a data from Colum A to Column D in excel sheet, I want show only

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

! Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 12:52:50 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros

Re: $$Excel-Macros$$ Unable to Open Excel File... How to repair it..

Hey since you have sent corrupted file. we cant help you on that. Pl send original file before opening the same so we might recover. Thanks On Mon, Jul 1, 2013 at 11:27 AM, B Sharma sharma@gmail.com wrote: Dear Friends and excel experts,,, I am facing this problem 3-4 time and now I

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

name range! Hi, Vabs, Actually I have created name range Assets with formula like =(Input!$B$2:$B:$6 ) and another name range i.e. Assets1 with formula =offset(input!$B$2,0,0,counta($B:$B)-1,1) So in second case I.e in Dataval dynamic sheet I have tried to use 'Assets1' as name range instead

Re: $$Excel-Macros$$ Thought you'd find this interesting

Thanks On Mon, Jul 1, 2013 at 7:00 AM, raghu raghunandan.rallapa...@gmail.comwrote: ** Hi, I’ve just learned about the water crisis and thought you would be interested to check out this story:

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Last file is with vba solution. On 1 Jul 2013 21:23, chhajersand...@gmail.com wrote: ** Okay! I am not very proficient with VBA. If you pls help me out in this regard! Thanks Sandeep Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in

Re: $$Excel-Macros$$ show only last four digit of the number

(SUBSTITUTE(A1,-,),4) Regards, Kuldeep Singh On Fri, Sep 7, 2012 at 8:38 PM, in.va...@gmail.com javascript:wrote: ** First use Substitue fn to subst - with and then use Right function. Rgds Vabs -- *From: *maksood alam 786ma...@gmail.com javascript: *Sender

Re: $$Excel-Macros$$ Outlook to excel VBA

Dear Amar, Post your qery in new thread. Rgds Vabs On Friday, August 31, 2012 4:30:22 PM UTC+5:30, amar takale wrote: Dear Noorin All VBA Experts, This is very Challenging work for me also you Our other Excel users in group.I required VBA code when our research report published

$$Excel-Macros$$ Re: Required Revenue started from Date..

hii I tried doing without arrat formulae or vba.. Hope it doesnt throw error. Rgds//Vabs On Friday, August 31, 2012 6:05:54 PM UTC+5:30, Kuldeep Singh wrote: Hi Experts, I want to required Revenue started from Date. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789