Fwd: Fwd: $$Excel-Macros$$ Extra Space & Enter to be removed from a cell

Thanks DP again. -- Forwarded message -- From: De Premor Date: Mon, Aug 26, 2013 at 4:46 PM Subject: Re: Fwd: $$Excel-Macros$$ Extra Space & Enter to be removed from a cell To: excel-macros@googlegroups.com =TRIM(SUBSTITUTE(C2,*CHAR(10)*," ")) SUBSTITUTE is to replace somestri

Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

Hi Team, Awaited for your expertise advice. Thanks & Regards, Lucky S -- Forwarded message -- From: Zibraan Date: Mon, Aug 26, 2013 at 7:36 PM Subject: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating To: excel-macros@googlegroups.com Hi Team, Ple

Re: $$Excel-Macros$$ Output Requier in Vertical

Dear Sir, Range("a2:a15").Cells(K, 1) out would be like ABDE.continue but how it come AABCCDDDEEFHHHIIJKLLMN Please explain. It working very fine as per my desire output On Wed, Aug 28, 2013 at 10:34 AM, xlstime wrote: > PFB > > > Sub amit() > For K = 1 To Range

Re: $$Excel-Macros$$ Output Requier in Vertical

Different method to get little faster Sub Amit() Dim Data As Range, Buffer() Dim iRow As Long, iCol As Long, iCount As Long Dim tStart As Double tStart = Timer Set Data = Range("A1").CurrentRegion ReDim Buffer(1 To Data.Count, 1 To 2) For iRow = 2 To Data.Rows.Count

Re: $$Excel-Macros$$ Output Requier in Vertical

PFB Sub amit() For K = 1 To Range("B2:X15").EntireRow.Count For P = 1 To Range("B2:X15").EntireColumn.Count Range("AA500").End(xlUp).Offset(1, 0).Value = Range("B2:X15").Cells(K, P) Range("AA500").End(xlUp).Offset(0, -1).Value = Range("a2:a15").Cells(K, 1) Next Next End Sub ...

$$Excel-Macros$$ Output Requier in Vertical

Dear All, Very Good Morning , I have made macro but i am able to extract output in only one column but i want it in 2 column . Please help me in this regards, Thanks in Advance. Regards, Prafull -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

Re: $$Excel-Macros$$ MouseOver/MouseHover Event On Autoshapes

you are great man... it really helped. This is what i was looking for. Both the links are really useful. Thanks a ton Regards, Rahul V M On Mon, Aug 26, 2013 at 7:27 PM, ashish koul wrote: > you can use the hyperlink method given by Jordan which he has used in us > map . link below > > http:/

Re: $$Excel-Macros$$ Re: listbox issue

thanks Mate really nice solution.   regards,   Pawel From: Bé Trần Văn To: excel-macros@googlegroups.com Sent: Monday, August 26, 2013 2:49 PM Subject: Re: $$Excel-Macros$$ Re: listbox issue You reference List Box in User Form follows: - To enter data in

$$Excel-Macros$$ vba code which gives the value according to the condition

Hi n thanks i want a vba code like if in a row 3 value is abc and on the cells on (2,1) is correct or incorrect so take the value according to that row with correct or incorrect example correct incorrectcorrect incorrect incorrect 3 abc 123

Re: $$Excel-Macros$$ Datavalidation

It cannot be done without Macros / VBA - if that's what you're asking. On Tue, Aug 27, 2013 at 12:47 PM, Smitha S R wrote: > Hi , > > Please help.. > > > On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R wrote: > >> Hi, >> >> Please suggest option to prevent copy paste in cells with data validatio

Re: $$Excel-Macros$$ Datavalidation

You can use cut and paste opetion . Enjoy Team XLS On Tue, Aug 27, 2013 at 12:47 PM, Smitha S R wrote: > Hi , > > Please help.. > > > On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R wrote: > >> Hi, >> >> Please suggest option to prevent copy paste in cells with data val

Re: $$Excel-Macros$$ Datavalidation

Hi , Please help.. On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R wrote: > Hi, > > Please suggest option to prevent copy paste in cells with data validation . > Please suggest other than macros > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:O