Re: $$Excel-Macros$$ How to do an automation for copy paste, added new row? (macro)

Hi, PFA Thanks Team XLS On Sun, Mar 3, 2013 at 12:52 AM, artforart artforart wrote: > Hello > I have attached file > > I want to automated a some step (tab table Z) > > Thus, for example, that in X 2012: > > 1) I want to copy D16:E16 > 2) added a new one

$$Excel-Macros$$ xlfn

Hello Everyone, I Received one excel file, in which I am seeing formulas starting with ="xlfn.". I am just curious what this xlfn is, this is for the first time I saw such formula. Can any one help me ? Regards, Airen -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’

Re: $$Excel-Macros$$ xlfn

visit this to know more http://office.microsoft.com/en-in/excel-help/issue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-HA010204569.aspx I guess you might be using Excel 2003 .Actually Excel replaces any function with xlfn if its not available in current version. For example my friend is usi

Re: $$Excel-Macros$$ xlfn

Unfortunately in VBA the True/False results are not coerced into values like they are on a worksheet, and a type mismatch occurs. regards Prince On Sun, Mar 3, 2013 at 9:31 PM, Airen wrote: > Hello Everyone, > > I Received one excel file, in which I am seeing formulas starting with > ="xlfn.".

$$Excel-Macros$$ Re: Rats can establish Brain-to-Brain interface connections

Why all these stuff are here. I think this is not the best place to spread these information. This place is only for VBA and Excel. So Plz Follow the Forum Rules else Go away. On Sunday, March 3, 2013 1:35:11 AM UTC+5:30, Zee Wow wrote: > > Rats Invasion confirmed, The world's first Brain-to-B

Re: $$Excel-Macros$$ How to do an automation for copy paste, added new row? (macro)

Hi thank u for help offset is good for names. But what about date.? I've got some macro code. But there is some problems 1) with loop macro: I use macro only for sheet: table Z. When I start macro then added me next year below from source date. For example when I want to got 2012 I added a sourc

$$Excel-Macros$$ Re: Extract Data from single cell

W dniu piątek, 1 marca 2013 12:48:12 UTC+1 użytkownik amar takale napisał: I don't know what is your question. If u want to extract using: > *Date -> text as column -> constant width a*nd and U adding require split > columns for date > For date with *dash* using as separator for split colu

$$Excel-Macros$$ Re: Extract Data from single cell

Hi Amar, Try This, Sub test() Dim rngData As Range With ThisWorkbook.Worksheets("Sheet1") Set rngData = .Range("A1").CurrentRegion rngData.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, Consecutive

$$Excel-Macros$$ Macro Help

Dear Team, Please amend macro in attached sheet to automatically select range based on cell value. Thx in advance Regards, Prashant -- 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) ! Join official Facebook page of this forum @ https://www.face

$$Excel-Macros$$ Arrow Up & down Query +Sign (+) & (-)

Dear Experts Team I have small query in excel,i give detail information in Attached sheet Pls sloved my query Amar -- 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) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Arrow Up & down Query +Sign (+) & (-)

pls give some more query ... Warm Regards, Gawli Anil On Mon, Mar 4, 2013 at 11:50 AM, amar takale wrote: > Dear Experts Team > I have small query in excel,i give detail information in Attached sheet > Pls sloved my query > Amar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

Re: $$Excel-Macros$$ Macro Help

why using macro?... just select hole column and change format Regards, Team XLS On Mon, Mar 4, 2013 at 11:21 AM, Prashant Pawle wrote: > Dear Team, > > Please amend macro in attached sheet to automatically select range based > on cell value. > > Thx in advance > > Regards, > > Prashant > > -

Re: $$Excel-Macros$$ Arrow Up & down Query +Sign (+) & (-)

pls see the attached sheet is it ok? Warm Regards, Gawli Anil On Mon, Mar 4, 2013 at 12:24 PM, अनिल नारायण गवली wrote: > pls give some more query ... > > Warm Regards, > Gawli Anil > > On Mon, Mar 4, 2013 at 11:50 AM, amar takale wrote: > >> Dear Experts Team >> I have small query in excel,i gi

$$Excel-Macros$$ Re: Macro Help

Please Use This It may help You. Sub test() Dim rngData As Range Dim intCol As Integer Dim intRow As Integer Dim strCol As String With ThisWorkbook.Worksheets("Sheet1") Set rngData = .Range("A1").CurrentRegion intRow = rngData.Rows

Re: $$Excel-Macros$$ Arrow Up & down Query +Sign (+) & (-)

Hi Amar, i thik it is possible. but in another cell using Indirect,index and match formula Thanks Team XLS On Mon, Mar 4, 2013 at 11:50 AM, amar takale wrote: > Dear Experts Team > I have small query in excel,i give detail information in Attached sheet > Pls sloved my query > Amar > > -- > Are